top of page

Providing expansion campaign targets for an urban bikeshare.

Given a bikeshare database, what insights or questions can be answered by this data? We chose to focus on creating an expansion campaign for Divvy Bikes in Chicago. Divvy Bikes datasets from 2016 to 2019 were already provided, and we gathered 2020 e-scooter data ourselves from Chicago's public data portal. Comparative analysis and outside research done independently.

Data was extracted with SQL and cleaned using Excel and PowerBI. Visualizations were created in PowerBI.

bottom of page