Comprehensive Guide to Implementation of Data Warehouse in Education

Data warehouse, otherwise known as DW, is a central repository to hold the history of data which will be created by the integration or consolidation of data from several external sources and from the operational and transactional data stores of the organization. This data repository will be majorly used by the firms to analyze the data for empowering ideal business decisions to get decided. It performs the role of a system for decision support (DSS), to obtain conclusion based on the analyzed pattern of data to the decision maker(s) of the organization. Usage of data warehouse in education will give a great benefit to the government/private educational officers, by obtaining a single version of the truth of school information. This paper analyzes the work implemented in the education domain focusing on DW concepts in detail.