Design and Implementation of Educational Data Warehouse Using OLAP

Abstract

-Educational Data Mining (EDM) is a method to support learning and teaching processes. Educational Intelligence (EI) is not wide spreading like a business Intelligence (BI). Data Warehouse (DW) technology aims to collect historical data from different kinds of Database (DB) and unifies them under single schema by using the most powerful tool as OLAP which helps the decision maker to make a right decision. Educational Intelligence system combines Educational records of students from two different sources in a single DW. The inputs of educational data warehouse can be in any format (such as reports...). Since the quantities are huge, they are almost meaningless, on the other hand the outputs mainly consist of reports and flowcharts and KPIs with meaning and effective factor for decision maker. The proposed DW is implemented based on two simulated databases of Computer Science Department in the College of Science, University of Basra for the last ten years and AL_IRAQ University for the last 4 years implemented by SQL Server 2014 and SQL Server Data Tool (SSDT) 2012.