Cyclistic is a fictitious bike-share company used in a case study as part of the Google Data Analytics Certificate course offered through Coursera. I used rider data to understand how casual riders and annual members use Cyclistic bikes differently to inform a new marketing strategy to convert casual riders into annual members. Below are the supporting files used to summarize my findings. Enjoy!
The following slide deck summarizes the case study including a list of recommendations based on the analysis. Supporting figures and files also appear beneath for convenience.
Visualizations created in Tableau Public also viewable here: https://public.tableau.com/app/profile/anthony.pena6407/viz/CyclisticCasualandMemberRiderAnalysis/Story1
Below is the data processing performed in R which also includes SQL queries run via the 'sqldf' package in R also viewable here: https://rpubs.com/agpena22/cyclistic_2022_rider_analysis