Home>Data Lake Creation & Reporting Services

Data Lake Creation & Reporting Services

Client

For a global retail conglomerate’s US arm

Business Problem

  • Our client wanted to support their reporting, analytical and archival needs in a unified data lake
  • Also wanted to replace the outdated reporting platform 

Abzooba’s Solution:

  • Azure Data Factory to ingest data from disparate sources
  • Transformations and data-driven workflow for orchestrating and automating data movement through a combined pipeline with an execution schedule
  • Automatic splitting of workloads across various processors which scales up and down on demand
  • Data Lake in Azure Data Lake Storage
  • Data Warehouse to store all final transformed data with Power BI connected to it for report generation

Business Benefits:

  • Support a user base of 300-400 individuals
  • Approximate monthly data volume of 2.5TB
  • Increase efficiency and effectiveness of reporting

Tech Stack

Speak to AI expert