Fastest Growing FMCG Brand Streamlines Sales Data And Reporting System With AWS And Power BI

Problem Statement

With high data volume being created (3 lakh+ daily order processing), our client encountered challenges storing, managing, optimizing and transforming their data in cube storage. They also struggled with high TAT for reporting extending upto a few hours due to a lack of streamlined processes. They were looking for a solid data architecture backed analytics and reporting optimization.

Key Challenges

• Numerous data silos & multiple versions of data and files
• Lack of homogeneity in file formats, erroneous coding and hardcoded values
• Data volume & integration challenges from multiple data sources in different formats
• Lack of visibility into their sales data & dashboards

Solution Areas

Complete process understanding by bottleneck analysis at granular level.

• Data Automation on AWS Cloud
• Refined, integrated and transformed all the sales data into single Data Estate
• Implementation of Lambda and DMS for Data Collections at Near Real time
• Cube as Semantic Layer
• Power BI Reporting and Excel Reporting on Cube for Self Service