Distribution Dashboard

High Level Design

Overview

A distribution dashboard provides high-level transparency of distributor routes, the number of shipments, and timeliness of shipments.

Goal

Identify which distributors are positively or negatively affecting the overall on-time delivery rate. Identify what the relationship between the number of shipments and on-time delivery for distributors. Optimize distributor selection by avoiding one distributor carrying excessive volume.

Objectives

1. Identify which distributors can handle more volume
2. Identify and reduce dependency under-performing distributors
3. Identify distributors by distribution path

KPIs Architecture

Objectives	KPIs	Measures	Data Source
Identify which distributors can handle more volume	Distributor On-Time Delivery / Volume ratio	AVG on-time delivery	Distributor, Time Resolution, Pickup-State
		Total delivery	Distributor, Time Resolution, Pickup-State
Reduce dependency on under-performing distributors	Bottom ten on-time delivery by distributors	Distributor filtered to bottom ten by on-time delivery	Distributor
Identify distributors by distribution path	On-time delivery	On-time deliveries – late deliveries; if negative format as red.	Pick-up State, Delivery State

Entities Relationship Diagram

Plugins & Scripts used

1. Remove horizontal borders
2. Connect points of scatter chart in chronological order
3. Change line type in the drilled dashboard
4. Route Map Plugin