AWS Native ETL and Dashboarding
Retail & CPGBusiness Impacts
Automation of Organizational Tasks
Quick and Reliable Processing
Enhanced User Experience
60% Cost Reduction on Infrastructure
Customer Key Facts
- Location : India
- Industry : Retail
Problem Context
The customer is a leading sporting goods retailer who provides a diverse range of products. They had data present in Redshift, PostgreSQL and flat-flies and use Qlik Sense for creating dashboards. Qlik Sense data models are used for transformations and takes around eight hours for loading, transformations and aggregations and then creating visualizations in Qlik Sense.
Challenges
- Overall load and processing time data was more considering the huge data
- Multiple sources of data
- Data stored in multiple tables needs complex transformations and aggregations
- Highly confidential data needs high security and governance
Technologies
Amazon Quicksight
Amazon Cloudwatch
AWS Lambda
Amazon Redshift
Solution:
Quantiphi helped the customer by building an AWS cloud-native solution. By building an automated workflow for ETL and dashboarding in QuickSight, the customer can provide KPIs and charts to 700+ stores in production in real time. The solution will reduce the overall time by 30 percent as well as increase the responsiveness of dashboards and reduce the overall cost.
Results:
- Enhanced User Experience as the dashboards are more responsive
- Quick and reliable processing as dashboards are more responsive
