Fact tables
8
Dimension tables
9
Total rows modelled
5,102
Enterprise star schema
Click any table to inspect columns, keys, relationships, record counts and sample records
Fact tables
Dimension tables
Grain: One row per invoice lineSource: Sage AccountingRows: 580
| Column | Type | Key |
|---|---|---|
| id | string | PK |
| invoiceId | string | FK → FactInvoice |
| dateKey | int | FK → DimDate |
| customerId | string | FK → DimCustomer |
| productId | string | FK → DimProduct |
| amount | money | |
| cost | money | |
| grossProfit | money |
Relationships: → DimDate (dateKey) · → DimCustomer (customerId) · → DimProduct (productId) · → FactInvoice (invoiceId)
Example records
5 rows
| id | invoiceId | orderId | dateKey | date | customerId | productId |
|---|---|---|---|---|---|---|
| FS1 | INV1 | SO0002 | 20260218 | 2026-02-18 | C026 | P0012 |
| FS2 | INV1 | SO0002 | 20260218 | 2026-02-18 | C026 | P0031 |
| FS3 | INV1 | SO0002 | 20260218 | 2026-02-18 | C026 | P0008 |
| FS4 | INV2 | SO0003 | 20250914 | 2025-09-14 | C035 | P0013 |
| FS5 | INV2 | SO0003 | 20250914 | 2025-09-14 | C035 | P0033 |