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

Fact tables

Fact tables are the heart of your star schema. They are the centerpiece. Without a fact table, you don't have a model; that's why it is very important that you get the facts right from the beginning.

Fact tables represent measurements, or metrics, within your business scope. You can have one or many fact tables, depending on your requirements. When we say fact table, you should think about measurable things, such as sales, quantities, prices, and so on. The fact table will also contain foreign keys to your dimensions.

Foreign keys within the fact table allow linking the data to the dimensions. A primary key in a dimension is a foreign key in the fact table.

A table key univocally identifies one row within a table. When there are ...

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