Analytics Reports MAIN WIKI
From UG
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.