Independent case study
Divvy bike-sharing: rider behaviour and membership strategy
Original version · Revision needed
- Tools
- SQL Server · Power BI
- Data
- Divvy trips · January–December 2022
- Write-up published
- January 2025
How do casual riders and annual members use a bike-sharing service differently?
I explored this question using Divvy trip records for the Cyclistic case-study scenario. The project combines SQL data preparation with Power BI reporting to inform a proposed membership-marketing strategy.
Data preparation
Combined monthly trip files in SQL Server and prepared query outputs for analysis.
Analysis
Compared trip duration, timing, bike types, stations and routes across rider groups.
Reporting
Presented charts and maps in Power BI, with proposed membership offers and marketing recommendations.