Report submitted for the FP20 Analytics ZoomCharts Challenge, February 2025. The report was built using the Transportation & Logistics Dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.

Author's Description

As the dataset was rich with information, the first question I asked myself was: Who will need to see my report, and what will they be looking for?

First, I tried to identify where the problem was. After extensive exploratory analysis, I discovered that late deliveries accounted for about 58% of total bookings. Surprisingly, although this company started its business in 2019, it received very few bookings until May 2020. As bookings increased, so did late deliveries.

Since late deliveries were linked to booking volume, I questioned whether the timing of bookings was an issue. Was the supplier at fault for these continuous delays? I was surprised to find that only 19% of suppliers handled 80% of the bookings, and 96% of shipments were processed within 24 hours.

Next, I analyzed the routes and distances, which led me to identify a vehicle management issue. About 90% of the vehicles were either underutilized or overutilized.