This case study is capstone project of Google Data Analytics course, here I will be analysing data provided by Chicago's bike share company to understand how it's users are using their services and propose solutions to increase company profits by converting casual users to premium one (with membership). The case study uses workflow proposed by Google consisting of 6 steps: Ask, Prepare, Process, Analyze, Share and Act.
Python:
- pandas
- matplotlib
- plotly
- folium
- geopandas
Design marketing strategies aimed at converting casual riders into annual members.
- Bike Ride Data: The data is provided by Motivate International Inc. and is available under the Divvy Data License Agreement.
-
Chicago Community Boundaries:
Community boundary data is sourced from
this Kaggle dataset.
Note: Some rides originated outside Chicago, particularly in Evanston. To ensure accurate geographical analysis, Evanston was manually added to the GeoJSON file using geojson.io.
- How do annual members and casual riders use Cyclistic bikes differently?
- Why would casual riders buy Cyclistic annual memberships?
- How can Cyclistic use digital media to influence casual riders to become members?
- The data has been imported from 2024 statistics from here:
- 202401-divvy-tripdata.csv
- 202402-divvy-tripdata.csv
- 202403-divvy-tripdata.csv
- 202404-divvy-tripdata.csv
- 202405-divvy-tripdata.csv
- 202406-divvy-tripdata.csv
- 202407-divvy-tripdata.csv
- 202408-divvy-tripdata.csv
- 202409-divvy-tripdata.csv
- 202410-divvy-tripdata.csv
- 202411-divvy-tripdata.csv
- 202412-divvy-tripdata.csv
- Loaded source data into pandas dataframe with revelant columns and converted to more efficient datatypes for better memory processing. Which resulted in change from 3.3 GB memory usage to 409.7 MB
<class 'pandas.core.frame.DataFrame'>
Index: 5860568 entries, 0 to 178371
Data columns (total 11 columns):
# Column Dtype
--- ------ -----
0 ride_id string
1 rideable_type category
2 started_at datetime64[ns]
3 ended_at datetime64[ns]
4 start_station_name category
5 end_station_name category
6 member_casual category
7 start_lat category
8 start_lng category
9 end_lat category
10 end_lng category
dtypes: category(8), datetime64[ns](2), string(1)
memory usage: 409.7 MB
- Preliminary data analysis
- Removed from dataframe:
- records that had N/A values in station names
- records with duplicate ride id
- records with same start, end time and same start, end station
- records with rides that lasted less than 10 seconds
- Created new columns needed for further analysis:
- ride duration column
- weekday of when ride started
- month of when ride started
- Sorted dataframe by when ride started
Analysis and Share were done in same step so I can instantly visualise data when searching for patterns.
-
User Type Activity (2024)
.png)
- Registered members' activity is about 1.8 times that of casual users (over 1.1 million records).
-
Ridable Type Activity (2024)
.png)
- Classic bikes are used about twice as often as electric bikes.
- Electric scooters have very low usage - potential area for growth (requires further analysis).
-
Weekday Users Activity by Subscription Type (2024)
.png)
- Members show weekday commuting patterns, indicating work-related use.
- Casual users peak on weekends - mostly used for leisure, shopping, and errands.
-
Monthly Ride Activity by Subscription Type (2024)
.png)
- Membership usage exceeds casual usage by 10,000-30,000 rides throughout the year.
- Significant rise in activity between May and September; drop-off begins in October.
- Late summer shows peak activity for both groups.
-
Monthly Ride Activity by Bike Type (2024)
.png)
- Classic bikes dominate during warmer months - show more seasonal volatility.
- Electric bikes maintain consistent usage throughout the year.
- Electric scooters were discontinued after 5 weeks.
-
Monthly Ride Activity by Subscription and Bike Type (2024)
.png)
- Both membership and casual users show preference towards Classic Bikes
-
Monthly Ride Duration Average by Subscription Type (2024)
.png)
- Casual riders have longer average ride durations than members.
- Ride durations increase during warmer months.
-
Spikes observed:
- Late December - likely due to holidays.
-
Mid-January - possibly caused by:
- Dedicated sports riders with longer ride habits.
- Slow speeds due to icy conditions (coldest week per weather report).
-
Casual vs. Member Activity at the Most Popular Station (2024)
.png)
- Streeter Dr & Grand Ave is the most used station, dominated by casual users.
- Different usage patterns imply different station roles (commuting vs. tourism).
-
Casual vs. Member Usage at the Most Popular Station by Casual Riders (2024)
.png)
- High casual activity at stations near scenic areas suggests tourist or occasional use.
-
Ride Activity by Chicago Communities (2024)
.png)
- Most ride activity occurs in central-northern lakefront communities.
-
Casual vs. Member Activity in Chicago Communities (2024)
.png)
.png)
- Communities with significant casual rider presence:
- Near North Side
- Loop
- Near West Side
- Lincoln Park
- Lake View
- West Town
- Hyde Park
- Near South Side
- Uptown
- Logan Square
- Communities with significant casual rider presence:
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
-
How do annual members and casual riders use Cyclistic bikes differently?
- Weekday usage - Users with memberships use services for daily commuting, showing work-related patterns, while casual riders' activity peaks on weekends, indicating they use services for tourism and recreation
- Seasonal pattern - The gap between member and casual user activities tends to be biggest in colder seasons, and the gap closes during warmer seasons
- Ride duration - Casual riders tend to take longer trips lasting more than 20 minutes, compared to members who average around 12 minutes
- Location preference - Percentage-wise, tourist areas attract more casual riders, whereas users with memberships are spread more evenly across Chicago communities
-
Why would casual riders buy Cyclistic annual memberships?
- Discounts - Casual riders who realize they are using the service often enough that they could save money by buying a membership
- Convinient usage - Members can rent a bike quicker without needing to purchase a pass each time
- Sport active lifestyle - Casual riders who decide to commit to riding every day for sport
- Work - Casual riders who start working in Chicago, making biking a daily part of their commute
- Eco-friendliness - Some may upgrate for environmental reasons
-
How can Cyclistic use digital media to influence casual riders to become members?
- Geo-targeted advertisements - Chicago's central-northern lakefront communities show the biggest activity of casual users, which are good locations to start an advertisement campaign
- Pre summer campaign - Launch an advertisement campaign right before peak seasonal activity when the casual user base rises
- Usage Pattern Messaging - Highlight how much casual users would save after their rides if they were subscribers, compare their monthly expenses as casuals to membership costs
- Weekend package - Offer a weekend-only package for users using the services for leisure and recreation
- Tourist plan - One- or two-week-long membership plans for tourists visiting
- Group plan membership - Casual users visiting Chicago during weekends can use group plans
- Duration discount - Casual users on average ride longer than members - introduce duration based discounts