The Application of Data Warehouse in Teaching Management in Colleges and Universities

Abstract

Data warehousing refers to the process of organizing data from different sources to support the process of decision making in organizations as well as support data analytics. Data warehousing assimilates and systematizes data from across different departments in an organization to have a single analysis of the full information. This data is then used to make the decisions in an organization. However, data warehousing has been underestimated in education institutions. The reason is that they are non-profits organizations. With the increase in the number of educational institutions coming up, colleges and universities should consider the integration of such data-driven support systems to make better decisions and for more organization in the academic processes especially for those institutions with different branches. The intricacy in managing these institutions requires development on how consistent information can be relayed to the decision-makers of an institution. This paper explains the need for data warehouses in education institutions and how the teaching institutions can implement data warehousing to help in the management of the institutions. The paper also explores and reviews various methods that institutions can use to mine data. Various stages for promoting and actualizing the system have been shown.

Design and Implementation of a Data Warehouse for Managing an Educational Institution

“…All the entities that were challenged in the design of this proposed system are represented by applying the relationship rules between entities, attributes, and constraints, with the type of relationship between them mentioned in Figure (1), which shows the entity relationship diagram (ER_Diagram) for the database system .…”

“…For one to be confident of future success, knowledge is essential and a crucial element while starting out in any field and the information to be reviewed must come from reliable sources just like all other elements and factors one takes into consideration before making a decision. In the digital world , people often prefer to extract information from a group of databases called data warehouses [1].…”

A Novel Multi-Dimensional Analysis Approach to Teaching and Learning Analytics in Higher Education

“…[29] introduces the implementation process of a data warehouse at Waist University to improve admission and examination processes. Furthermore, the recent data warehouse applications in education are summarized by [30,31] to help institutions explore various methods to mine the teaching and learning data.…”

Building Data Marts in Teaching Management: A Case Study

“…The non-volatility aspect ensures that the data in the data warehouse is accurate and reliable. This can guarantee the leadership of the institution in making decisions (Subrahmanyam & Doja, 2008) (Subrahmanyam & Doja, 2011) (Yu, 2021) So, the advantages of building a data warehouse are subject-oriented data, integrated data, non-volatility data, and time variants (Han et al, 2012) (Oracle, 2022. Of course, the advantages of building a data warehouse will be maximized if the data warehouse gets data input from various valid and relevant sources.…”