Feel free to ask tough questions relating to Crystal Reports / SQL Reporting Services / SQL and get answers from Collective intelligence
Thursday February 9th 2012

An example of University of Toronto Business Intelligence (UTBI)

This Post is about University of Toronto Business Intelligence (UTBI). University of Toronto Business Intelligence (UTBI) is a service-oriented program focused on empowering the University’s information analysts and decision-makers.    We are including this in our website because we found that very help in understanding Data Mart, Data Ware House and Business intelligence concepts.

The UTBI data warehouse is a central repository of information for analytical and reporting needs at the University. It is a collection of data marts that holds information sourced from the various enterprise-wide applications, such as ROSI, HRIS, FIS, Research and DIS. These Data Marts are doing there jobs i.e focusing on their related functional area such as Human resources or specific businesses prosses( e.g enrollement analysis) .

UTBI has currently several data marts may prove helpful in answering your business question few of these are as under; Enrollement Data Mart, Human Resource Data Mart, Research data Mart, Graduate Student Financial support Data Mart, Donations and Alumni Services Data Mart,

Reporting Statistics Data Mart. UTBI has several projects under way. It is also possible to to see a pictorial overview of the data marts.

Links are as follows;

University of Toronto Business Intelligence (UTBI)
Human Resources Data model

Research Data Model
Student Income Data model

Leave a Reply