Konsolidasi Data Warehouse untuk Aplikasi Business Intelligence
Keywords:data warehouse, consolidation, business intelligence
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.
Guan, J.,Nunez, W., & Welsh, J.F. (2002). Institutional Strategy and Information Support: The Role of Data Warehousing in Higher Educatio. Campus-Wide Information Systems, 19 (5), ISSN 1065-074.
Hwang, Mark I., & Xu, Hongjiang (2007). The Effect of Implementation Factors on Data Warehousing Success: An Exploratory Study. Journal of Information Technology and Organizations, 2. Diakses dari http://jiito.org/articles/JIITOv2p001-014Hwang40.pdf.
Inmon, W.H. (2005). Building the Data Warehouse (4th edition). Indianapolis: Wiley.
Loshin, David (2003). Business Intelligence: the Savvy Manager’s Guide. San Francisco: Morgan Kaufmann.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: