Analytics Reports MAIN WIKI
From UG
(Difference between revisions)
(→Core need) |
(→Core need) |
||
Line 13: | Line 13: | ||
* Used as a tool for modeling of how to tweak different parameters such as transit times and utilization rates to reduce costs | * 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 | * Challenge is that every time we need to pull fresh data and apply formulas and charts | ||
- | * we also want to have “in system” version of these reports | + | * we also want to have “in system” (DR (Dashboard Reports)) version of these reports |
* see 2 examples in 0003003 | * 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 | ** 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 |
Revision as of 21:28, 5 October 2011
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