UTILIZATION OF THE DATA WAREHOUSE SYSTEM IN THE COMPANY’S SALES SECTOR FOR IMPORT, PRODUCTION AND DISTRIBUTION OF FOOD PRODUCTS
DOI:
https://doi.org/10.24867/24BE08BozicKeywords:
Data Warehouse, Data Warehouse systems, business reporting, sales analysisAbstract
The research study portrays the utilization of the Data Warehouse (DW) system in the sales sector of the company for the production and trade of food products. Projected architecture of database store system and schema of the database for the decision making in the sector are shown. Implementation of software support for ETL process realization has been described. Over the DW system are generated reports intended for business improvement and better decision-making in sales strategies.
References
[1] Branković M., "Poslovna inteligencija", 2012. [Online]. Dostupno na: https://old.vts.edu.rs/images/nastava/PoslovnaInteligencija/PI_skripta.pdf [Pristupljeno: Novembar, 2022]
[2] Luković I. Beleške sa predavanja, 2022
[3] Ralph Kimball, Margy Ross, “The Data Warehouse Toolkit”, treće izdanje, Wiley, 2013. [E-book]. Dostupno na: https://aatinegar.com/wp-content/uploads/2016/05/Kimball_The-Data-Warehouse-Toolkit-3rd-Edition.pdf
[4] William H. Inmon, “Building the Data Warehouse”, četvrto izdanje, Wiley, 2005. [E-book]. Dostupno na: Bulding the Data Warehouse 4 Edition.pdf (hcmute.edu.vn)
[5] Oracle, "Database 2 Day + Data Warehousing Guide", https://docs.oracle.com/cd/E11882_01/server.112/e25555/toc.htm [Pristupljeno: Decembar, 2022]
[6] Akshat Mathur, “Introduction to Pentaho Data Integration – Theory For Foundational Understanding”, knoldus.com, Jan. 31, 2022. [Online]. Dostupno na: Introduction to Pentaho Data Integration - Theory For Foundational Understanding - Knoldus Blogs [Pristupljeno: Januar, 2023]
[2] Luković I. Beleške sa predavanja, 2022
[3] Ralph Kimball, Margy Ross, “The Data Warehouse Toolkit”, treće izdanje, Wiley, 2013. [E-book]. Dostupno na: https://aatinegar.com/wp-content/uploads/2016/05/Kimball_The-Data-Warehouse-Toolkit-3rd-Edition.pdf
[4] William H. Inmon, “Building the Data Warehouse”, četvrto izdanje, Wiley, 2005. [E-book]. Dostupno na: Bulding the Data Warehouse 4 Edition.pdf (hcmute.edu.vn)
[5] Oracle, "Database 2 Day + Data Warehousing Guide", https://docs.oracle.com/cd/E11882_01/server.112/e25555/toc.htm [Pristupljeno: Decembar, 2022]
[6] Akshat Mathur, “Introduction to Pentaho Data Integration – Theory For Foundational Understanding”, knoldus.com, Jan. 31, 2022. [Online]. Dostupno na: Introduction to Pentaho Data Integration - Theory For Foundational Understanding - Knoldus Blogs [Pristupljeno: Januar, 2023]
Downloads
Published
2023-09-05
Issue
Section
Electrotechnical and Computer Engineering
