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
