Lovethadams/DHL-Supply-Chain-Powerbi

Interactive Power BI dashboard analyzing revenue performance and customer behavior for DHL Supply Chain Africa operations, built with DAX, Excel, and Python-generated data. # DHL Supply Chain Africa — Revenue & Customer Analytics Dashboard ## Project Overview An interactive two-page Power BI dashboard analyzing shipment revenue performance and customer behavior for DHL Supply Chain Africa operations across 7 origin cities and 8 destination cities spanning January 2023 to June 2024. This is a portfolio project built on a realistic fictional dataset modeled after DHL's African logistics operations. --- ## Dashboard Preview ### Page 1 — Revenue Performance ### Page 2 — Customer Behavior Analysis --- ## Dashboard Pages ### Page 1 — Revenue Performance Tracks revenue trends, service type breakdown, and top-performing routes. **Key Metrics:** - Total Revenue - Total Shipments - Average Revenue per Shipment - Revenue vs Target **Visuals:** - Monthly Revenue Trend (Line Chart) - Revenue by Service Type (Clustered Bar Chart) - Top 10 Routes by Revenue (Clustered Bar Chart) - Revenue by Origin City (Clustered Bar Chart) **Slicers:** Year | Service Type | Quarter --- ### Page 2 — Customer Behavior Analysis Explores customer segmentation, repeat patterns, and industry distribution. **Key Metrics:** - Total Customers - Repeat Customer Rate - B2B Shipments - B2C Shipments **Visuals:** - B2B vs B2C Breakdown (Donut Chart) - Repeat vs One-Time Customers (Donut Chart) - Shipments by Industry (Clustered Bar Chart) - Shipment Volume by Month (Line Chart) - Average Order Value by Segment (Stacked Column Chart) **Slicers:** Customer Segment | Delivery Status | Industry --- ## Dataset The dataset was generated specifically for this project and contains **1,200 rows** across **15 columns** covering 18 months of fictional DHL shipment data. | Column | Description | |---|---| | shipment_id | Unique shipment identifier | | date | Shipment date | | customer_id | Unique customer identifier | | customer_segment | B2B or B2C | | industry | Customer industry sector | | service_type | Express, Freight, eCommerce Logistics, Cold Chain, Cu …