Consolidating Data Reporting With SQL2016 & PowerBI

UOT

This afternoon I read a really interesting case study from the University of Tennessee on how they transformed their business reporting and compliance through consolidating their data onto SQL2016 & PowerBI.

Read the full case study here.

It’s worth reading the entire article (about 5mins) as the University has five campuses and two institutes which previously had individual reporting and analytics tools. To resolve this, a three pointed focus was created around:

  1. Consolidated repository
  2. Report verification process
  3. Data access and stewardship process

As the University was already using Office365, the decision to use PowerBI and SQL2016 as the backbone of their new BI solution made a lot of sense. Some impressive gains were made from this digital transformation project:

  • Data verification time decreased from 45minutes to 10 seconds (a 99% reduction)
  • This allowed the organisation to do multiple validations a day, rather than waiting until the close of business to perform a single audit.
  • The University is a USD$1.2 billion dollar enterprise and yet despite their size they are able to support their BI with a team of just six staff.
UoT by Degree

Click the above to view some sample reports of real data. Note that you can scroll through five different reports using the arrows at the bottom of the report (visible once you’ve clicked above).

For larger HigherEd / Tertiary institutions the above is likely a compelling story in data transformation and reporting.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s