Multi-source → Snowflake → Power BI Animated data flow Working slicers Star schema

Enterprise BI Platform — Live Demo

Three views of the same platform: the data-flow architecture (run the pipeline to watch data move from sources through Snowflake to Power BI), a Power BI-style report whose slicers actually recompute the visuals from a linked model, and the star-schema data model showing how every dataset connects. Demo data, generated in your browser.

⚙️ Dynamics 365 BCERP · finance 👥 CRMaccounts · pipeline 🗄️ SQL Serveron-prem ops 📑 Excel / CSVfield files 🌐 REST APIsFX · web Azure Data Factory orchestrate · ingest ❄ Snowflake 🥉 BRONZEraw landing · immutable 🥈 SILVERcleaned · conformed (dbt) 🥇 GOLDstar-schema marts (dbt) 📊 Power BIsemantic model · DAX · RLS 📈 Dashboardsexec · finance · regional

Run the pipeline

Trigger a scheduled run to watch data flow from each source, land in Snowflake, transform through the medallion layers, and refresh the Power BI model.

Idle. Click "Run scheduled pipeline" to begin.
Sales Performance · Power BI · semantic model: Sales_Gold · last refresh: today
Year
Region
Revenue
Gross Margin %
Orders
Avg Order Value

Revenue by Month

Revenue by Region

Revenue by Category

Top Products

ProductRevenueMargin

Slicers filter the fact table through its dimension relationships — every visual recomputes from the same model, exactly as in a real Power BI report.

1 1 1 1 1 ▣ FACT_SALES date_key · product_key customer_key · region_key channel_key · revenue · cost 📅 DIM_DATE 🔑 date_key year · quarter · month day · is_weekend 📦 DIM_PRODUCT 🔑 product_key product · category brand · unit_cost 🧑 DIM_CUSTOMER 🔑 customer_key customer · segment since · tier 🌍 DIM_REGION 🔑 region_key region · country manager 🛒 DIM_CHANNEL 🔑 channel_key channel · type is_online
🔑 Primary key on each dimension 1 → ∞ one dimension row relates to many fact rows Single-direction filters flow from dimensions into FACT_SALES

This is the shape Power BI consumes: a central fact table joined to conformed dimensions on surrogate keys. Slicers on any dimension (Year, Region) filter the fact through these relationships — which is what makes the report on the previous tab fully linked.