Faculty of Engineering and the Built Environment Directorate:

Faculty of Engineering and the Built Environment Directorate: Strategic Management Support Department of Mechanical Engineering ITS VIEWS DATA WAREHOUSE 1

Faculty of Strategic Management Support Directorate: Department of WHAT IS A DATA WAREHOUSE? A Data Warehouse (DW) is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more different sources. 2

Faculty of Strategic Management Support Directorate: Department of GENERAL REPORTING CHALLENGES Most of the data is stored in ITS, which is difficult for end-users to access The data stores were designed for transaction processing not reporting Obtaining the data or a report usually requires waiting for a programmer to develop the report End-users do not have the knowledge of what is kept in the existing data stores. 3

Faculty of Strategic Management Support Directorate: Department of ADVANTAGES OF THE ITS VIEWS DATA WAREHOUSE Operational tables and views are linked in the back-end, and presented on the front-end in a way that makes sense to the user Improved and timely end-user access to a wide variety of University data Providing a platform to combine related data from separate sources Increased Query and System Performance Enhanced Business Intelligence 4

Faculty of Strategic Management Support Directorate: Department of DATA CURRENTLY INCLUDED Student applications Student bursaries Enrolment quotas Student qualification enrolments Student subject registrations Student graduations Student residence Staff service records General ledger: transactions and commitments 5

Faculty of Engineering and the Built Environment Directorate: Strategic Management Support Department of Mechanical Engineering THANK YOU 6