📊 Cyclistic Bike-Share Case Study
This project is an end-to-end data analysis case study exploring how annual members and casual riders use Cyclistic bikes differently, with the goal of helping the company design effective marketing strategies to increase annual memberships.
🚀 Business Task
Analyze 12 months of Cyclistic bike trip data to understand usage patterns between casual riders and annual members, and recommend strategies to convert casual users into paying annual members.
📁 Data Sources
Public historical trip data provided by Motivate International Inc. 12 CSV files covering one full year of Cyclistic ride data Personally identifiable information (PII) removed for privacy compliance
🧹 Data Cleaning & Processing
Steps followed:
- Loaded & inspected all monthly datasets
- Standardized column names and formats
- Added calculated fields: ride_length, day_of_week
- Removed duplicates, null values, and invalid entries
- Combined all months into a single consolidated dataset
- Performed quality checks for consistency
🔍 Analysis Summary
- Key analytical steps included:
- Descriptive statistics (mean, max, mode, distribution trends)
- Pivot tables to compare usage by membership type
- Seasonal, daily, and hourly usage trends
- Identification of behavioral differences between rider groups
Key Insights Found:
- Casual riders take longer rides, primarily on weekends
- Members ride more frequently and mostly on weekdays
- Casual riders favor leisure trips, while members often commute
- Membership users exhibit consistent year-round riding behavior
📊 Visualizations
- The project includes:
- Ride length comparisons
- Day-of-week usage patterns
- Monthly and seasonal trends
- Ride count distributions for both user types
- Charts highlighting user behavior differences
🗂️ Project Structure
- /data → Raw and cleaned datasets
- /notebooks → Analysis, EDA, and visualizations
- /outputs → Summary tables, charts, and final insights
- README.md → Project overview
🛠️ Tools Used
- Excel / Google Sheets
- SQL
- R / RStudio (optional template used for merging & analysis)
- Tableau / Google Slides for visualization