Utilization of Data Warehouse in Business Intelligence with Kimball Method at Company XYZ

Utilization of Data Warehouse in Business Intelligence with Kimball Method at Company XYZ

연구 분야: Databases

학회: 2021 International Conference on Artificial Intelligence and Big Data Analytics

For a large company the speed of processing and distribution of data is very important. However, at Company XYZ, this has not yet been implemented in its entirety. This hinders the progress of the company. To be able to solve these problems, a storage system is needed that can access data more quickly and effectively by using a data warehouse system. This study discusses the design and construction of a data warehouse using the Kimball method. The data warehouse schema is created using SQL Server Management Studio and Microsoft SQL Server Integration Service. The analysis results from the data warehouse are displayed in the form of a dashboard using Microsoft PowerBI and a web-based application. Judging from the dashboard display that has been made, the production environment at PT Bio Farma is stable so it does not interfere with production quality. The data is entered into a web-based application, with the percentage of application feasibility of 84% after testing.