Embarked on a comprehensive analysis of Cyclistic, a prominent bike-share company in Chicago, as part of the Google Data Analytics Professional Certificate Capstone Project. Leveraged R, BigQuery, SQL, and Tableau to delve into historical bike trip data with the primary focus on understanding the distinctions between casual riders and annual members. The overarching goal was to equip the marketing team with actionable insights for converting casual riders into loyal annual members, thereby fueling the company’s sustained growth.
Key Components:
- Data Collection and Exploration:
- Utilized R and SQL to gather and explore historical bike trip data, ensuring a foundational understanding of the dataset.
- Data Cleaning and Preprocessing:
- Employed R for data cleaning and preprocessing to address any anomalies or missing values, ensuring the integrity of the analysis.
- Descriptive Analytics:
- Utilized BigQuery and SQL to perform descriptive analytics, uncovering key trends, patterns, and summary statistics related to bike trips.
- Segmentation Analysis:
- Employed R to segment data between casual riders and annual members, understanding their respective behaviors and preferences.
- Statistical Analysis:
- Conducted statistical tests to identify significant differences between casual and annual riders, providing quantitative insights.
- Data Visualization:
- Developed visually compelling dashboards and charts using Tableau, allowing stakeholders to intuitively grasp the nuances of rider behavior.
- Predictive Modeling (Optional):
- If applicable, explored predictive modeling techniques to forecast potential annual membership conversions based on historical data patterns.
- Recommendations and Insights:
- Summarized findings in a comprehensive report, offering actionable recommendations for the marketing team to tailor strategies for converting casual riders into annual members.
