MBN News | The Independent Business Blogging Community

MBN News: Business Intelligence | Databases | BigData

MBN International: English Flag Bulgarian Flag

29 Members | ~1,500 Unique Visitors with ~3,500 Visits Last Month | Last Update: 19 Sep 2018 | Google PageRank 5 (PR5)

MBN Most Popular

MBN Latest

Now Blogging » Business Intelligence (BI)

Business Intelligence Dictionary: Facts And Dimensions Explained | NSBI

|
<a href='http://morningbiznews.com/en/search/fact'>fact</a>, <a href='http://morningbiznews.com/en/search/measure'>measure</a>, <a href='http://morningbiznews.com/en/search/dimension'>dimension</a>, <a href='http://morningbiznews.com/en/search/attribute'>attribute</a>, <a href='http://morningbiznews.com/en/search/conformed+dimensions'>conformed dimensions</a>, <a href='http://morningbiznews.com/en/search/additive+measure'>additive measure</a>, <a href='http://morningbiznews.com/en/search/slowly+changing+dimensions'>slowly changing dimensions</a>, <a href='http://morningbiznews.com/en/search/SCD'>SCD</a>, <a href='http://morningbiznews.com/en/search/nsbi-dict'>nsbi-dict</a>

Facts and Dimensions are a special type of fields, that are introduced during Data Warehouse architecture and design.

Facts | Definition

NSBI Dictionary defines Facts as numeric Measures of a business process.

Dimensions | Definition

NSBI Dictionary defines Dimensions as Attributes used to describe measures and slice them from different perspectives.

NSBI Tutorials aim to make Business Intelligence (BI) and Data Warehousing (DWH) attractive to non-technical people as well as to those who are now entering the field and are excited by the numerous ways data is changing our world. NSBI Tutorials are written and delivered by Nick Shopov, (BI Software Developer & DWH Consultant).

Facts and Dimensions | Example

"SalesRevenue" is a typical fact used to describe the revenue from a sale.

This single sale, however, may be sliced from a different angle according to the business needs., e.g. "Employee" that made the sale, "Time" when the sale was recorded, "Location" where it happened, etc. All these are attributes, that describe the fact - Dimensions.

Dimensions | Classification

Conformed Dimensions

There is a special kind of Dimensions, called Conformed Dimensions. NSBI Dictionary defines Conformed dimensions as dimensions that have consistent meaning in all fact tables and all source databases. A typical example for a conformed dimension is "Time". Usually time has the same meaning everywhere.

Note: In some more complicated scenarios this may not be the case. Consider days of the week. In North America you may see Sunday as the first day of the week, while Europe considers Monday as Day 1. These cases must be handled separately. 

Slowly Changing Dimensions

Slowly changing dimensions is a term introduced by Kimball Group and aims to describe dimensions that are expected to change over time. The Data Warehouse will have to handle such occasions. We will have a separate article that goes into details - click here

Facts Classification - Additive Measures

Facts may also be further classified considering their "Additiveness" factor. Facts may be:

  • Additive - measures that can be added across all dimensions (e.g. SalesRevenue)
  • Non-Additive - measure which addition won't make any business sales (e.g. adding profit % margins)
  • Semi Additive - measured that can be added across some dimensions (e.g. Balance Sheet Capital is consolidated monthly - it is additive across different organizations, but non-additive by time since the sum of two consecutive months won't give any reasonable result for month 3).