This case study is recommended for Google-data-analytics professional course.
In this case study, I used R language in which used tidyverse and dplyr for data cleaning and manipulation and ggplot2 for data visualization and data analysis.
- Rides of casual riders increases in weekend while membership riders use on weekday more often.
- In June-Sept number of rides increase frequently.
- Casual riders trip time is 96% greater than member riders regardless of day or month.
- All riders take more longer trips in weekend, member riders' ride time increases with 19% and casual riders' ride time increase with 22% .
- Average ride time stays relatively high for casual riders for March-September.
- All users ride almost same distance regardless of day or month.
- Number of rides taken by members is 37% more than casual riders.
- Although classic bike used for more number of rides electric bikes are used for longer distance and docked bikes are used for longer duration of rides.
- We can provide weekend pass to attract casual riders and for member riders we can provide them coupon for renew their ridership.
- We can provide refferal coupon to member riders when someone make subscribe the membership, by this we can get to new customer and attract casual riders to become member riders.
- There is a high increment in trip in month of Mar-June or/and June-Sept we can make a 4 months subscription plan for casual users.