Analytics Reports MAIN WIKI
From UG
(Difference between revisions)
(→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.