- Introduction
- Phase One: Ask
- Phase Two: Prepare
- Phase Three: Process
- Phase Four: Analysis
- Phase Five: Visualization
- Phase Five: Share
- Phase Six: Recommendation
- Limitations
- Resources
As a junior data analyst working in the marketing analyst team at Cyclistic, a bike-share company in Chicago. The director of marketing believes the company’s future success depends on maximizing the number of annual memberships. Therefore, my team wants to understand how casual riders and annual members use Cyclistic bikes differently. From these insights, the marketing team will design a new marketing strategy to convert casual riders into annual members. Read more
Divvy is the bicycle sharing system in the Chicago metropolitan area, currently serving the cities of Chicago and Evanston. The system is owned by the Chicago Department of Transportation and has been operated by Lyft since 2019. As of Sept 2021, Divvy operated 16,500 bicycles and over 800 stations, covering 190 square miles. Explore!
Divvy makes its Historical trip data available for public use. The datasets were downloaded from link, under this license. Each trip is anonymized and includes, trip start day and time, trip end day and time, Trip start station, a Trip end station, Rider type. For this project, I will be analyzing 12-month Cyclist trip data between August, 2020 and July, 2022. Each month's data in a separate CSV file was loaded and were later concatinated.
In order to answer the key business questions, I will follow the steps of the data analysis process: ask, prepare, process, analyze, share, and act taught in the Google Data Analytics Professional Certificate.
You wish you understood this steps better? Read more
- How do annual members and casual riders use Cyclistic bikes differently?
- Why would casual riders buy Cyclistic annual memberships?
- How can Cyclistic use digital media to influence casual riders to become members?
-
Identify historical trends for casual and annual bike riders
-
Determine the factors that influence casual riders into buying annual memberships
-
Use insights from historical trends and factors associated with casual riders buying annual memberships to improve the casual rider to annual membership conversion rate via digital media.
Motivate International Inc. (“Motivate”) operates the City of Chicago’s (“City”) Divvy bicycle sharing service. Motivate and the City are committed to supporting bicycling as an alternative transportation option. As part of that commitment, the City permits Motivate to make certain Divvy system data owned by the City (“Data”) available to the public, subject to the terms and conditions of this License Agreement. https://ride.divvybikes.com/data-license-agreement
The data is collected directly by the company itself who is issuing the service and the bikes, so the data insures that it's reliable, and from the data provided it seems that it is ROCCC.
The data does not contain personal information about any of the users who participated in the survey. The provider company has clear and detailed licence and terms to use for the data, so it's the right thing to acknowledge them and give them full credit with references for the data used.
The original dataset has 5,901,463 observations and 13 features. It was then checked for consistency in column names and data types and no discrepancy was detected. After that, the data row containing missing values were dropped and outliers were removed leaving behind 3,625,932 observations. Some columns were added making a total of 21 features out of which only 11 features were then selected for analysis.
- Which bike is the most preferred bike?
- Are short rides most common or long rides?
- What is the correlation between ride length and duration of ride?
- For both duration and ride_length, the median is close to mean, that is, positively skewed. This implies that:
- Most of the rides are short in distance and time
- Both variable are positively correlated
- Clasic bike is most preferred bike by member and casual riders
- Docked bike is only used by casual riders
Focusing on maximizing the number of annual memberships will most likely improve Chicago-Divvy's future success and they should also look into investing on clasic bike than the other two.
- What is the average ride length and duration?
- How many rides are recoded by each member everyday?
- In total, members have more rides than casual riders.
- For the same ride length, it takes causal riders longer duration than members.
- Casual riders rides more on weekends while members do more on weekdays.
- It is possilbe that casual members are not good at riding divvy's bikes such that it takes them longer time to cover exact distance corvered by a member and this, perhaps, may prevent them from ride during the work days as they may get late to work, or
- Casual riders enjoy rides at low speed (for leisure) and prefer to take ride on weekends for outing.
- There is increase in ride for both groups during the day and decreases at night.
- There are noticeable increase in ride between 6am and 9am in the morning for members only and between 4pm and 7pm in the evening for both members and casual riders
- This trend support the previous speculation made with Fig. 5 that members, most likely, use the service for work commute.
Memebers annual total rides is more than casual riders. There is upward trend from the beginning of the year until around June and August when members and casual riders, respectively, reached the ceiling ride. They both decreases till December
Chicago exprience hot weather conndition in the middle of the years and is usually intense between May and September. At this same period, precipation reduces.[1]. Since Divvy's bikes are not covered, it is safe to conclude that their product will serve customer more during summer season (June - September).
-
Targeting social media, club houses and youth programs would be stragetic enough because casual riders are most likely to be found here
-
The marketing team can offer free membership trial for a month. Casual riders may want to continue the membership if they find it convenient and cost-effetive than alternatives
-
Allowing family or group registration should be allowed and encouraged especially for friends and families. It is assumed that casual riders are social and they would love to enjoy the discount that is attached to this as well.
-
Awareness at pupolar start/ end stations, season greeting and referral should be employed for constant and periodic reaching out.
-
Age and gender profile: This data could be used to study the category of riders who can be targeted for marketing.
-
Occupation of member riders: This data could be used predict the income of riders.
-
Speed of ride by members and casual: This data could be used to undstand why it takes casua riders to reach their destination.
-
Pricing details for members and casual riders - This could be used to optimize cost structure for casual riders or provide discounts for members without affecting the profit margin.
- Rdocumentation.org
- Geeksforgeeks.org
- Stackoverflow.com
- Wikipedia.org
- Tutorialspoint.com
- Statology.org
