Dashboard-VI

Below is a Dashboard 6 designed separately for both the Delivery Dataset and the Pickup Dataset.

---

Delivery Dashboard 6

Problem Statement

To analyze delivery performance across various dimensions like customer satisfaction, delivery trends, and cost efficiency while identifying bottlenecks and opportunities for improvement.

KPIs

1. Customer Satisfaction Score (CSAT)

   • Formula: CSAT = (Number of Positive Feedbacks / Total Feedbacks) × 100

   • Objective: To measure the percentage of customers satisfied with their delivery experience.

2. On-Time Delivery Percentage

   • Formula: On-Time Delivery % = (Number of On-Time Deliveries / Total Deliveries) × 100

   • Objective: To evaluate the efficiency in meeting promised delivery times.

3. Average Delivery Time

   • Formula: Average Delivery Time = Total Delivery Duration / Total Deliveries

   • Objective: To monitor delivery speed trends and identify delays.

4. Delivery Cost per Region

   • Formula: Delivery Cost per Region = Total Delivery Cost / Total Deliveries in the Region

   • Objective: To compare regional delivery cost efficiency.

5. Delivery Issues per 100 Deliveries

   • Formula: (Number of Delivery Issues / Total Deliveries) × 100

   • Objective: To track the rate of issues and address quality concerns.

Slicers/Filters

• Date Range

• Delivery Regions

• Courier ID

• Time Window (Morning, Afternoon, Evening)

• Delivery Issues (Type or Severity)

Visuals

1. Bar Chart: On-Time Delivery Percentage by Region.

2. Line Chart: Trends in Average Delivery Time over months.

3. Pie Chart: Breakdown of Delivery Issues by Type.

4. Table: Delivery Cost per Region with filterable columns.

5. Gauge Chart: Real-time CSAT Percentage.

---

Pickup Dashboard 6

Problem Statement

To evaluate the performance and efficiency of the pickup process, optimize courier allocation, and minimize delays while maintaining high customer satisfaction.

KPIs

1. On-Time Pickup Percentage

   • Formula: On-Time Pickup % = (Number of On-Time Pickups / Total Pickups) × 100

   • Objective: To measure adherence to promised pickup time windows.

2. Late Pickup Percentage

   • Formula: Late Pickup % = (Number of Late Pickups / Total Pickups) × 100

   • Objective: To track and reduce delayed pickups.

3. Average Pickup Time

   • Formula: Average Pickup Time = Total Pickup Duration / Total Pickups

   • Objective: To evaluate the average time taken for successful pickups.

4. Courier Utilization Rate

   • Formula: Courier Utilization Rate = (Courier Active Hours / Total Courier Available Hours) × 100

   • Objective: To analyze the workload and utilization of couriers.

5. Task Completion Rate Per Courier

   • Formula: Task Completion Rate = Total Tasks Completed / Number of Active Couriers

   • Objective: To measure courier efficiency.

Slicers/Filters

• Date Range

• City

• Courier ID

• Pickup Time Window (Morning, Afternoon, Evening)

• Pickup Delay Duration

Visuals

1. Bar Chart: On-Time Pickup Percentage by City.

2. Line Chart: Average Pickup Time Trend over weeks.

3. Pie Chart: Courier Utilization Rate distribution.

4. Table: Task Completion Rate Per Courier with sortable columns.

5. Gauge Chart: Late Pickup Percentage.

---