Student Analytics Data Model


Printer-friendly version

Careers

Data Model for Student Analytics

This Data Model is based on the typical Life Cycle of a Student. The first thing a Student does is to register at a School, then sign up for Classes, followed by completion of Assignments, taking Exams and finally leaving the Schoool (or transferring) and taking his or her Transcripts.

A Data Mart has been created to help with Enquiries and Reports.

Conceptual KPIs and Dimensional Model This is intended for business users	Logical Students Dimensional Model This is intended for data analysts and designers (it takes data from the Data Warehouse (see below)
Detailed Data Warehouse Conceptual Model This is intended for business user.	Logical Data Warehouse Model This is intended for data analystas and designers.