The UT System Business Intelligence (BI) team facilitates the use of information across the entire System for improved decision making. We provide the only place that brings data together from multiple information systems and multiple campuses to deliver a “single version of the truth” for any University of Tennessee constituent.

Visit bi.tennessee.edu or contact us at bi@tennessee.edu.

 

Services

BI provides an array of services to system offices which can be found at bi.tennessee.edu/catalog.

All data is stored in the UT System’s Consolidated Data Repository.

Data source systems (IRIS, ANDI, Banner, and others) feed into the first layer, Extract, Transform, Load (ETL) and Data Quality Checking, powered by Microsoft SQL Server Integration Services (SSIS).
After passing quality check data is stored in a staging environment, Data Warehouse, and Consolidated Data Repository, all powered by Microsoft SQL Database Engine.
A data dictionary for all sources and definitions is maintained independently for this data model.
Semantic models powered by Microsoft SQL Server Analysis Services (SSAS) interpret information from the Consolidated Data Repository for a presentation layer. These take the form of data visualizations, including reports and dashboards generated with the Power BI reporting service.

 

Frequently Asked Questions

What services can BI provide to campuses?

While we encourage you to first check with your local campus IT departments to see what campus BI resources may be available, we do provide our entire catalog of services to UT constituents at all campuses and institutes.

Is there any cost to my department to use the BI platform?

In general, there is no cost; however, report authors who need to share their work require a Power Business Intelligence Pro license; as of June 2020, the cost for this license is less than $25/per person per year.

Can I import data from the BI platform into an unsupported tool?

Yes – with approval. However, we will not provide support should issues arise.

Can I bring additional data into the BI platform?

Yes – with approval. Generally the data needs to be for official university business and beneficial to multiple departments or groups.