Project 2: Bike Ride Share
#Excel, #Dashboard, #R, #dataviz, #datawrangling

Please download the Excel dashboard, or click here to see the R notebook.
In this project, I perform a data analysis process for the marketing analyst team at Cyclistic, a bike-share company in Chicago. I analyze how casual riders and annual members use Cyclistic bikes differently so that the team can come up with appropriate strategies to maximize the number of annual memberships.
The main problem in this project is to deal with the large data size file and that the data distribution of the riders are extremely right-skewed and the its mass distribution accumulated at the left endpoint.
We overcome this difficulty by grouping data in short and long riders and comparing the bike share usage for each group.