Client: Food Delivery company in organized pizza market
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.
- 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
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