Data Warehouse Design for Multi Finance Companies
Main Article Content
Abstract
Data is an important asset in an organization which is the basis for managers company to make policies, carry out strategies, or make decisions. Data processing can be done in various places, for example in databases operational, operational applications, or using technology data warehouse. The system data warehouse is connected to heterogeneous data sources and is used by decision makers to analyze the conditions and development of the organization. In this research, the initial stage is to carry out a system analysis database operational, studying the software and hardware used at PT XYZ to get an understanding of the current system requirements. Then data warehouse will be designed and set the ETL (Extract, Transformation, Loading) data needed from the database system that is running to the data warehouse that has been designed. The design of a data warehouse uses the Kimball method which consists of nine stages of the methodology (nine-step methodology). With the design results, it is hoped that it can provide a design data warehouse that can be implemented easily to support activities business analysis multi-finance and answer business questions quickly, flexible, and accurate
Downloads
Metrics
Article Details
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.