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?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s