Analytics Reports MAIN WIKI

From UG

Revision as of 22:49, 30 September 2011 by Alex (Talk | contribs)
Jump to: navigation, search


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)
    • one of the examples is well defined in TMS Monthly Stats Report