Integrating 12 sources into a unified data lake
Scenario
12 sources — ERP, CRM, marketplace, logistics API, cost spreadsheets — with no integration. The monthly report took 5 days and arrived inconsistent.
Solution
A Medallion data lake on Azure with automatic ingestion pipelines, a Gold layer modeled for Power BI and a full daily refresh in 1 hour.