Facts and Measures
Measures are useful numeric values originating from business transactions, which are used for analysis through aggregation later on.
They are also known as facts, so fact tables are basically collections of keys and measures.
Depending on the type, some facts are more useful for aggregation and analysis than others.
So how can you identify the type of measure you are collecting?
Here’s a quick general guide for confirming what type of fact you’re working with:
Questions to practice:
What are measures used for?
What are the different types of measures?
Can you think of any examples for each of the types?