The Business Intelligence (BI) team gathers, warehouses, models, and visualizes data from multiple information systems across all University of Tennessee campuses and system administration. As part of the Institutional Effectiveness (IE) team, BI supports data-informed decision making and provides data for strategic planning and assessment purposes.
The BI team brings data onto their SQL Servers from a variety of sources across the system. These data enter staging databases and are then transformed and loaded to data warehouse databases. From there, views are created in consolidated data repository (CDR) databases, which is from where data are modeled for reporting. Data are modeled in SQL Server Analysis Services and Power BI for use in reports and Power BI dashboards. Publicly available Power BI dashboards created and maintained by the BI team are available at data.tennessee.edu.
Access to the BI SQL Servers is granted on a case-by-case basis and is usually granted only to users who have access to the data in the source system (e.g., a user cannot access additional information from IRIS through our servers; only what they can see in IRIS itself). Users should first request access to information on databases on their own campuses, when possible. Security is managed by the BI team in conjunction with the DTS Infrastructure team.
For more information, please contact us at firstname.lastname@example.org.