__STYLES__
Visualization Tool: Power Bi
Dataset Provided by: Quantum Analytics NG
Business Case: To build a dashboard that will help with weekly planning and logistics, for any given fiscal week.
The historical data seeks to answer the following questions:
What's the average number of trips we can expect this week?
What's the average fare per trip we expect to collect?
What's the average distance traveled per trip?
How do we expect trip volume to change, relative to last week?
Which days of the week and times of the day will be busiest?
What will likely be the most popular pick-up and drop-off locations?
KPIs/ Insights:
2: Total Passengers:38M
Total Revenue:$385.99M
Average Fare Amount:$12.32
Highest Fare Amount:$24.64
Average Trip distance:2.87
Highest Trip Distance:5.73
The year 2017 generated the highest Revenue of 167,207,941, while 2020 generated the least revenue of 34,963,898.
Most popular passenger trip type is street hailing which was used by over 35M passenger against the dispatch trip type.
The most preferred payment method is the credit card which is 64% popular than the cash payment method.
The year with the least passenger volume is the 2020, with total volume of 1.5M compared to other years, this is probably due to the covid-19 pandemic , hence there are restricted movement and people generally prefers to stay at home and observe social distancing.
Manhattan Borough has the highest passenger population, maybe due to the area is more densely populated than other boroughs.
The most preferred ratecode is the standard rate code with 93.87% usage over other rate code.
14. At 1948153, Saturday had the highest Total Trips and was 42.52% higher than Monday, which had the lowest Total Trips at 1366954.
15.Saturday accounted for 17.22% of Total Trips.
16. Across all 7 Days of the week, Total Trips ranged from 1366954 to 1948153.
17. Location ID 74 (Manhattan) accounted for 24.78% of Total Trips.