Designing a Virtual Data Warehouse in Supporting Sales Information Needs (Case Study: National Scale Building Material Store X)

Authors:

Andrew Sumichan, I Made Gede Yudiana, Muhammad Ridwan Satrio, I Made Sudarma

Abstract:

“National-scale building material stores that have branches in various regions certainly want the business to run smoothly. This must be supported by good sales activities at the central store and also branch stores spread in various places. However, there is no solution to collect sales data from branch shops quickly, causing a slow response to the analysis of the increasing trend in sales of goods and goods whose sales trend has dropped. This can reduce sales competitiveness in this national scale business with similar competitors. Virtual data warehouses can help collect scattered operational data, in this case sales data located at branch stores in various locations are then collected into a data warehouse that is stored in the cloud server so that it can be processed for strategic decisions. Virtual data warehouse is a data warehouse that connects operational databases regardless of where the database is located and regardless of the format, looks as if somewhere and in a consistent format. This study produces a virtual data warehouse structure that applies the kimball nine step design method so that it produces a data warehouse schema model with the star scheme. This study explains the design of a virtual data warehouse that can facilitate analysis of sales data at national scale building material stores that have branches in various places”

Keywords

Keyword Not Available

Downloads:

Download data is not yet available.

References

References Not Available

PDF:

https://jurnal.harianregional.com/ijeet/full-53625

Published

2019-10-07

How To Cite

SUMICHAN, Andrew et al. Designing a Virtual Data Warehouse in Supporting Sales Information Needs (Case Study: National Scale Building Material Store X).International Journal of Engineering and Emerging Technology, [S.l.], v. 4, n. 1, p. 45–48, oct. 2019. ISSN 2579-5988. Available at: https://jurnal.harianregional.com/ijeet/id-53625. Date accessed: 28 Aug. 2025.

Citation Format

ABNT, APA, BibTeX, CBE, EndNote - EndNote format (Macintosh & Windows), MLA, ProCite - RIS format (Macintosh & Windows), RefWorks, Reference Manager - RIS format (Windows only), Turabian

Issue

Vol 4 No 1 (2019): January - June

Section

Articles

Copyright

This work is licensed under a Creative Commons Attribution 4.0 International License