Advanced analytics as a tool for effective trade marketing in retail

Background. In a highly competitive world in the tobacco market, companies face the need to optimize their data analysis and decision-making processes. The main problem is the processing of ever-growing volumes of sales data that were previously stored and analyzed in Excel, which led to slower analysis processes, calculation errors, and reduced effectiveness of marketing strategies. To solve this problem, the company’s management decided to switch to using modern technologies.

The relevance of the study is due to high competition in the tobacco market and the need to optimize data analysis and decision-making processes. Previously, sales data was stored and analyzed in Excel, which slowed down analysis, led to calculation errors, and reduced the effectiveness of marketing strategies.

Purpose: to develop and implement a machine learning-based data analysis and sales forecasting system to improve the effectiveness of trade marketing

Methodology. The work uses machine learning methods, automation of analytical reporting, as well as tools for working with data (PostgreSQL, Power BI, Python). Airflow is used to manage the execution of data processing scripts and model training, monitor the updating of analytical reports, and integrate the system with CRM.

Results. A data processing and analysis system has been developed; data has been transferred from Excel to PostgreSQL to solve encoding problems; automatic data loading and conversion mechanisms have been implemented; high-quality data preparation for analysis has been carried out.

Practical implications. The results of the study can be applied in companies working with large volumes of data; in the field of business analytics and working with big data; in industries with fierce competition and complex market conditions.