Cyclistic Bike-Share Analysis
How do casual riders and annual members use bike-share differently? I cleaned and analyzed 1,430,076 trip records in Google BigQuery, comparing ride duration, weekday activity, monthly trends, and hourly patterns. I then built an interactive Tableau dashboard with four visualizations and wrote marketing recommendations for converting casual riders into members.
- SQL
- Google BigQuery
- Google Sheets
- Tableau
Members rode most on weekdays at commuting hours; casual riders peaked on Saturdays.