The Customer is a multinational FMCG corporation operating in more than 200 markets with 1 billion consumers and 60,000 employees across the globe.
One of the Customer’s national branches was distributing 100 SKUs through a marketing channel comprising 10 large retail chains and 10,500 stores. To perform sales analysis, the Customer had to collect data from retailers in multiple files and formats, which significantly reduced productivity and did not provide analysts with a holistic view. Therefore, ScienceSoft was commissioned with a project to create a system that would process and unify data to deliver advanced retail analytics.
ScienceSoft developed the system according to a high-level architecture containing three modules:
The Customer was satisfied with the solution as it provided a tool for an advanced sales analysis. The company is now able to identify sales trends, find out which SKUs and stores showed best performance, estimate growth potential as well as optimize sales and marketing activities. In cooperation with ScienceSoft, the Customer is also planning to implement elaborate data visualization.
MS Windows Server 2008 R2 (64 bit), MS SQL Server 2008 R2, Entity Framework 6.1.1, MS SQL Server Analysis Services, .NET 4.5, ASP.NET MVC 4, Bootstrap 3.0.1, Power Pivot for MS Excel