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.
The central table in a star schema that records events or measurements, such as sales or orders, with numbers to add up and keys that link to dimension tables.
Example
In Raket Parts B.V. data, customer_invoice_lines is a fact table: 20,653 rows, one per invoice line (its grain), with qty and line_amount to add up, and product_ref and invoice_ref linking to products and invoices.
Raket Parts B.V. is a fictional company created for Insyt.
For your role
Choose your role to see what this term means in your work.
Why it matters
It holds the numbers most reports total, so its grain decides what can and cannot be counted correctly.
Where it is used
Data warehouses and BI models. Used by BI developers, data engineers and data analysts.
