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.
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.
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.
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
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.
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']
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.