Skip to content

This repo looks at NYC's Citi Bike program data and implements Tableau to visualize its current ridership data.

Notifications You must be signed in to change notification settings

lawrencegoodwyn/bikesharing

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 

Repository files navigation

Bikesharing link to dashboard

Overview

The purpose of this analysis was to use data from NYC's Citi Bike program to implement it in Des Moines, IA. Using Tableau, insights into the data in order to gain a better picture of the performance of NYC's Citi Bike were created.

Results:

August Ridership Peaks

Screen Shot 2021-12-01 at 9 04 35 PM August's peak ride times with 5-7pm being the busiest ride times.

Trips by Weekday

Screen Shot 2021-12-01 at 9 05 41 PM Most rides occuring around rush hour in the morning and the afternoon. With Monday, Tuesday, and Wednesday having the most usage.

User Trips by Gender

Screen Shot 2021-12-01 at 9 06 56 PM Male subscribers seem to have the most rides throughout the week. ###Trips by Gender (Weekday Per Hour) Screen Shot 2021-12-01 at 9 08 47 PM The same trend occurs here as with the last visualiziation in which male riders experience a high amount of usage throughout rush hour times.

Average Trip Duration by Birth Year

Screen Shot 2021-12-01 at 9 10 31 PM Younger audiences appear to have the longest trip durations.

Checkout Times by Gender

Screen Shot 2021-12-01 at 9 11 33 PM

Nearly double more men are riding bikes with an average of 10 min ride times for both genders.

Average Trip Times

Screen Shot 2021-12-01 at 9 13 18 PM

As stated in the previous visualiztion, nearly all rides last roughly 10 mintues for all genders.

Summary:

The NYC Citi Bike program saw 2,344,244 rides in total in the month of August of 2019. With 1.9M and 400k subscribers and customers riding, respectively. Most of the rides occured around rush hour; and users which are born later, 1970s and later, account for most of the ridership. Additionally, men occupy a larger percentage of ridership and account for nearly 3x the percentage of users. I would take a deeper look into exactly what could cause the need for future repairs on bikes, a closer look at exactly where riders are travelling to on their bikes (a better map might be required for that). And also, since the goal is to put the service in Des Moines, what could be done to increase overall ridership there. What destinations could they ride the bikes to? Is the layout of Des Moines fitting for such a service? What can be done to increase the age range that is taking these bikes and how do we get more women to ride the bikes?

About

This repo looks at NYC's Citi Bike program data and implements Tableau to visualize its current ridership data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published