Capital Bikeshare analysis

This analysis uses Tableau to visualize the findings and want to provide recommendations to the company. The data set contains records from January 2011 to December 2012.

Seasonal Registered Rate

Compared four seasons, Summer & Fall had a lower Registered rate and the rate under 80%

Monthly Registered Rate

Registered rate under 80% from April to September

Registered Rate for day of week

Registered rate on Saturday & Sunday were pretty low compared other days of weeks

Weekday & Holiday Registered Rate Comparison

Registered rate on weekdays was higher than weekends and registered rate on holiday weekends was higher than non-holiday weekends

Registered customers usually bring more revenues to company because deposit. From this analysis, we can confidently say if the company want to do a market campaign, Summer & Fall from April to September are the good time and especially the weekend.

If you are interested in this project, please contact me for a further discussion.

Google Sites

Report abuse