Case Study

Data Warehouse Audit

Data Warehouse Audit

Client’s Data Warehouse (DW) stores critical enterprise data catering to data requirements of Finance, Operations, Marketing Data Warehouse Audit Customer: UK MVNO Scope 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 ndings have helped the client x the problem of late arrival of processed data Made suggestions on technical stack changes (e.g., leverage Redshift)

Join for free to read