In a fictional world, I have been tasked with overseeing the largest bike-sharing program in the United States as a lead analyst for a New York City bike program (Citi Bike). In my new role, I will be expected to generate regular reports for city officials looking to publicize and improve the city program.
Since 2013, the Citi Bike program has implemented a robust infrastructure for collecting data on the program's utilization. Each month, bike data is collected, organized, and made public on the Citi Bike webpage.
While the data has been regularly updated, the team has yet to implement a dashboard or sophisticated reporting process. City officials have questions about the program, so my first task on the job is to build a set of data reports using Tableau to provide the answers.
Figure 1. Dashboard of the change in bike rentals from 2019 to 2020
Figure 2. Dashboard highlighting the increase in bike rentals post-covid pandemic
Figure 3. Bar chart showing the increase in bike rentals in each station before the pandemic, during the pandemic, and after the pandemic
Figure 4. Dashboard highlighting the number of trips per bike type for each hour of the day
Figure 5. Dashboard showing the difference in peak hours of the day for bike rentals of members vs. non-members. Chart is interactive with the tableau public link
Figure 6. Map of the most common bike rental stations. In the Tableau Public version, this map is interactive and will provide the coordinates and the number of trips each station had.
Tableau Dashboards and Story: https://public.tableau.com/app/profile/nicholai.shaw/viz/CitiBikeAnalysis_16976829055180/BikeRentalStory
In addition to the tableau public link, the visuals can be found in the 'pdf' and 'powerpoint' folders for pdf and powerpoint formats.