Visualizing the Data Warehouse: Metrics and Dashboards for the University of Missouri System Enterprise Data Warehouse and Reporting Team

Presentation Summary

Adam Morris, University of Missouri System)

Managing a data warehouse is no small task. Large quantities of data, complex data transformations, and institutional demand for reports create a challenging environment. One way to help manage the complexity is to keep a finger on the pulse of the day to day operations of the warehouse, and to gather data to measure how operations change over time - whether for better or for worse. This presentation will discuss tools and metrics the University of Missouri System Enterprise Data Warehouse and Reporting Team uses to aid in the day to day monitoring and future planning of Warehouse operations. While the UM System environment uses specific tools for reporting and data transformation, this presentation will demonstrate visualization examples that could be done in any data warehouse environment. Topics covered in the presentation will include: Visualization goals, Specific metrics identified, Operational vs tactical metrics, Strategic Metrics: Looking at The Big Picture.