Data
The sample dataset feeding the semantic model — 30,000 generated sales rows across customers, products, regions, channels and calendar.
Transactional sales lines. The fact table of the model.
Fields
| Field | Kind | Type | Format | Description |
|---|---|---|---|---|
| Sale IDkey | column | string | — | |
| Order ID | column | string | — | |
| Order Date | column | date | — | |
| Customer ID | column | string | — | |
| Product ID | column | string | — | |
| Region ID | column | string | — | |
| Channel ID | column | string | — | |
| Quantity | column | integer | — | |
| Unit Price | column | currency | — | |
| Revenue | column | currency | — | |
| Cost | column | currency | — | |
| Discount | column | percentage | — | |
| Margin | column | currency | — | |
| Currency | column | categorical | — | |
| Total Revenue | measure | currency | — | Sum of Revenue across the filter context. |
| Total Cost | measure | currency | — | Sum of Cost across the filter context. |
| Total Margin | measure | currency | — | Total Revenue minus Total Cost. |
| Margin % | measure | percentage | — | Total Margin divided by Total Revenue. |
| Total Orders | measure | integer | — | Distinct count of Order ID. |
| Total Units | measure | integer | — | Sum of Quantity. |
| Total Customers | measure | integer | — | Distinct count of Customer ID. |
| Average Order Value | measure | currency | — | Total Revenue / Total Orders. |
| Average Selling Price | measure | currency | — | Total Revenue / Total Units. |
| Revenue per Customer | measure | currency | — | Total Revenue / Total Customers. |
| Units per Order | measure | decimal | — | Total Units / Total Orders. |
| Revenue YoY | measure | currency | — | Revenue change versus the same period last year. |
| Revenue YoY % | measure | percentage | — | Revenue growth versus last year. |
| Revenue MoM | measure | currency | — | Revenue change versus the previous month. |
| Revenue MoM % | measure | percentage | — | Revenue growth versus the previous month. |
| Margin YoY | measure | currency | — | Margin change versus last year. |
| Orders YoY | measure | integer | — | Order change versus last year. |
| Revenue Target | measure | currency | — | Target revenue from the Targets table. |
| Revenue Variance | measure | currency | — | Total Revenue minus Revenue Target. |
| Revenue Variance % | measure | percentage | — | Revenue variance relative to target. |
| Margin Target | measure | currency | — | Target margin from the Targets table. |
| Margin Variance | measure | currency | — | Total Margin minus Margin Target. |
Sample records
| Sale ID | Order ID | Order Date | Customer ID | Product ID | Region ID | Channel ID | Quantity | Unit Price | Revenue | Cost | Discount | Margin | Currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| S0000001 | O000001 | 2024-10-06 | CU00722 | P0131 | R06 | C02 | 6 | 49.73 | 298.4 | 253.02 | 0 | 45.38 | EUR |
| S0000002 | O000001 | 2024-10-06 | CU00722 | P0003 | R06 | C02 | 7 | 23.85 | 153.61 | 86.9 | 0.08 | 66.7 | EUR |
| S0000003 | O000001 | 2024-10-06 | CU00722 | P0002 | R06 | C02 | 8 | 18.74 | 149.93 | 115.34 | 0 | 34.59 | EUR |
| S0000004 | O000002 | 2026-05-10 | CU01875 | P0002 | R10 | C04 | 8 | 23.42 | 155.5 | 115.38 | 0.17 | 40.11 | EUR |
| S0000005 | O000002 | 2026-05-10 | CU01875 | P0049 | R10 | C04 | 9 | 27.59 | 248.32 | 150.24 | 0 | 98.07 | EUR |
| S0000006 | O000003 | 2025-03-02 | CU00767 | P0187 | R07 | C06 | 6 | 51.8 | 279.72 | 175.89 | 0.1 | 103.83 | EUR |
| S0000007 | O000003 | 2025-03-02 | CU00767 | P0103 | R07 | C06 | 8 | 13.77 | 87 | 52.37 | 0.21 | 34.64 | EUR |
| S0000008 | O000003 | 2025-03-02 | CU00767 | P0100 | R07 | C06 | 1 | 26.51 | 26.51 | 13.45 | 0 | 13.06 | EUR |
| S0000009 | O000004 | 2025-11-14 | CU01517 | P0036 | R04 | C05 | 6 | 75.86 | 455.18 | 227.47 | 0 | 227.72 | EUR |
| S0000010 | O000004 | 2025-11-14 | CU01517 | P0130 | R04 | C05 | 9 | 49.58 | 437.32 | 282.34 | 0.02 | 154.98 | EUR |