Data Warehouse Audit

Customer:UK MVNO

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)
Data Warehouse Audit

Customer:Mobility Software Provider

Customer:Global Energy Management Specialist