Business Intelligence for Education Management System

The main function of school operations is scoring and reporting. Each of them is unique in every school and cannot be generalized although using the same curriculum. School personnel such as headmaster, teacher, and staff also not only assigned to one school location and can have multiple roles in each school location. With that complexity, a single query is not fast enough to generate a scoring report. This paper proposed the system business intelligence which can analyze the progress of student learning. This paper used nine steps to design a data warehouse as a tool business intelligence. The On-line Analytical Processing (OLAP) is used to analyze the data and visualize them using dashboard. By using data warehouse, each school can answer business question relation to scoring and visualize them in a dashboard to make a decision.