Proceeding of the Faculty of technical Sciences, Novi Sad

Information Systems Engineering

Vol. 37 No. 06 (2022): Proceedings of the Faculty of Technical Sciences

USING A DATA WAREHOUSE SYSTEM TO MONITOR AND ANALYZE SALES PROCESS WITHIN FOOD INDUSTRY

  • Svetlana Katić
DOI:
https://doi.org/10.24867/17OI02Katic
Submitted
June 8, 2022
Published
2022-06-08

Abstract

This paper describes basic concepts of mode-ling Data Warehouse for purpose of tracking and analy­zing 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, concep­tual 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.)