Cyclistic Case Study Presentation Description
The Cyclistic Case Study is a 15-18 slide Google Slides presentation, completed as the capstone project for the Google Data Analytics Certificate, analyzing user behavior for Cyclistic, a fictional Chicago bike-sharing company. Designed to showcase data analytics skills for entry-level data entry or analyst roles, it uses 12 months of Divvy trip data (~5M rides, 2023-2024) to differentiate casual riders from annual members, driving marketing strategies to boost membership conversions. The deck blends clear storytelling, robust data processing, and professional visualizations, making it ideal for demonstrating technical and communication skills to recruiters.
Key Components:
Business Objective: Convert casual riders to annual members to maximize revenue (~$500K potential from 10% conversion). Targets marketing stakeholders with actionable insights.
Data Processing: Cleaned dataset in Excel (removed nulls/duplicates), processed with SQL/R (ride length, day type), and visualized in Tableau. Meets ROCCC standards (Reliable, Original, Comprehensive, Current, Cited).
Analysis: Reveals casuals’ longer, leisurely rides (25 min vs. members’ 12 min), summer/weekend peaks, and tourist-heavy station usage (e.g., Millennium Park). Highlights bike preferences (casuals: 55% electric).
Visualizations: Includes bar charts (ride frequency by month/day), line graphs (duration trends), heatmaps (station activity), and an interactive Chicago map (Tableau embed) for spatial insights.
Recommendations: Proposes app-based notifications, tourism partnerships, and a $50/3-month flexible subscription pilot, with A/B testing and quarterly re-analysis plans.
Skills Showcased:
Technical: Data cleaning (Excel, SQL), analysis (R for aggregations), visualization (Tableau).
Soft Skills: Data storytelling, stakeholder communication, time management (completed in ~2 weeks).
Relevance: Aligns with remote data entry/analyst roles (e.g., FNEX, Twine), emphasizing accuracy, attention to detail, and remote adaptability for a US contractor setup from Spain (student visa, 20-30 hrs/week).
Presentation Style: Modern, bike-themed design (green/blue palette), with consistent fonts (Arial/Sans Serif), accessible charts, and a concise 15-minute narrative flow. Portfolio-ready, it demonstrates real-world applicability for data-driven decision-making in a business context.…Cyclistic Case Study Presentation Description
The Cyclistic Case Study is a 15-18 slide Google Slides presentation, completed as the capstone project for the Google Data Analytics Certificate, analyzing user behavior for Cyclistic, a fictional Chicago bike-sharing company. Designed to showcase data analytics skills for entry-level data entry or analyst roles, it uses 12 months of Divvy trip data (~5M rides, 2023-2024) to differentiate casual riders from annual members, driving marketing strategies to boost membership conversions. The deck blends clear storytelling, robust data processing, and professional visualizations, making it ideal for demonstrating technical and communication skills to recruiters.
Key Components:
Business Objective: Convert casual riders to annual members to maximize revenue (~$500K potential from 10% conversion). Targets marketing stakeholders with actionable insights.
Data Processing: Cleaned dataset in Excel (removed nulls/duplicates), processed with SQL/R (ride length, day type), and visualized in Tableau. Meets ROCCC standards (Reliable, Original, Comprehensive, Current, Cited).
Analysis: Reveals casuals’ longer, leisurely rides (25 min vs. members’ 12 min), summer/weekend peaks, and tourist-heavy station usage (e.g., Millennium Park). Highlights bike preferences (casuals: 55% electric).
Visualizations: Includes bar charts (ride frequency by month/day), line graphs (duration trends), heatmaps (station activity), and an interactive Chicago map (Tableau embed) for spatial insights.
Recommendations: Proposes app-based notifications, tourism partnerships, and a $50/3-month flexible subscription pilot, with A/B testing and quarterly re-analysis plans.
Skills Showcased:
Technical: Data cleaning (Excel, SQL), analysis (R for aggregations), visualization (Tableau).
Soft Skills: Data storytelling, stakeholder communication, time management (completed in ~2 weeks).
Relevance: Aligns with remote data entry/analyst roles (e.g., FNEX, Twine), emphasizing accuracy, attention to detail, and remote adaptability for a US contractor setup from Spain (student visa, 20-30 hrs/week).
Presentation Style: Modern, bike-themed design (green/blue palette), with consistent fonts (Arial/Sans Serif), accessible charts, and a concise 15-minute narrative flow. Portfolio-ready, it demonstrates real-world applicability for data-driven decision-making in a business context.WW…