KPI v2

From UG

Revision as of 22:26, 26 September 2013 by Alex (Talk | contribs)
Jump to: navigation, search

Contents

Info

Overview

KPI module consists of the following components:

Internal App Components

Client App Components

  • [[]]

KPI Admin

Consists of:

KPI Settings Panel

Edit KPI Panel

KPIs core logic

Association between WQMY and record

We formulate it in terms of CT and not Shipment#Shipment.

For every KPI we need to decide what criteria to use to associate CT with a particular week/month/Quarter/Year.

Same association criteria for all classes of KPIs now:

Air/Ocean: CT#Destination Port Actual Arrival Date
or 
Truck modes: CT#Destination Door Actual Delivery Date

Exclusion logic

Exclusion if shipment is deleted or alike

Exclude CTs that are:

  • canceled or
  • deleted or
  • rejected (from ASN)

Exclusion if parameter in KPI formula is undefined

Examples:

  • If KPI is a time frame then exclude shipments that have only one out of two dates/times that define the interval present in the system.
  • In CPUs if cost is undefined or unit is undefined

Exclusion if need to divide by zero

KPIs UI

KPIs link

KPIs Homepage

WMQY selector

Radio type control that has 4 values:

  • Wk
  • Mo
  • Qtr
  • Yr

Selection will affect what is displayed on all panels.

Filters

KPI class Tab

Individual KPi selector

Summary Panel

Settings Panel

Left Panel

Top Right Panel

Bottom Right Panel

Drilldowns

xls

header

Consists of lines:

FlashLight	
<date generated>	
<class name>	
KPI name: <KPI name>
Number of matches: <number of CTs included into output OR numb of records in output including commode lines ? >
Client Company: 	<Filter value>
Mode of Transport: <Filter value>	
TimeFrame: 	<WMQY value>
Currency: 	<value set in ???>
Additional filters: 																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																															
Shipper:	<Filter value>	
<more filters>																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																											


Example:
-------
FlashLight	 
26-Sep-2013	
Volumes KPI	
KPI name:	CT Count
Number of shipments: 	13
Client Company: 	Elizabeth Arden
Mode of Transport: 	Air
TimeFrame: 	Week 30 (22–28 Jul 2013)
Currency: 	USD
Additional filters: 																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																															
Shipper:	ELIZABETH ARDEN - Roanoke - 1751 blue hills

KPI classes

Volumes class

CT count

Left and Top Right panels:

  • Number of CTs that satisfy Association, Inclusion, Filters and WMQY criterias.

Total Spend

Gross KG

CWT KG

CBM

  • (LCL only)

TEU

  • (FCL only)

CPU class

Lead Times class

LO class

Shipments Per Lane KPI

  • label: "Weekly/ Monthly Avg Shipments per Lane"
  • definition: This shows how many shipments there are on average per lane per week or month
Weekly: Weekly Average   
Monthly: Month Average   
Quarter: Total Quarter Count - divided by 3 month (average per month)   
Annual: Total annual count - divided by 12 month (average per month)
  • hint label:
If "period" is 3 weeks or less, show the "average shipment for this week"   
If "period" is 1 month or more: Show  'average shpt count per month for this period'  
Formula 1 
---------
Average shipments per lane = number of Shipments / number of Lanes
. 
Note: above is for specific timeframe, for specific filters applied
Example 1.
=======
Shnt#  Shipper  Consignee
---------------------- 
CT1     A           X
CT2     A           X
GRP1    B           Y
GRP2    A           X
GRP3    B           Y
GRP4    B           Y
unique lanes: AX, BY
number of shipments = 6
number of lanes = 2
average shipments per lane = number of shipments / number of lanes = 6/2 = 3

Left panel and Top Right Panel

  • one KPi value per week/month/quarter/year
  • for data for 2011, 2012, 2013 (partial), ordered, latest at the top

Bottom Right Panel:

EU class

Personal tools