en flag +1 214 306 68 37
Data Science Solution for Sales Analysis and Forecasting

Data Science Solution for Sales Analysis and Forecasting

Industry
Manufacturing
Technologies
MS SQL Server, Python

Customer

The Customer is a European dairy manufacturer that is holding leading positions on the domestic market, as well as exporting their wide portfolio of goods to 20+ countries worldwide.

Challenge

The Customer was dissatisfied with unstable sales performance vs. the plan and, consequently, missed sales targets. They wanted to get accurate sales forecasting and achievable targets per product category, per brand and per store. Besides, the Customer wanted to understand the gap between their plan vs. fact sales performance and identify potential for improvement.

Solution

ScienceSoft’s data scientists started with cleaning the historical data. For example, our team removed duplicates by narrowing down differently spelled street names in the stores’ addresses to one correct record.

Our data scientists had a detailed look at plans vs. actual sales per product category, per brand, per store and per region. To ensure accurate sales forecasting, the team excluded the influence of promotions and developed an algorithm that allowed selecting the most relevant statistical model. Depending on how far back the sales history went, one of the four models was automatically chosen: linear regression, autoregressive integrated moving average (ARIMA) model, median forecasting or zero forecasting.

While running advanced analysis, ScienceSoft’s data science team identified three criteria to find improvement potential for the Customer’s sales performance. Our team figured out the benchmark product, store and region, then calculated sales opportunities for other products, stores and regions compared with the relevant benchmarks and considered this revealed potential in the forecasting.

Results

The Customer received an accurate sales forecast built on statistical models and algorithms applied to historical sales data with a growth rate added.

ScienceSoft also identified the potential of up to 15% for the Customer’s sales improvement that was calculated based on a benchmark product, store and region. These improvements were included into the sales forecast delivered to the Customer.

Technologies and Tools

Microsoft SQL Server (a data warehouse), Microsoft SQL Server Integration Services, Microsoft SQL Server Analysis Services (online analytical processing), Python, Microsoft Excel, Microsoft Excel Power Pivot.

Have a question to our team or need help with your project?

Our team is ready to provide client references, estimate your project, or answer any other question related to your IT initiative.

Upload file

Drag and drop or to upload your file(s)

?

Max file size 10MB, up to 5 files and 20MB total

Supported formats:

doc, docx, xls, xlsx, ppt, pptx, pps, ppsx, odp, jpeg, jpg, png, psd, webp, svg, mp3, mp4, webm, odt, ods, pdf, rtf, txt, csv, log

More Case Studies