NYC Citibike with Tableau
- Import data into Tableau.
- Create and style worksheets, dashboards, and stories in Tableau.
- Use Tableau worksheets to display data in a professional way.
- Portray data accurately using Tableau dashboards.
Des Moines requested data for a business proposal. August 2019 Citibike data from NYC was reviewed by looking at geographical data as well as data disaggregated by user types and genders to determine if it would be a good investment for Des Moines. Other data points include usage durations, peak usage times, and the key target market.
Jupyter Notebook was used to change the trip duration data to a datetime field.
For NYC, there were some interesting geographical areas of interest. Some trips were outside the main city center. Other areas followed the along the river. Future analysis would need to include a geographical review.
Checkout Times for All Users
The Citibikes usage reaches a top of 3000 minutes per user.
Checkout Times by Gender
Males are significantly higher users than others.
Trips (Weekday per Hour)
6-10 am and 5-8 PM are peak riding hours during the weekday and 5 am to 10 pm on the weekends.
Trips by Gender (Weekday per Hour)
Males are high users during the peak hours.
Trips by Gender and User Type (Weekday per Hour)
Males subscribers are the highest users followed by female subscribers.
Number of Rides per Hour
Non-peak hours are 1-5 am.
Number of Rides with Bike ID
The divergence line shows that there are high use on 1/3 of the bikes.
- Bike Repairs for 1/3 of the Citibikes need to be done during non-peak hours around 1-5 am.
- Male subscribers are the highest users and follow the traditional high use times of travel to and from work.
- Target market should be males needing transportation to work and weekend activities and push for subscribing to the services.
For NYC, there were some interesting geographical areas of interest. Some trips were outside the main city center. Other areas followed the along the river. Future analysis would need to include a geographical review.
Ride Starting Locations by Gender
Males are more likely to start a trip farther than the main city center of NYC than others.
Ride Ending Locations by Gender
Males are more likely end a trip across the river in the southwest area of NYC than others.
User Type Starting Location
Subscribers are more likely to start trip farther than the main city center of NYC than others.