| PT X is a home furniture manufacturer company with employee count over 3.000men. And every one of them has considerably complex human resource attributed such as work starting date, job grade, position grade, leaves, numeration, education, addresses etc. In an organization of PT X's size, each human resource with their attributed as mentioned, is going to have huge transactions upon them monthly. Over the time, the human resource count will increase with every recruitment event, promotion, demotion, staff transfer between working units, leaves, violation etc. With the complexity of of the transaction and the data involved, the company will need a system that is capable of extractiong the various bits of information, including summaries, that are useful for the company managers to support their decision-making process. In order to produce such information from such data, a Data Mart is one solution. As the data source, PT X is currently implmenting an HR ERP system that will maintin records of every HR transaction and data in the company. The ERP will provide data with high degree of integrity and history. THe objective of this Final Project is to build a Design of a Data Mart that cater for the general user requirements mentioned above. The end result of the Final Project, is an implementable design of Data Mart . The design is intenteded to be flexible, generic, and relatively cheap to implement. |