O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Fact (Measure) Modeling

One key and core part of your BI solution is the business facts that you choose to include. As mentioned previously, facts are also called measures. Measures are the key metrics by which you ascertain the success of your business. Some examples include daily sales amount, product sales quantity, net profit, and so on. Clearly selecting the appropriate facts is a critical consideration in your model.

An Example

If you have been thorough in the business requirements gathering phase of your BI project, modeling facts should be simple. In most cases, facts are numeric and are aggregated by summing the facts across all levels of all dimensions. There are, however, exceptions to this rule. An example of the most ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required