Analytics Reports MAIN WIKI

From UG

(Difference between revisions)
Jump to: navigation, search
(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"):
+
We want to automate generation of  special class of xls reports ("Utilization and Cost Saving Modeling reports"):
-
** based on CT2 database data  
+
* based on CT2 database data  
-
** Complex: mulitab, mix of graphics and tables on one page
+
* Complex: mulitab, mix of graphics and tables on one page
-
** Normally related to utilization rates and costs, times
+
* 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  
+
* 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” version of these reports  
-
** see 2 examples (in 0003003)
+
* see 2 examples in 0003003
-
**  one of the examples is well defined in [[TMS Monthly Stats Report]]
+
**  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
Personal tools