Skip to content

Viggy1357/googledataanalytics_casestudy1

Repository files navigation

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