Technologies: Python, MySQL, JSON, Excel, Power BI, Jupyter Notebook.
A system for gathering and analysis of information along with a system for supplies and sales forecast has been developed within this project.
Sales, stock balance and events data is being gathered via online marketplaces Wildberries, OZON, Yandex.Market and SberMegaMarket.
Data that is unavailable for online marketplaces’ API is being uploaded to the system manually by using XLS-files.
A process for data cleaning has been created as well. Clients’ data analysts have been provided with a special interface for modelling and further testing using Business Analytics frameworks such as Power BI.
The prediction model in this project uses ML algorithms.