Using tableau to visualize bikeshare data in New York City
Analyze NYC citibike data to help figure out how the bike-share business works in NYC in order to start a similar bike-share business for hometown of Des Moines lowa. This will later on help to convince investors that a bike-sharing program in Des Moines is a solid business proposal.
Multiple visualizations were created using tableau; Here are some key results found:
- There was a total of 2,344,224 trips taken in August.
- More than three-quarters of riders are subscribers.
- There are more bike trips taken in Manhattan than in Brooklyn or Queens in August.
- Most bike trips were less than an hour; for those trips, there are way more male riders than female riders.
- Thursday 5 pm to 7 pm has the highest number of trips than any other time of the week.
- Peak hours are similar between male and female riders.
- The highest number of trips were taken by male subscribers on Thursday.
It is not hard to notice that Thursday is the most popular day to take a bike ride. Pay extra attention to bike management during peak hours should reduce bike shortages.Promoting customers to become long-term subscribers is important not only because most trips are taken by subscribers but also reducing the number of unknowns for gender as shown by the additional visualization. Getting the big picture of which part of the city is more popular with bike rides could gain more insight and manage bike station placement better. Since less bike ride is longer than an hour, the range of the outer bike station should be adjusted accordingly.