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

Author's Description:

The report is structured as follows:

1. Cover Page
   The cover page serves as the entry point into the report.

2. Shipment Overview & Performance
   This page provides a high-level snapshot of shipment volumes, on-time delivery rates, and transportation distances. It highlights the top routes, customers, suppliers, and shipment clusters across regions, offering visibility into the overall health of the supply chain.

3. Delivery Performance & Delays
   Focusing on delay analysis, this page examines average delay times, key routes, and supplier performance. It also evaluates vehicle performance, identifying which vehicles and drivers contribute to delays. Additionally, it lists the top customers impacted by delays, helping prioritize corrective actions for key accounts.

4. Predictive Insights & Optimization
   This page leverages predictive analytics using Python in Power Query to build logistic regression and XGBoost models for forecasting shipment delays, trip durations, and future risks. It presents a predicted delay rate of 82.73%, along with estimated trip durations and delay statuses for user-selected bookings. Business growth metrics—such as shipment growth, fleet utilization, and customer acquisition—are also included to help balance growth opportunities with operational risks.