KPI

From UG

(Difference between revisions)
Jump to: navigation, search
(→DR1 Simple Shipment count DR)
(→DR1 Simple Shipment count DR)
Line 41: Line 41:
** if on Client show list of E0s after visibility rules are applied
** if on Client show list of E0s after visibility rules are applied
-
* ''' Year ''' filter: timeframe, use '''CT Created On date'' to associate CT with the year
+
* '''Year''' filter: timeframe, use '''CT Created On date'' to associate CT with the year
* '''Shippers vs Consignees''' selector:
* '''Shippers vs Consignees''' selector:

Revision as of 04:39, 28 May 2012


Contents

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' filter: timeframe, use CT Created On date to associate CT with the year
  • Shippers vs Consignees selector:
  • 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:

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

Dependencies

  • 3567, 3575 are in parallel

3567 DR1 Simple Shipment count DR

  • Sasha: Java/SQL
  • Vic: graphics

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 DR/KPI:ph1 [DR/KPI] DR2 Complex Shipment Data per Client per Year DR, PART A

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

Architecture and Technical Design and Code Review

Retrieved from "https://wiki.jaguarfreight.com/KPI"
Personal tools