USING A DATA WAREHOUSE SYSTEM TO MONITOR AND ANALYZE SALES PROCESS WITHIN FOOD INDUSTRY
DOI:
https://doi.org/10.24867/17OI02KaticKeywords:
Data Warehouse, SAP Netweaver 7.5, Information Systems and TechnologyAbstract
This paper describes basic concepts of mode-ling Data Warehouse for purpose of tracking and analyzing retail business process within food industry. Paper also covers basic characteristics of Data Warehouse System. The tool, which is choosen for implementing Data Warehouse is SAP Netweaver 7.5, and it is also described in the paper, as well as its components. After describing chosen tool, the paper describes source system, conceptual and implementation schema of Data Warehouse and steps of ETL (Extraction, Tranfsormation, Load) process. In the end, the paper covers created reports and steps of creating them.
References
[1] R. Kimball, M. Ross. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (Third Edition). Wiley, Indianapolis, 2013.
[2] R. Kimball, J. Caserta. The Data Warehouse ETL Toolkit: Practical Techniques for Extracing, Cleaning, Conforming, and Delivering Data. Wiley, Indianapolis, 2004.
[3] https://www.guru99.com/all-about-classical-extended-star-schema.html (pristupljeno u oktobru 2021.)
[2] R. Kimball, J. Caserta. The Data Warehouse ETL Toolkit: Practical Techniques for Extracing, Cleaning, Conforming, and Delivering Data. Wiley, Indianapolis, 2004.
[3] https://www.guru99.com/all-about-classical-extended-star-schema.html (pristupljeno u oktobru 2021.)
Downloads
Published
2022-06-08
Issue
Section
Information Systems Engineering
