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 Mock Up 3.2.2 DR2 General Info 3.2.3 DR2 Main menu 3.2.4 DR2 Left panel 3.2.5 DR2 Top Right panel 3.2.5.1 DR2 Air by Ocean comparison table 3.2.6 DR2 Bottom Right panel 3.2.6.1 DR2 Tab1 Top Shippers, Consignees 3.2.7 DR2 Misc 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 Sequence 4.2 Graphic 4.3 3567 DR1 Simple Shipment count DR 4.4 3575 Evaluate LogiXML 4.5 0003583 DR2 Complex Shipment Data per Client per Year DR, PART A 4.6 0003595 Complex Shipment Data per Client per Year DR, PART B 5 Architecture and Technical Design and Code Review

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 - end of May

Solution

DR1 Simple Shipment count DR

• See mock-up below

• Title: Top Shippers / Consignees

• Location: this DR should appear on homepage

• Axis X: display Shippers or Consignees plus "Others"
  • display largest to smallest (left to right)

• Axis Y: shipment count

• Bars vs Charts - two displays to be supported, need selector to switch between two

• Client Company filter:
  • single select
  • if on internal then show all E0;
  • if on Client show list of E0s after visibility rules are applied

• Year: timeframe filter. Use CT Created On date to associate CT with the year

• Shippers vs Consignees selector: group by indicator

• Top X selector:
  • controls in how many groups to separate shipments
  • one additional group is always "Others"
  • default value is to be managed through User Admin on internal
  • max choice= 10

DR1 Graphics and UI mock up

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

Pie chart example:

Bar chart example:

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

DR2 Mock Up

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

Original outdated version see here: File:DR2.JPG

DR2 General Info

This DR consists of:

• Title : "Shipment data by Year and by Geography"
• #DR2 Main menu (at the top)
• #DR2 Left panel
• #DR2 Top Right panel
• #DR2 Bottom Right panel

DR2 Main menu

• Client Company:
  • single select
  • if on internal then show all E0;
  • if on Client show list of E0s after visibility rules are applied

• Year': timeframe, use CT Created On date to associate CT with the year

• MOT: options see below
  • Air
  • Ocean (combine all ocean modes LCL, FCL(AW), FCL(MLB))

• Country type: options - see below
  • Origin - (use country in Shipper)
  • Destination - (use country in Consignee)

DR2 Left panel

• two column table sorted by country alphabetically
• left column: countries that correspond to origin/dest countries - selection in the main menu
• right column: corresponding total weight of all CTs for particular country
• max (now shows 10,000 on mock up) - design option: use appropriate scale based on max value for data available
• red/green arrow

this indicates change from previous year (red - up; green - down)

if data for previous year is unavailable then no arrow

• country region indicators

color of the dot indicates what region they belong to

• paging

DR2 Top Right panel

DR2 Air by Ocean comparison table

• Title: Air by Ocean comparison table

• Axis X: ocean shipments count

• Axis Y: air shipments count

• Plotted data:
  • each dot corresponds to one Region
  • color of the dot indicates what Region is it as defined on Legend
  • size of the dot is proportional to the total weight of the CTs for given Region

• Regions - as defined in CT2 DB - see below:
  • if easy to implement show only regions that have data

• Legend: indicates unique color per Region

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

this is note for Vic: in your mock-up example use this typical distribution: b - big,  m - medium, s - small

DR2 Bottom Right panel

This is a multi tab panel. Some tabs are defined under Part B (another section).

DR2 Tab1 Top Shippers, Consignees

Re-use #DR1 Simple Shipment count DR

Please note that in this case we do not need these filters displayed on the panel (since thes values are selected in Main Menu):

• time frame
• E0 Client Company

Also in this case more filters would be applied (see main menu):

• MOT
• country type

DR2 Misc

• DR2 should appear as "standard ZK panel" (on "KPI Dashboard" page - see "KPIs" link in top menu on Client App).
• DR2 should be available as option in User Admin on internal App (on/off).

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

DR2 Tab2

TBD

DR2 Tab3

TBD

Work breakdown structure and Change Requests

Sequence

• first 3567, 3575 in parallel
• next 0003583
• next 0003595

Graphic

All done by Vic.

3567 DR1 Simple Shipment count DR

• Sasha: Java/SQL

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

3575 Evaluate LogiXML

• Kostya, Vlad

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

• kostya: SQL, Java b-end
• sasha: b-end, f-end

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

Architecture and Technical Design and Code Review