Anlaysis of New York Citi Bike Rides - January 2023 through June 2023

View the analysis dashboard HERE on Tableau Public!

Retrieve data from Citi Bike NYC

• Download the City Bike Trip History Log files for January 2023 - June 2023:
  • JC-202301-citibike-tripdata.csv
  • JC-202302-citibike-tripdata.csv
  • JC-202303-citibike-tripdata.csv
  • JC-202304-citibike-tripdata.csv
  • JC-202305-citibike-tripdata.csv
  • JC-202306-citibike-tripdata.csv

Merge the data

• Use app.ipynb script to merge the six distinct .csv data files into combined-citibike-data.csv.

Create Visualization through Tableau Public account

• Log into Tableau Public.

Analysis Results

• How many trips have been recorded in total during the chosen period?: 444, 073
• By what percentage has total ridership grown?
• How have the proportions of short-term customers and annual subscribers changed?
• What are the peak hours when bikes are used during the summer months?
• What are the peak hours when bikes are used during the winter months?
• Today, what are the top 10 stations in the city for starting a journey? Based on data, why do you hypothesize these are the top locations?
• Today, what are the top 10 stations in the city for ending a journey? Based on data, why?
• Today, what are the bottom 10 stations in the city for starting a journey? Based on data, why?
• Today, what are the bottom 10 stations in the city for ending a journey? Based on data, why?
• How does the average trip duration change by the type of user? (This may be under "User Type" or "member_casual" depending on the period the data is from).
• What is the average distance in miles for a bike trip?
• Which bikes (by ID) are most likely due for repair or inspection in the timespan?
• How variable is the utilization by bike ID?
• What is the geographic distribution of Rideable Type?

To view the Dashboard

Create individual dashboards for each phenomenon you discovered, organizing related visualizations together. Ensure that your visualizations are visually appealing, colorful, and easy to understand for non-technical audiences. Add insightful and concise analysis in each dashboard explaining the phenomena you discovered and the trends observed.

• Dashboard

To view the Story

Create a Tableau Story to bring together all the dashboards, visualizations, and maps. Arrange the dashboards in a logical flow to tell a compelling data-driven narrative. Ensure that your Tableau Story is professional and engaging, keeping in mind your audience, which includes city officials and public administrators.

• Story