Lucio Colonna
Last updated: Tuesday September 10, 2024
The case study presented here is the final capstone project of the
Google Data
Analytics
certification program.
I’ve undertaken the entire project using
R (perhaps a bit masochistic), but it’s all part of the fun.
The journey took a bit longer than anticipated, as life had its own
plans; specifically, my first child decided to join the party
mid-analysis!
Therefore, this work is dedicated to my newborn,
who brought an extra dose of joy to the process 🚀
This case study is also available on Kaggle at the following link.
- Context
- Timeframe and Data Overview
- Data Preparation
- Data Processing
- Data Analysis
- Summary of Key findings
- Recommendations for the business
- Cyclistic is a fictional bike-share company in Chicago, offering both electric and traditional bikes (however, the underlying data of this case study pertains to Divvy, a real-world bike-sharing service operating in Chicago)
- The company categorizes users into 2 main groups:
- “Casual” users , who buy single-rides or full-day passes
- “Member” users, who purchase annual memberships
- Cyclistic believes that members are more profitable than casual riders and aims at designing marketing strategies to convert casual riders into annual members
- In order to accomplish this, the company seeks the answer to the following question, which will also serve as the objective of the analysis:
⭐ How do members and casual riders use Cyclistic bikes differently? ⭐
📌 Time Scope
- January 2023 to December 2023
📌 Data Used
- The original dataset is provided by Motivate International Inc., which operates the bicycle sharing service, and it is available under this license agreement. It is also available here on Kaggle
📌 External Resources
- Chicago 2023 weather data was sourced from the National Oceanic and Atmospheric Administration (NOAA) Online Weather Data, accessible on the U.S. National Weather Service (NWS) website (“2023 Monthly Avg Temperature for Chicago Area, IL” and “2023 Monthly Mean Precipitation for Chicago Area, IL”), available under this license
- The
.geojson
map of Chicago was obtained by the Chicago Data portal website, and is provided under these terms of use