Skip to content

Analyzing NYC CitiBike program for business proposal in another city using Tableau

Notifications You must be signed in to change notification settings

taznuva/BikeSharing

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

BikeSharing

Overview

Purpose

This project is about analyzing the bike-share business in New York City with a possible prospect of having a similar program in Des Moines, Illinois. In this analysis, the length of time that bikes are checked out for all riders and genders, the number of bike trips for all riders and genders for each hour of each day of the week, and the number of bike trips for each type of user and gender for each day of the week are explored for August 2019. To convince investors and to portray easy-to-understand visuals, this analysis will be shown via Tableau.

Results

NYC Citi Bike Story 1891 has the highest average trip duration while 1910 has the lowest average. From this image we can see that there are 2,344,224 overall rides for August 2019. The pie chart shows that Males typically rule the majority of rides. About 1,530,000 of rides are male riders.

NYC Citi Bike Story-2 Checkout Times for Users: The highest amount of users (146,752) rode their bikes for 5 mins trips. Most users do not exceed over an hour of riding.

NYC Citi Bike Story-3 Checkout Times for Users by Gender: Majority of bike riders are male. The highest number of male riders being 108,087; females at 34,151; unknown at 7,389

NYC Citi Bike Story-4 Trips by Weekdays for Each Hour: Thursdays from 5pm-7pm is the most busiest time. We can assume that from 6am-9am and 5pm-7pm are peak time.

NYC Citi Bike Story-5 Trips by Gender (Weekday by Hour): Most riders during peak time are male.

User Types by Gender (on Weekdays Each Hour): Users who are subscribers ride the most during the weekdays. Most subscribers are male as shown by dark color on the heatmap.

Click on this link to view full story: ['https://public.tableau.com/views/NYCCitiBike_16447992474180/NYCCitiBikeStory?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link']

Summary

From the analysis above, we can conclude the following statements:

  • Majority of bike-riders and bike subscribers are male
  • The average bike trip duration is 5 mins.
  • Thursday evenings from 5pm - 7pm are the busiest time and day out of the whole weekday.

For further analysis, we can find out where the top starting and ending locations in NYC for most bike rides. The images below suggest the darkest circles can possibly mean the locations are either a tourist site or residence.

About

Analyzing NYC CitiBike program for business proposal in another city using Tableau

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published