googledataanalytics_casestudy1

Google Analytics Capstone Project using Cyclistic (Divvy) bike data

This Case Study was completed as part of the Google Data Analytics Professional Certificate.

Objective (Ask Phase)
To analyse how annual members and casual riders use Cyclistic bikes differently in order to determine the best marketing strategy to convert casual riders into annual members.

Prepare Phase
The data was downloaded directly from the Divvy Bikes website: https://www.divvybikes.com/system-data

Process & Analyse Phase
After regularising and importing the data, the first step was to inspect each attribute for anomalies. Whole analysis and new variables are created in Kaggle via R programmin. You may view it here: https://www.kaggle.com/code/vigneshnokanaidu/google-data-analytics-capstone-track-1

Share Phase
Visualisations were created using Tableau. Published here :
https://public.tableau.com/app/profile/vignesh3092/viz/Vignesh_GDACapstoneProject/Sheet6
https://public.tableau.com/app/profile/vignesh3092/viz/GDACapstoneProject-LocationDemographic/Dashboard1

Act Phase
A powerpoint presentation was compiled to communicate findings and relevant next steps for stakeholders :
https://docs.google.com/presentation/d/e/2PACX-1vTZusHYD4E7aASSw1JhrGYRUoAi7JPYpVLxuQEU1_0k4Yh2eUMfpOAqSSfOs3BAzjgQMQXfgsCt9YF1/pub?start=false&loop=false