Cyclistic Rider Dashboard in Tableau
The Tableau half of my Cyclistic capstone, so the marketing team can dig into rider behavior without touching my SQL.
- Role
- Data Analyst
- Date
- Nov 1, 2023
- Primary
- Tableau
- Tableau
- Data Viz
- Data Analysis
The problem
The analysis findings sat in notebooks and articles, which is fine for a reader but useless for the marketing team in the capstone scenario. They needed self-serve exploration, a place where they could compare casual and annual member riders and answer their own questions.
What I built
I built an interactive Tableau dashboard on top of the cleaned trip data, with bar charts, histograms, maps, and heat maps. Every view keeps the casual versus member comparison on screen, whichever question you are asking.
How it works
Each view answers one question. Bar charts compare trip volume between the two rider groups. Histograms show how trip lengths differ, which matters when thinking about what members get out of a subscription. Maps highlight the top stations for each group, and heat maps show when rides happen across the week. The marketing team would use these views to pick where and when to run a conversion campaign, for example targeting weekend afternoons at the recreational stations where casual riders cluster.
The dashboard also joins the trips to monthly average temperatures for Chicago in 2016, so the seasonal dip in rides sits next to the weather that explains it.
The analysis behind the dashboard is in Cyclistic Rider Analysis with SQL and Python, and the Python side is written up in Diving Into Customer Data Analysis Using Python.