Analysis of Citi Bikes data in NYC was performed to understand any patterns that may be useful while establishing the business in other parts of the country. The data points provided in the dataset that was analyzed included:
Birth Year of the riders Gender Starting point of the trip Stopping point of the trip Trip Duration Trip start time Trip stop time The above data points could definitely provide meaningful insights to help set up the business in a new location.
The following charts were created to analyze the data :
-
Check Out time for Users : This chart helps analyze on an average how long are the bikes checked out for by users. Based on the chart it appears that majority of the rides (over 95%) were rented out for less than an hour with about 50% of the rides for 5 mins. This chart helps conclude that majority of the people rent bikes to travel very short distances which could reached in less than an hour.
-
Check out time by Gender : With the help of this chart, we can easily conclude that though there are way more men who take citi bike rentals, both men and women checkout bikes for approximately the same amount of time.
-
Trips by weekday per hour : A heatmap was created based on the trip start time to understand at which time of the day and which day of the week was the demand for bikes the highest. This chart would help plan bike maintenance and also help the company ensure that more bikes are available during the peak hours.8 AM - 9 AM and 5 PM - 7 PM Monday through Friday had the highest demand for bikes.11 PM to 5 AM would be the ideal time to plan for bike repairs, any events requiring bikes. 10 AM - 5 PM on Saturdays and 12 PM to 5 PM on Sundays were the peak hours during the weekend.
-
User Trips by Gender/day : The heatmap highlighted the fact that bike rentals by subscribers both male and female was the highest on Monday,Tuesday,Thursday and Friday.For customers the highest rentals were on Saturdays and Sundays
-
Gender Breakdown : The chart shows what percentage of the riders fell into either Male, Female or Unknown category. Based on the graph,approximately 65% of the trips were by men, 25% by women and approximately 10% were unknown.
-
Bike Repairs : This heatmap helps understand which bike requires to be serviced at the earliest based on the number of trips made by the bike. Bikes are identified by the Bike Id. It appears that any bike with over 400 trips is given the highest priority for servicing.
-
Number of Trips : This simple table breaks up the trips by gender and user type denoting the number of trips belonging to each category.
Based on all the above mentioned metrics, Citibikes bike rentals are of big demand in big cities where tourists frequent a lot and where places are close to each other making people prefer biking to taking a cab. Below are 2 additional metrics which would provide more insights to Citibikes management :
Birth Year Analysis : Majority of the bike rentals among males and females were by people who were born after 1985. This clearly outlines the fact that renting bikes was more common among the younger generation compared to the seniors
Top 10 start stations : The start stations were arranged in descending order based on how many strips started from this station. Pershing Square North Station had the highest number of trips originating from here