Data Warehouse Content

The UTBI data warehouse is the central repository of information for analytical and reporting needs at the University. It is here that data, sourced from the various enterprise-wide applications (ROSI, HRIS, FIS, Research, Degree Explorer, Telecommunications, etc.) has been merged and organized into a single reporting database. Subject areas currently contained within the data warehouse include: Admissions, Course and Program Enrolment, Student Awards & Fees, Student Housing, Enrolment Planning, Procurement, Human Resources, Research, Graduate Student Support.

Central Data Warehouse Diagram
Central Data Warehouse Diagram (click image to enlarge)

Course Enrolment Data Mart

The Course Enrolment data mart contains undergraduate course enrolment data for Applied Science & Engineering, Arts & Science, UTM and UTSC. The data cubes house current enrolment counts and enrolment counts on Count Date (M08). There are a variety of reports available for use such as:

  • Detailed Class Lists
  • Summary of Course Offerings by Department
  • Summary of Enrolments (including Drops and Waitlists) by Department and Course Level
  • Analysis of Enrolments at key points in the term (Milestones) such as FINCA date, first day of classes, Count (M08) date, etc.

The data includes demographic details of the student such as gender, age, fee category and year of study. The data within the data mart holds data for session 20079 forward.

Intended Audience:

Dean and Faculty Registrar Offices – Applied Science & Engineering, Arts & Science, UTM, UTSC

Ontario Admissions (Market Share) Data Mart

The OUAC Admissions data mart contains information from the OUAC Annual Historical Statistics file relating to undergraduate admissions. This data is distributed, on an annual basis, by OUAC for research purposes. This data is to the level of the applicant, however data has been “anonymized” by OUAC. Data is available for fall sessions for 1998 forward. The data cube and reports track the number of applications, offers and registrations to each Ontario university.

The data includes demographic details of the applicant such as gender, age, region of residence, citizenship, Ontario secondary school, senior level course credit marks, number of years in an Ontario Secondary School and averages. For application details, the desired university, choice, and programs are included for the first twenty applications. In addition, university offers and registrations are available within the data set.

Intended Audience:

Enrolment Services, Student Recruitment Officers

Admissions Data Mart

The Admissions data mart contains information on undergraduate applications to Applied Science & Engineering, Arts & Science, Physical Education & Health, Music, UTM and UTSC. The data cube and reports track the number of applications, offers of admission, acceptances and registrations.

The data mart includes demographic information on the applicant, with a focus on where applications come from (by country of citizenship, permanent address and address of the latest institution of the applicant).

Intended Audience:

Enrolment Services, Student Recruitment Officers, Faculty Registrars

Student Housing Data Mart

The Student Housing data mart contains information on individuals who reside in one of the sixteen facilities operated or affiliated with the University of Toronto. Data is extracted from ROSI and each residence facility. The focus is on three areas:

Demographic information: gender, citizenship, regional location, dependent counts.
Residence information: facility details, room style.
Academic information: active degree POSt, faculty, college, year of study, last institution.

The data mart supports the bi-annual census (November 1st and March 1st) and only consists of data from November 1, 2010 forward.

Intended Audience:

Student Housing Service, Residence Administrative Staff

Enrolment Data Mart

Initiated by the Office of the Vice-Provost Planning & Budget, the Enrolment data mart allows users to quickly and easily get to their valuable planning information, particularly important with the new UofT budget module. It provides P&B and the UofT academic divisions with multi-year and multi-session headcount, Full-Time Equivalents and Basic Income Unit data for use in planning, making projections, funding analysis and reporting. UTBI offers users the popular Enrolment cube, which is a multi-dimensional analytical database that allows its users to quickly and easily get to valuable planning information.

With the new budget module at the UofT, use of the Enrolment cube will be crucial to Academic Division and Department budget planning. Request your access now.

Intended Audience:

Planning and Budget, Academic Division Information Analysts/Planning offices

Research Data Mart

The Research data mart contains awarded Research Applications and applications for Research Grants. It has information about the Primary and Co-investigators of the Research Projects and the locations of the research. The data mart also stores Sponsor information, including Sponsor Divisions and Programs.

Intended Audience:

Research Services, Divisional Research Offices, Planning and Budget

Graduate Student Financial Support Data Mart

Sourced from ROSI and HRIS, the Graduate Student Data Mart contains student demographic information, program of study, registration status, student awards, student employment information, and funding sources.

It is the most comprehensive source of information for Graduate Student funding analysis at the University, and one of the most popular UTBI data marts.

Intended Audience:

Planning and Budget, Faculty Registrars, Awards Officers

Procurement Data Mart

The Procurement data mart contains information relating to departmental purchases. The data is sourced from the financial system in AMS and is updated in the data mart once a week. It has information on the amount of money paid to a vendor by a particular department as well as how much the department actually spent. The focus is on how money is spent with regards to the different types of purchases (Invoice, Purchasing card, UShop) as well as look at spending patterns over time. Other items of interest include fund centres, GLs and funding granting agencies.

Intended Audience:

Procurement, Financial Services, Information + Technology Services