A data warehouse data model for Royal Malaysian Customs / Zainizam Yusof

Present age, data warehouse has become a primary agenda to every organization in the world including government agencies. Since the first concept of data warehouse has been around in late 1980s, it became apparent valuable information to the top level management as well as operational team. Having a good data warehouse solution is tremendously beneficial many organisations in the world including Malaysian Government to study the consumer trends and pattern for better business strategy formulation. Royal Malaysian Customs (RMC) in which is a government agency under the Ministry of Finance (MOF) has played a vital role as the key revenue collection agency for the Malaysian Government and RMC is the second largest revenue collection agency for the country. Since 1992, RMC has actively developed their ICT solution in stages to support their businesses in facilitating business trade and community. Everyday RMC is dealing with a lot of Customs transactions which generated a million of trade records. These records are valuable information for the country to be analysed in order to identify the business pattern, develop economic planning and national decision making. A proper data warehouse design and architecture must be in place to support RMC to prepare the organization in fulfilling National Agenda towards Vision 2020 via new strategic plan which recently introduced by the seventh Malaysia Prime Minister. Realizing the importance of having a suitable design for RMC data warehouse and preliminary study found that RMC does not have a suitable design for data warehouse for data visualizing and decision making, this research is intend to evaluate current practice of data warehouse at RMC, then to specify the requirements and later do re-design new data warehouse data model for RMC.