Open AccessKonsolidasi Data Warehouse untuk Aplikasi Business Intelligence
Author(s) -
Rudy Rudy
Publication year - 2012
Publication title -
comtech/comtech
Language(s) - English
Resource type - Journals
eISSN - 2476-907X
pISSN - 2087-1244
DOI - 10.21512/comtech.v3i2.2313
Subject(s) - data warehouse , online analytical processing , business intelligence , consolidation (business) , computer science , dashboard , database , warehouse , competitive intelligence , knowledge management , process management , business , marketing , accounting
As the business competition is getting strong, corporate leaders need complete data that as a basis for determining future business strategies. Similarly with management of company "A", a pharmaceutical company which has three distribution companies. Each distribution company already has a data warehouse to generate reports for each of them. For business operational and corporate strategies, chairman PT "A" requires an integrated report, so analysis of data owned by the three distribution companies can be done in a full report to answer the problems faced by the managemet. Thus, data warehouse consilidation can be used as a solution for company "A". Methodology starts with analysis of information needs to be displayed on the application of business intelligence, data warehouse consolidation, ETL (extract, transform and load), data warehousing, OLAP and Dashboard. Using data warehouse consolidation, information access by management of company "A" can be done in a single presentation, which can display data comparison between the three distribution companies.