Data Analytics
Azure Data Factory
Snowflake
dbt
Power BI
Medallion · Star Schema
Enterprise BI Platform — Snowflake + Power BI
A reference architecture for the problem most multi-country organisations actually have: data scattered across an ERP, a CRM, on-prem databases, field spreadsheets, and external APIs. This platform ingests all of it with Azure Data Factory, consolidates and conforms it in a Snowflake medallion warehouse (modelled with dbt), and serves a single governed Power BI semantic model — so every dashboard reads from one trusted version of the numbers.
~75%
Less Manual Reporting
Problem Statement
Finance pulls numbers from the ERP, sales lives in the CRM, operations keep spreadsheets, and external rates come from an API. Each team reconciles its own version by hand, monthly reporting takes days, and leadership sees four different totals for the same metric. The blocker is not visualisation — it is the absence of one consolidated, governed source.
The solution: ingest every source on a schedule, land it in Snowflake, conform and model it through a medallion architecture with dbt, and expose a single Power BI semantic model with documented DAX measures and row-level security. One model, one set of definitions, many dashboards.
How It Works
🔌
1. Multi-Source Ingestion
Azure Data Factory pipelines extract from Dynamics 365 Business Central, a CRM, on-prem SQL Server, Excel/CSV field files, and REST APIs — incrementally, on a schedule, with retry and logging.
🏔️
2. Consolidate in Snowflake
Raw data lands in a Bronze layer, is cleaned and conformed into Silver, and is shaped into Gold business marts. Snowflake scales compute independently so heavy transforms never slow down reporting.
🧱
3. Model with dbt
dbt transforms Silver into a tested, documented star schema — fact and dimension tables with surrogate keys, data tests, and lineage so every number is traceable to its source.
📊
4. Serve in Power BI
A single Power BI semantic model connects to the Gold marts, defines DAX measures once, applies row-level security, and powers executive, finance, and regional dashboards that all agree.
See it in the demo: the sandbox shows the live data flow end to end, a working Power BI-style report whose slicers recompute the visuals, and the star-schema model that links every dataset together.