Dashboard-IV
Dashboard – Delivery Dataset
Problem Statement
To evaluate customer satisfaction and identify operational bottlenecks in delivery performance. The dashboard aims to analyze delivery satisfaction levels, identify frequent customer issues, and explore regional variations in delivery efficiency.
KPIs
Customer Satisfaction Score (CSAT)
Data Source: Customer feedback or survey dataset (integrated with delivery data).
Delivery Issues per 100 Deliveries
On-Time Delivery Rate
Delivery Cost per Region Formula: Average cost calculated by summing delivery costs and dividing by delivery count for each region.
Repeat Customers per Region Measures the percentage of repeat customers in a specific region over time.
Visuals
Customer Satisfaction Trends: Line Chart
Regional Delivery Issues Heatmap: Geographic Map
On-Time Delivery Pie Chart: Segmenting on-time vs. delayed deliveries.
Delivery Costs by Region: Bar Chart.
Repeat Customers Table: By region, month, and city.
Filters and Slicers
City
Region
Date Range
Delivery Status
Customer Type (e.g., first-time, repeat)
Dashboard 4 – Pickup Dataset
Problem Statement
To analyze courier and AOI pickup efficiency and monitor time adherence to identify potential improvements in scheduling and resource allocation.
KPIs
Average Pickup Delay
Pickups Within Time Window Rate
Courier Pickup Efficiency
Top AOI Types for Pickups Segmented by the volume of pickups.
Average Distance to Pickup Location
Visuals
Pickup Delay Trends: Line Chart
AOI Type Distribution for Pickups: Donut Chart
Time Window Adherence Heatmap: Geographic Map
Courier Efficiency Scatter Plot: Pickup count vs. working hours.
Average Distance Bar Chart: By city and AOI.
Filters and Slicers
City
Region
AOI Type
Date Range
Courier ID
These dashboards provide in-depth insights into operational inefficiencies and enable strategic decision-making for improved customer satisfaction and courier management.
Last updated