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

Dimensions

We previously mentioned that facts and dimensions are essential pieces of any star schema. Dimensions, as opposed to facts, contain descriptive data that helps give context to the fact values.

In general, a fact is composed of foreign key fields and measure fields. On the other hand, a dimension in its simplest form will have a primary key and descriptive fields.

Think of dimensions as things that describe your business. Examples of this could be Products, Location or Geography, Customers, Organization, and so on.

Generally speaking, star schema data models have dimensions in common. A calendar is one of the dimensions that is probably present in any model. It helps to give more meaning to the date field by adding extra attributes ...

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