Table of Contents

Problem Statement

Customer was looking to develop a data platform that can evolve over time with the importance of data. A cloud enabled solution to provide good performance and a cost-effective solution. They were looking to build a new DWH which can be easily supported and enhanced going forward. It should be a highly scalable design for any future enhancement and need to support the reporting and analytics solution with high performance.

Solution Overview

  • Rationalized the overall existing solution and migrate to new modern enterprise data warehouse in Azure cloud environment.
  • Rationalized the overall existing solution and migrate to new modern enterprise data warehouse in Azure cloud environment.
  • Historically, business stakeholders were only able to work with small set of data and complex data model with some performance issues, but now with new EDW in place, they were consuming data with better performance.
  • Optimized data model for better reporting & Analytics to the business stakeholders.
  • Support future AI requirements through Data Lakes.
  • Robust data governance & data quality to support business in providing right data at right time.
  • AdfarTech designed the ADF pipelines to optimize the runtime cost.

Outcomes

  • Common Data Hub that supports data and analytics needs of various departments.
  • Common Data Hub that supports data and analytics needs of various departments.
  • Seamless integration of data
  • Seamless integration of data
  • Scale-out architecture enables
  • seamless increasing of technical resources to handle increase in data volumes.
    End-to-end data governance.
Modern EDW Solution for a Large UK based Financial Services Agency for dispute resolution