The purpose of this study is to perform databases planning that supports Prototype Modeling Data Warehouse in the Ministry of Agriculture, especially in the Distribution Center and Reserves in the field of distribution, reserve and price. With the prototype of Data Warehouse, the process of data analysis and decision-making process by the top management will be easier and more accurate. Researchs method used was data collection and design method. Data warehouses design method was done by using Kimballs nine steps methodology. Database design was done by using the ERD (Entity Relationship Diagram) and activity diagram. The data used for the analysis was obtained from an interview with the head of Distribution, Reserve and Food Price. The results obtained through the analysis incorporated into the Data Warehouse Prototype have been designed to support decision-making. To conclude, Prototype Data Warehouse facilitates the analysis of data, the searching of history data and decision-making by the top management.
S.Kom E. P. P, S.Kom F, Lay C and Sudarma H. (2015). Modelling of Data Warehouse on Food Distribution Center and Reserves in The Ministry of Agriculture. ComTech, 6 (3), 422-434.
data warehouse, database, distribution, modeling