Analytics Reports MAIN WIKI
From UG
(Difference between revisions)
(→Core need) |
(→Core need) |
||
Line 7: | Line 7: | ||
== Core need == | == 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” 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 |
Revision as of 23:30, 30 September 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” 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