Problem Statement
The current platform with Excel-based operations suffers from inefficiency due to its siloed structure. Separate teams manage different listings (Free, Catalogue Services, Premium) creating fragmented information. Adding to this, the teams must download raw data from the ERP system into individual spreadsheets, and then manually merge them back into a single, error-prone master Excel file. This leads to leading to slow operations, inaccurate reporting, and ultimately affects the platform's effectiveness.
Key Challenges
- Inconsist and non-standard formatting challenges to the Master Dump.
- Prone to human errors difficult to track in a spreadsheet.
- Manual processes leading to productivity loss and inefficiencies.
- Inaccurate Sales data reporting due to the lack of a centralized repository.
- No real-time view into the business health, leading to last-minute hassles.
Solution Implemented
- Automated data import from flat files & Oracle ERP using Amazon S3.
- Transformed & validated data with AWS Glue for accurate reporting.
- Centralized data repository in Amazon Redshift with data governance.
- Real-time & interactive reports built with Microsoft Power BI.
Architecting with the Best Tech Stack
Any Challenges ?
Our Industry Experts can solve your problem.
