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

Enterprise BI Platform — Live Demo

A decision-ready Power BI experience backed by a governed semantic model. Filter the report, inspect the pipeline or open the star schema.

⚙️ 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.
Executive Sales PerformanceSales_Gold semantic model · refreshed today
Model online
Current view
All years · All regions
Year
Region
480 fact rows
All portfolio data
Revenue
$
Calculating
Gross Margin
%
Target 35%
Orders
#
Calculating
Avg Order Value
Ø
Calculating

Revenue trend

24 months

Revenue by region

Click a bar to filter

Category mix

Share of revenue

Top products

Ranked by revenue
ProductRevenueMargin

Every tile recomputes from the same governed semantic model. Demo data is generated in your browser.

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.

All Projects War Room