Skip to Main Content
Mastering Qlik Sense
book

Mastering Qlik Sense

by Ralf Becher, Karl Pover, Jason Michaelides, Dilyana Ivanova, David Alcobero, Martin Mahler, Juan Ignacio Vitantonio
March 2018
Beginner to intermediate content levelBeginner to intermediate
514 pages
13h 11m
English
Packt Publishing
Content preview from Mastering Qlik Sense

Joins

So far, we have learned about fact tables and dimensions. We described facts as tables containing our measures and dimensions as tables containing descriptive information about our measures. However, we have described them as separate entities.

There is no data model without table linkage. The main purpose of data modeling is to create a performing set of tables -facts and dimensions- so we can join them together.

To understand this better, think of your fact as the structural bone of your model. You load this table first. You learn that fact tables have foreign keys to your dimensions. This means that your fact table is related to your dimensions through these unique identifiers. Fact tables and dimensions are linked through joins ...

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

Mastering Qlik Sense

Mastering Qlik Sense

James Cross
Solutions Architect's Handbook - Third Edition

Solutions Architect's Handbook - Third Edition

Saurabh Shrivastava, Neelanjali Srivastav

Publisher Resources

ISBN: 9781783554027Supplemental Content