1. Executive Overview & Health Summary
Owner: elena.rostova@northwind-global.example • Upstream Connectors: SQL Server / Azure SQL, Snowflake
2
Tables (2 Import / 0 DQ)
4
Columns (0 Calculated)
3
DAX Measures
1
Relationships (0 Bi-Di)
4
Power Query Steps
1
Bound Reports
Healthy model architectureZero refresh errors, non-production endpoints, bidirectional filter traps, or local file dependencies detected.
2. Data Model & Star Schema
Fact tables (blue) vs. Dimension tables (teal) • Hover or click any table to highlight relationshipsflowchart LR
classDef factNode fill:#e8f1fd,stroke:#0b63ce,stroke-width:2px,color:#0f172a;
classDef dimNode fill:#e6f6f4,stroke:#0f766e,stroke-width:1.5px,color:#0f172a;
classDef standaloneNode fill:#f8fafc,stroke:#94a3b8,stroke-width:1px,color:#334155;
T1["[DIM] Dim Calendar (1 cols, 0 meas)"]
T2["[FACT] Fact GL Margin (3 cols, 3 meas)"]
T2 -->|"PostingDate = Date (*:1)"| T1
class T1 dimNode;
class T2 factNode;
| Many / Fact Side | Cardinality | One / Dimension Side | Filter Direction | State |
|---|---|---|---|---|
Fact GL Margin.PostingDate | * : 1 | Dim Calendar.Date | Single | Active |
3. Data Sources & Tables Blueprint
Storage modes, source endpoints, business descriptions, visual Power Query pipelines, and column definitions
| Table | Role | Mode | Connector | Endpoint / Database | Description | Cols | Measures | PQ Steps |
|---|---|---|---|---|---|---|---|---|
| Dim Calendar | Dimension | import | Snowflake | Snowflake: northwind.eu-central-1.snowflakecomputing.com | Shared corporate fiscal calendar. | 1 | 0 | 2 |
| Fact GL Margin | Fact | import | SQL Server / Azure SQL | SQL Server / Azure SQL: sql-fin-prod.database.windows.net | Consolidated General Ledger revenue and COGS postings. | 3 | 3 | 2 |
Dim Calendar : Shared corporate fiscal calendar.
| Column | Data Type | Origin / Source Column | Format | Description |
|---|---|---|---|---|
| Date Key | dateTime | Date | - | - |
Power Query Transformation Pipeline (2 steps)
1. SourceSnowflake.Databases→2. ViewExpression
View Power Query M Script - Partition Dim Calendar (import)
let Source = Snowflake.Databases("northwind.eu-central-1.snowflakecomputing.com", "WH_ENTERPRISE"), View = Source{[Name="DIM_CALENDAR_ISO"]}[Data] in View
Fact GL Margin : Consolidated General Ledger revenue and COGS postings.
| Column | Data Type | Origin / Source Column | Format | Description |
|---|---|---|---|---|
| PostingDate Key | dateTime | PostingDate | - | - |
| RevenueEUR | decimal | RevenueEUR | - | - |
| CogsEUR | decimal | CogsEUR | - | - |
Power Query Transformation Pipeline (2 steps)
1. SourceAzureSql.Database→2. ViewExpression
View Power Query M Script - Partition Fact GL Margin (import)
let Source = AzureSql.Database("sql-fin-prod.database.windows.net", "DB_FINANCE"), View = Source{[Schema="mart",Item="v_FactGLMargin"]}[Data] in View
4. DAX Measure Catalog
Auto-formatted & organized by Table → Display Folder → Base Aggregations first, Derived KPIs second
| Measure | Host Table | Display Folder | Tier | Format | Reads | Used By | DAX Preview |
|---|---|---|---|---|---|---|---|
| COGS | Fact GL Margin | P&L Core | Base | #,##0 "EUR" | 1 | 1 | SUM('Fact GL Margin'[CogsEUR]) |
| Gross Revenue | Fact GL Margin | P&L Core | Base | #,##0 "EUR" | 1 | 1 | SUM('Fact GL Margin'[RevenueEUR]) |
| Gross Margin % | Fact GL Margin | Profitability | Tier 1 | 0.0% | 2 | 0 | DIVIDE([Gross Revenue] - [COGS], [Gross Revenue], 0) |
5. Interactive End-to-End Live Lineage
Click any source, table, column, DAX measure, or report to trace live upstream & downstream impact6. Row-Level Security (RLS), Downstream Reports & Access
0 RLS role(s) • 1 bound report(s)No Row-Level Security (RLS) roles defined in this model.
| Downstream Report | Report Workspace | Report Type |
|---|---|---|
| CFO Monthly Margin & Cashflow Pack | Corporate Finance & FP&A | PowerBIReport |