We would like to use Google Analytics to understand how people use Insyt. It sets cookies and only runs if you accept. Rejecting changes nothing else on the site.
A table in a star schema that describes the things involved in events, such as customers, products or dates, and is used to filter and group the facts.
Example
In Raket Parts B.V. data, customers is a dimension table: 436 rows, one per customer, with customer_ref as the key and segment and country to filter and group by. Grouping invoice lines by segment gives revenue per segment.
Raket Parts B.V. is a fictional company created for Insyt.
Why it matters
Clean dimensions give consistent labels and groupings across every report built on the model.
Where it is used
Data warehouses and BI models. Used by BI developers, data engineers and data analysts.
For your role
Choose your role to see what this term means in your work.
