Scope
- Client’s Data Warehouse (DW) stores critical enterprise data catering to data requirements of Finance, Operations, Marketing and other stakeholders
- Certain key issues currently faced in the DW ecosystem:
- Unavailability of processed data by 8 am London time
- Inconsistency across data systems
- Data quality issues
Solution
Sasken performed a 3600 audit of client’s Data Warehouse that included
- Data architecture
- Integration architecture
- Process
- Infrastructure
Impact
- Sasken’s findings have helped the client fix the problem of late arrival of processed data
- Made suggestions on technical stack changes (e.g., leverage Redshift)