Development of Student Data Mart Using Normalized Data Store Architecture

As one of the private university in Indonesia, Muhammadiyah University of Yogyakarta make assessing the performance and feasibility of the institution. The data required in the accreditation process includes various aspects, such as student, alumnus, employee, facilities and others. However, to obtain that data, the institution is still having trouble because the data is not yet integrated. Integrated data obtained by building a data warehouse. This research uses data warehouse with Normalized Data Store (NDS) architecture. There are some noise was found that need to be cleaned, such as null data and duplication data. Student data mart has been built and it can meet the requirements of the institution that are displayed in a report.