Perancangan Data Warehouse Sebagai A lat Analisis Penjualan Sepeda Motor Menggunakan Skema Snowflake (Studi Kasus CV.Apollo Sakti Motor)

Abstract

Chooses CV. Apollo Sakti Motor as a source of research data collection because the data report system of sales which is sent to the head office is still in the extension of xls. That is the reason why the writer develops an easily and accurately accessible application in order to find out the profitability of the sold products. Data warehouse is required to support the data analysis of the measurement of the product profitability at the level of distributors, to monitor the profit of sales and to keep the product from long-time and out-of-date inventory. Data Warehouse and OLAP. are a system used for multi-dimensional business summary report for manager and admin. In data warehouse, data itself can be visualized in certain charts of lines, bars, and tables and the charts explains maximum, minimum, and average value of Yamaha products which are sold.