Analytics Reports MAIN WIKI

Revision as of 21:28, 5 October 2011 by Alex (Talk | contribs)

Info

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

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