A Procedure with MySQL Python for Developing Data Warehouse and Analytics Using Data from a Greek Soft Drinks Company

The research focuses on the process of creating a data warehouse to meet the decision-making needs of a Greek beverage company. The data cover the period from 2018 to 2022. The developed data warehouse schema follows the star schema, with one fact table and five-dimension tables. Based on this structure, a web application was developed in PHP, which displays reports, charts, and analyses on the company's performance through interactive queries. Additionally, prediction functions tailored to the company's data were developed in Python. The process followed, the queries for creating the data warehouse, as well as the commands for creating analyses and predictions, serve as a useful guide for other companies that wish to upgrade the capabilities of their ERP systems.