Applications Data Warehouse for Sales Analysis Based on Multidimensional Modeling (MDM) and Star Schema Design
DOI:
https://doi.org/10.61841/04zdpd62Keywords:
Data warehouse, Multidimensional modeling (MDM), Star schema designAbstract
The data warehouse is a collection of the data used to support strategic decision-making process in an organization. This paper will discuss the design of the data warehouse in one of the industry in sales (distribution sales) of the start of the phase of data collection, analysis of business needs and information, data selection and design of data warehouse, data loading into data warehouse and the later displaying information to end user. By implementing a multidimensional modeling (MDM) of a data warehouse is built based on the method of OLAP (Online Analytical Processing) and can be displayed with the star schema design, to produce information that can analyze the sales data accurately, which can assist the company in taking decisions right appropriately and efficiently.
Downloads
References
[1] W. H. Inmon, Building the Data Warehouse, 4th Edition. Indianapolis: Wiley Publishing, Inc., 2005.
[2] Olivia Mia Sugiyono, “Aplikasi Data Warehouse untuk Analisis Penjualan Mobil Berbasis Multidimensional Modeling
[3] Ariana Azimah and Yudho Giri Sucahyo, mplementasi Data Warehouse Untuk Menunjang Kegiatan Akademik," in Seminar Nasional Sistem dan Informatika 2007, Bali, 2007, pp. 270-275.
Downloads
Published
Issue
Section
License
Copyright (c) 2020 AUTHOR
This work is licensed under a Creative Commons Attribution 4.0 International License.
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.
