Design and Implementation of Educational Data Warehouse Using OLAP

  • Abdullah Z
  • Obaid T
Citations of this article
Mendeley users who have this article in their library.


-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.




Abdullah, Z. A. S., & Obaid, T. A. S. (2016). Design and Implementation of Educational Data Warehouse Using OLAP. IJCSN International Journal of Computer Science and Network, 5(5), 2277–5420. Retrieved from

Register to see more suggestions

Mendeley helps you to discover research relevant for your work.

Already have an account?

Save time finding and organizing research with Mendeley

Sign up for free