Analytics Reports MAIN WIKI

From UG

(Difference between revisions)
Jump to: navigation, search
(Core need)
Line 17: Line 17:
**  examples#1 is well defined in [[TMS Monthly Stats Report]] - see Copy of Copy of July Activity Stats Final.xlsx
**  examples#1 is well defined in [[TMS Monthly Stats Report]] - see Copy of Copy of July Activity Stats Final.xlsx
** ex#2 - see up+kpi+-+analytics+report+SAMPLE.rar
** ex#2 - see up+kpi+-+analytics+report+SAMPLE.rar
 +
 +
== SA notes / concept vision ==
 +
 +
=== Main goal ===
 +
=== Data ===
 +
=== Handling ===
 +
=== Output ===
 +
=== Modeling ===
 +
 +
== Suggested solution ==
 +
=== Content ===
 +
=== Visualization ===
 +
 +
== Implementation phases ==
 +
Implementation phases should be the same for every kind of analytics report.
 +
 +
=== Phase 1. Prepare DB ===
 +
* mapping of existing fields
 +
* list of new filds to add into DB
 +
 +
=== Phase 2. Data handling ===
 +
* define indicators and appropriate calculations
 +
 +
=== Phase 3. Output ===
 +
* visibility rules/admin part
 +
* versions of report - standalone, scheduled, dashboard
 +
* output format:
 +
** XLS/HTML,
 +
** tables & charts.

Revision as of 12:12, 9 October 2011


Contents

Info

0003003: (Analytics Reports) Create a module to produce this type of reporting

Core need

We want to automate generation of special class of xls reports ("Utilization and Cost Saving Modeling reports"):

  • based on CT2 database data
  • Complex: mulitab, mix of graphics and tables on one page
  • Normally related to utilization rates and costs, times
  • Used as a tool for modeling of how to tweak different parameters such as transit times and utilization rates to reduce costs
  • Challenge is that every time we need to pull fresh data and apply formulas and charts
  • we also want to have “in system” (DR (Dashboard Reports)) version of these reports
  • see 2 examples in 0003003
    • examples#1 is well defined in TMS Monthly Stats Report - see Copy of Copy of July Activity Stats Final.xlsx
    • ex#2 - see up+kpi+-+analytics+report+SAMPLE.rar

SA notes / concept vision

Main goal

Data

Handling

Output

Modeling

Suggested solution

Content

Visualization

Implementation phases

Implementation phases should be the same for every kind of analytics report.

Phase 1. Prepare DB

  • mapping of existing fields
  • list of new filds to add into DB

Phase 2. Data handling

  • define indicators and appropriate calculations

Phase 3. Output

  • visibility rules/admin part
  • versions of report - standalone, scheduled, dashboard
  • output format:
    • XLS/HTML,
    • tables & charts.
Personal tools