Three Tier-Level Architecture Data Warehouse Design of Civil Servant Data in Minahasa Regency

Abstract

Minahasa Regency is one of the regencies in North Sulawesi Province. In running the government in Minahasa Regency, a Regent is assisted by more than 6000 people Civil Servants (PNS) scattered in 60 SKPD. Badan Kepegawaian Diklat Daerah (BKDD) of Minahasa Regency is SKPD that performs data processing of all civil servants and is responsible for arranging and formatting civil servants. In the process of arranging and determining the formation of civil servants, many obstacles faced by BKDD. One of the obstacles is the unavailability of accurate data about the amount of educational background of civil servants based on rank/class, age, length of service, department, and so forth. The way to overcome the availability of data quickly and accurately is to do Business analytical. This process can be done by designing the data warehouse first. The design of data warehouse will be done by dividing it into three tiers of level.