Skip to Main Content
Hands-On Business Intelligence with Qlik Sense
book

Hands-On Business Intelligence with Qlik Sense

by Pablo Labbe, Clever Anjos, Kaushik Solanki, Jerry DiMaso
February 2019
Beginner to intermediate content levelBeginner to intermediate
442 pages
9h 38m
English
Packt Publishing
Content preview from Hands-On Business Intelligence with Qlik Sense

Dimensional modeling

The dimensional modeling technique uses facts and dimensions to build the data model. This modeling technique was developed by Ralf Kimball. Unlike ER modeling, which uses normalization to build the model, this technique uses the denormalization of data to build the model.

Facts, in this context, are tables that store the most granular transactional details. They mainly store the performance measurement metrics, which are the outcome of the business process. Fact tables are huge in size, because they store the transactional records.

For example, let's say that sales data is captured at a retail store. The fact table for such data would look like the following:

A fact table has the following characteristics:

  • It contains ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

AI-Powered Business Intelligence

AI-Powered Business Intelligence

Tobias Zwingmann
Data Management at Scale

Data Management at Scale

Piethein Strengholt

Publisher Resources

ISBN: 9781789800944Supplemental Content