Dashboard-II
Second Dashboard: Delivery and Pickup Operational Performance Analysis
Objective
The objective of this dashboard is to monitor and analyze operational performance for delivery and pickup tasks. It focuses on identifying trends, patterns, and performance metrics that can help improve efficiency, address delays, and optimize resource allocation across cities and regions.
Below are separate dashboards for Delivery and Pickup, detailing their KPIs, filters, slicers, and objectives:
Dashboard 2: Delivery Operations Dashboard
Objective:
To evaluate and monitor delivery performance across regions, ensuring SLA compliance, and optimizing courier allocation. This dashboard will help identify bottlenecks and areas for operational improvement.
KPIs:
Total Deliveries Completed: Count of successfully completed deliveries.
Average Delivery Time: Average time taken from acceptance to delivery.
SLA Compliance Rate: Percentage of deliveries completed within the SLA.
Measure:
IF(Delivery Time <= SLA Time, "On-Time", "Delayed")
Failed Deliveries: Count of deliveries that failed or were delayed.
Courier Utilization Rate: Average number of deliveries completed per courier.
Filters:
City: Filter by specific cities.
Region: Focus on specific regions.
Courier ID: Performance metrics for individual couriers.
Date Range: Filter data by specific periods.
Slicers:
SLA Status: On-Time vs. Delayed.
AOI Type: Residential, Commercial, etc.
Visualizations:
Bar Chart: Deliveries by courier.
Line Chart: Delivery trends over time.
Map Visualization: Task density and SLA compliance by region.
Pie Chart: SLA compliance rate distribution.
Dashboard 2: Pickup Operations Dashboard
Objective:
To analyze pickup operations, focusing on task efficiency, SLA adherence, and courier performance. This dashboard aims to optimize scheduling and reduce delays.
KPIs:
Total Pickups Completed: Number of successful pickups.
Average Pickup Time: Time taken from acceptance to pickup.
SLA Compliance Rate for Pickups: Percentage of pickups completed within the designated time window.
Courier Idle Time: Time between task completion and the next task assignment.
Failed Pickups: Count of failed pickups or pickups outside the time window.
Filters:
City: Filter data for individual cities.
Region: Focus on specific regions.
Courier ID: Analyze specific courier performance.
Date Range: Select a specific time frame for analysis.
Slicers:
Task Type: Pickup-specific tasks.
Time Window Status: Tasks completed within vs. outside the time window.
AOI Type: Residential, Commercial, etc.
Visualizations:
Bar Chart: Pickups by courier.
Line Chart: Trends in pickup completion over time.
Map Visualization: Pickup density by region and SLA compliance.
Donut Chart: Time window compliance rate.
Last updated