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

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation