• Tableau visualization : https://public.tableau.com/app/profile/wajahat.ali2627/viz/CyclisticBikeRentalServiceAnalysisCapstoneProjectforGoogleDataAnalyticsCourse/CyclisticDashboard)
• SQL Queries used: https://github.com/DablewCodes/Cyclistic-Rental-Service-Analysis/blob/main/Quries.sql
A detailed and thorough step-by-step analysis process performed on the Cyclistic Bike Rental Service dataset to answer the following stakeholder questions:
- 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?
Dataset was orginally taken from https://divvy-tripdata.s3.amazonaws.com/index.html (Only for year 2021)
You can find my version of 12 month combined dirty and clean dataset here: https://drive.google.com/drive/folders/1SUcNHeHsHUkfsjkKNCX0RarrBh7sej40
Analysis procedure:
Download all of the monthly subsets
Import to BigQuery individually
Combine into 1 complete superset
Clean-up
Analyze
Create visualization in Tableau
Technologies used:
• Excel
• BigQuery/SQL
• Tablaeu