KPI

From UG

Contents 1 Info 2 Requirements 3 Solution 3.1 DR1 Simple Shipment count DR 3.1.1 DR1 Graphics and UI mock up 3.2 DR2 Complex Shipment Data per Client per Year DR, PART A 3.2.1 DR2 General Info 3.2.2 DR2 Mock Up 3.2.3 DR2 Left panel 3.2.4 DR2 Air by Ocean comparison table 3.2.5 DR2 Tab1 Top Shippers, Consignees 3.3 DR2 Complex Shipment Data per Client per Year DR, PART B 3.3.1 DR2 Tab2 3.3.2 DR2 Tab3 4 Work breakdown structure and Change Requests 4.1 Dependencies 4.2 3567 Rapidly Create Simple Shipment count DR using just ZK libs and java libs 4.3 3575 Evaluate LogiXML 4.4 0003583 DR/KPI:ph1 [DR/KPI] DR2 Complex Shipment Data per Client per Year DR, PART A

Info

• mantis parent: 0003545: [ DR KPI Phase I ) ..... <parent mantis >]
• mantis category: DR/KPI:ph1
• lead SA/PM: Alex
• lead Dev/Architect: Sasha

Requirements

• This Phase One should include first portion of DRs/KPIs delivered
• Must be production quality
• This phase is for Arden only (all MOTs)
• More phases will follow shortly that would be for other E0 Clients
• This project is very important top visibility project
• Also right tool/lib should be evaluated/selected for the future (example: LogiXML vs ZK API/other Java APIs)
• due dates:
  • production - end of June
  • vendor/libs evaluation - TBD

Solution

DR1 Simple Shipment count DR

• this DR should appear within panel on KPI Dashboard ("KPI" link form CT2 Client Header)

• requirements:
  • DR panel has two filters:
    • (Client E0) - single select;
    • Created on date (from date to date).
  • Below is radio ("Shippers"-default vs "Consignees" )
  • Below is radio (bar chart-default vs pie)
  • Below is parameter: "Display top <textbox>" (for example 5)
  • Below is graphics
  • axis X: 6 bars for top 5 (as far as number of CTs) Shippers (or Consignees) with labels and 6th represents all remaining Shippers/Consignees
  • axis Y: Number of CTs (for selected E0, for specific Shipper/Consignee)
  • User can change filters/controls and system will re-draw plot on the fly

• must be integrated seamlessly from:
  • look and feel experience (should blend in CT2 Client front end)
  • security (display only dashboard allowed for particular user)
    • QA test: assign one KPI to one user, one to another and verify what they see
  • parameter for report should be controlled through user profile and DR panel
    • number 5 should be a default parameter in user profile
    • also user should be able to change it on the screen and system would re-draw

DR1 Graphics and UI mock up

Pie chart example:

Bar chart example:

DR2 Complex Shipment Data per Client per Year DR, PART A

DR2 General Info

• DR2 should appear in "the standard ZK panel" (on homepage or on "KPI dashboard" - see "KPIs" link in top menu on Client) (not tab).
• DR2 should be available as option in user profile (on/off).

DR2 Mock Up

Status Note: below version is not final and has some errors:

Original outdated version: 700 px

DR2 Left panel

• Client Company

if on internal then show all E0; if on Client show all after visibility rules are applied

• Year

use Ct#Actual_Delivery_Date

• MOT

Air, LCL, FCL(AW), FCL(MLB)

• Country type . Options:

origin - (use country in Shipper)

destination - (use country in Consignee)

• red/green arrow

this indicates change from previous year

if data for previous year is unavailable then I suggest to have no arrow

mouse over pop-up - no need for now - no time for that

• black markers

please ignore them for now

• country flags

if possible add flag icons

DR2 Air by Ocean comparison table

• Ocean - combine LCL and FCL
• Regions - as defined in CT2 - see below:
  • if easy to implement show only regions that have data

Africa s
Antarctica s
Asia m
Australia and New Zealand s
Caribbean s
Eastern Europe & Russia s
Greater China b
Middle East b
North America b
South America m
Western Europe b

for mock-up example: b - big cycle,  m - medium, s - small

DR2 Tab1 Top Shippers, Consignees

Re-use #DR1 Simple Shipment count DR

DR2 Complex Shipment Data per Client per Year DR, PART B

DR2 Tab2

TBD

DR2 Tab3

TBD

Work breakdown structure and Change Requests

Dependencies

• 3567, 3575 are in parallel

3567 Rapidly Create Simple Shipment count DR using just ZK libs and java libs

• Mantis: http://ct.jaguarfreight.com/mantis/view.php?id=3567
• Dev: Sasha

Prove that it is possible to Rapidly Create #DR1 Simple Shipment count DR using just ZK libs / java libs.

3575 Evaluate LogiXML

• Mantis: http://ct.jaguarfreight.com/mantis/view.php?id=3575
• Dev: Kostya

0003583 DR/KPI:ph1 [DR/KPI] DR2 Complex Shipment Data per Client per Year DR, PART A

• kostya and sasha