June 2022
Here is the executive presentation: https://docs.google.com/presentation/d/1aSH3AiNzYSWy_fC1oAwSL0HAm58VfLD_/edit?usp=sharing&ouid=109405724381094263294&rtpof=true&sd=true
Tools used:
Prepare: R.
Process: R.
Analyze: R.
Visualize and share: R and PowerPoint.
Context: In 2016, Cyclistic launched a successful bike-share offering. Since then, the program has grown to a fleet of 5,824 bicycles that are geotracked and locked into a network of 692 stations across Chicago. The bikes can be unlocked from one station and returned to any other station in the system anytime.
Until now, Cyclistic’s marketing strategy relied on building general awareness and appealing to broad consumer segments. One approach that helped make these things possible was the flexibility of its pricing plans: single-ride passes, full-day passes, and annual memberships. Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers who purchase annual memberships are Cyclistic members.
Cyclistic’s finance analysts have concluded that annual members are much more profitable than casual riders. Although the pricing flexibility helps Cyclistic attract more customers, The Director of Marketing believes that maximizing the number of annual members will be key to future growth. Rather than creating a marketing campaign that targets all-new customers, The Director of Marketing believes there is a very good chance to convert casual riders into members. She notes that casual riders are already aware of the Cyclistic program and have chosen Cyclistic for their mobility needs.
The Director of Marketing has set a clear goal: Design marketing strategies aimed at converting casual riders into annual members. In order to do that, however, the marketing analyst team needs to better understand how annual members and casual riders differ, why casual riders would buy a membership, and how digital media could affect their marketing tactics. The Director of Marketing and her team are interested in analyzing the Cyclistic historical bike trip data to identify trends.
The problem: Analyze the data to find out patterns and differences between how casual and annual riders use the bikes Cyclistic offers.
Data: 12 months worth of data:
https://divvy-tripdata.s3.amazonaws.com/202204-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202203-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202202-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202201-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202112-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202111-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202110-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202109-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202108-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202107-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202106-divvy-tripdata.zip
https://divvy-tripdata.s3.amazonaws.com/202105-divvy-tripdata.zip
Prepare:
Because the 12 months of data have around 1GB of information, I decided to use R to prepare, process and analyze it.
At this stage, I'm going to merge the 12 data frames into 1 so I can process and analyze it easier. The resulting data frame has 1.10GB of data.
Here is the markdown document for this process: https://docs.google.com/document/d/132dziMuCeXWyN9oktRPPS6gReMZu8N0-/edit?usp=sharing&ouid=109405724381094263294&rtpof=true&sd=true
Process:
At this stage, I want to be sure that all information is clean, correctly formatted and not duplicated. All the steps I took to accomplish this are in the markdown document.
Here is the markdown document for this process: https://docs.google.com/document/d/1LqZG2Hd_vS-CkTWHenP8y5ix6Ydyeozd/edit?usp=sharing&ouid=109405724381094263294&rtpof=true&sd=true
Analyze:
At this point, I wanted to start making observations and conclusions about the patterns and behaviors of the data.
Here is the markdown document for this process: https://docs.google.com/document/d/1Bh_2Tn1ahK9vdMjKfHbj1itgA8iCpaoW/edit?usp=sharing&ouid=109405724381094263294&rtpof=true&sd=true
Findings and conclusions:
We can draw 3 main conclusions from the data:
We can observe that casual members tend to use our service as a recreational activity, meanwhile annual members tend to use the service to transport themselves to work.
We can observe that casual members usage of the service is more sensitive to the overall temperature of the environment than annual members. If we are to switch casual members into annual members, we should try to find the casual members who use the service in a similar pattern to the annual members since they should be easier to convert, or casual members who already use our service to transport themselves to work but have not switched.
Overall, the tendency of the number of rides is to rise as the weekend comes nearby. This is explained because of the collaboration of casual members into the baseline of annual members we have. The overall seasonality of casual members cannot be ignored because it affects the yearly outcome.