The University of Michigan is a non-profit institution with a $10B annual budget, 48,000 employees, 46,000 students, and includes a hospital, police force, transportation network, power generation, housing for thousands of students, and more. In 2016, the central Business Intelligence team was tasked by the President of the University to develop University and unit level reports on everything from students, to budget and finance, to HR and research. To accomplish this goal, connections were required across dozens of units and data providers across campus. The ensuing conversations ignited many ideas for improving those datasets and helping units determine what information they both wanted and needed.
This presentation will review how Tableau was used to overcome numerous hurdles, including utilizing dozens of data sets with different naming conventions, different data systems, and other inconsistencies, plus the need for cross-data set calculations. The Business Intelligence team utilized Tableau to create standardize reports accessible via a single and customized platform to deliver a holistic reporting experience for leadership to make better data-driven decisions.
