Analyzing Citi Bike data for August 2019 to be used in the business propopsal for the potential bike sharing program in Des Moines, Iowa. This analysis will be providing details on the following:
- How long bikes are checked out for all riders and genders.
- How many trips are taken by the hour for each day of the week, for all riders and genders.
- A breakdown of what days of the week a user might be more likely to check out a bike, by type of user and gender.
- Geographical insight on the top starting & top ending locations.
The Tableau story can be viewed here
Data Source: August 2019 Citi Bike Trip Histories Software: Tableau Public 2021.1.0, Jupyter Notebook 6.1.4
- Majority of users checkout bikes for a duration under 20 minutes.
- Majority of the users that checkout bikes for under 20 minutes are male.
- Majority of bike trips are taken between 7:00 a.m. - 9:00 a.m. and 4:00 p.m. - 6:00 p.m.
- Majority of Citi Bike users during weekdays between the hours of 7:00 a.m. - 9:00 a.m. and 4:00 p.m. - 6:00 p.m. are male.
- Majority of subscribers are male, with a larger number of trips occuring on Monday, Tuesday, Thurday and Friday.
- There is a larger number trips starting and ending in the Lower Manhattan area.
Recommendations for other visualizations for potential investors:
- Trips by Age by Gender
- Trips by Usertype by Gender