This was my first data analysis project R. It was my capstone project for the Google Data Analytics Specialization Course on Coursera
library(dplyr) library(ggplot2) library(hrbrthemes) library(hablar) library(lubridate) library(hms) library(scales) library(leaflet) library(mapsapi) library(htmlwidgets) library(htmltools)
You are 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, your team wants to understand how casual riders and annual members use Cyclistic bikes differently. From these insights, your team will design a new marketing strategy to convert casual riders into annual members. But first, Cyclistic executives must approve your recommendations, so they must be backed up with compelling data insights and professional data visualizations.
Cyclistic is a fictional company. The data has been made available by Motivate International Inc. under this license The data is available here
Cyclistic has a fleet of 5,824 bikes that are geotracked and locked into a network of 692 stations across Chicago. Cyclistic Business Model includes flexible pricing plans : single-ride passes, full-day passes, and annual memberships.
- Preparation
- Transformation
- Analysis
- Graphs and Plots
- Report
- Conclusion
- Recommendations
Key Differences between Annual Members and Casual Renters are :
- Casual Renters, on an average, rent bikes for longer periods of time.
- 50% of casual renters rides are between 10 to 40 minutes long, whereas 75% of members rides are shorter than 22 minutes.
- Casual Renters are more active than Annual Members on Friday and Saturdays.
- During the week Annual Members are more active renters.
- During the week, a greater number of Annual Members follow a traditional Office hours schedule.
- Casual Renters are more active over the weekends. Peak hours are in the late afternoon and continue until late night.
- Casual Renters are concentrated on the waterfront areas and tourist attractions.
- Annual Members in addition to the waterfront and tourist attractions are also active near residential areas, educational institutes, student hubs and city centres.
- Casual Renters who are renting for longer than single day tend to keep the bike for an average of 4 days.
- Annual Members who rent for longer than a day return the bike by around the 25 hour mark.
- Target those Casual Members who follow a traditional Office hour schedule.
- Increase presence around educational institutes and areas popular with students.
- Encourage Casual Renters to rent for shorter lengths and shorter distances.