🔍 Google Data Analytics Capstone - Cyclistic

A data analytics case study to analyze 12 months of Cyclistic bike-share trip data to identify behavioral differences between casual riders and annual members for a targeted marketing strategy.

⚙ Tools Used

• SQL (BigQuery Sandbox)
• Spreadsheet (Google Sheets)
• Docs (Google Docs)
• Presentation (Google Slides)
• Tableau Public
• Medium

🔗Links

📖 My Data Analysis Journey
➔ Read on Medium

🎤 Presentation of Analysis Results
➔ View Presentation on Google Slides
➔ View Presentation as PDF

📄 Project Documentation
➔ View Documentation on Google Docs
➔ View Changelog on Google Docs ➔ View Documentation as PDF
➔ View Changelog as PDF

📊 Tableau Visualizations
➔ Visualizations in Tableau Public
➔ Visualizations as Images

📊 Findings Spreadsheet
➔ View Findings on Google Sheets
➔ View Findings as PDF

📙 Project Guide

1. Click the Article first... It contains my entire journey of the project
2. You can read the documentation next (Optional)
3. You can also read changelog after that (Optional)
4. Look at the interactive visualization from the Tableau Public Link (Recommended)
5. Go to the Presentation to see the Analysis Results

🧠 Skills Demonstrated

• SQL (BigQuery)
• Data Cleaning & Transformation
• Exploratory Data Analysis (EDA)
• Customer Behavior Analysis
• Geospatial Analysis
• Data Visualization (Tableau)
• Dashboard Design
• Business Intelligence
• Data Storytelling
• Business Recommendations
• Technical Documentation
• Presentation & Stakeholder Communication
• Git & GitHub

---

Best viewing experience: Documentation and presentation are available as interactive Google Docs/Slides with full formatting and working hyperlinks. PDF versions are also provided for convenient viewing directly on GitHub.