DESAIN DATA WAREHOUSE PENJUALAN MENGGUNAKAN NINE STEP METHODOLOGY UNTUK BUSINESS INTELEGENCY PADA PT BANGUN MITRA MAKMUR

Abstract

The development of technology, fast, accurate and reliable information is a very important requirement for an organization. Information has a very important role in determining the life and death of a company. PT Bangun Mitra Makmur is a company engaged in the sale of goods which includes goods such as cement and non-cement and has a marketing area covering Lampung and South Sumatra. Sales transaction data in the sales division related to data on sales of goods is so large and large that it requires large storage media and it is difficult to process these data for making reports that are used by management for making a decision. Processing sales data to produce reports takes a long time because it is still processed with the help of the Microsoft Excel application. The large amount of sales transactional data stored cannot be used as a basis for analysis before further data processing is carried out to be used as a basis for top level management levels in making a decision. Sales data warehouse is designed using the Nine Step Methodology data warehouse so as to produce a better data warehouse design using star schema modeling and using star schema will speed up queries for information delivery.