Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Hands-On Dashboard Development with QlikView

You're reading from   Hands-On Dashboard Development with QlikView Practical guide to creating interactive and user-friendly business intelligence dashboards

Arrow left icon
Product type Paperback
Published in Mar 2019
Publisher Packt
ISBN-13 9781838646110
Length 156 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Abhishek Agarwal Abhishek Agarwal
Author Profile Icon Abhishek Agarwal
Abhishek Agarwal
Arrow right icon
View More author details
Toc

Creating a star schema

First, let's look at the two types of schema available for data models, namely:

  • The star schema
  • The snowflake schema

The star schema looks exactly like a star in its function. The following diagram represents a star schema:

In this schema, you have one FACT table in the middle, which contains all your measures, and all the associated tables, such as dimensions, are connected to that FACT table. The structure that they create is similar to a star, as seen in the preceding diagram.

The star schema is a preferred choice for QlikView dashboard development, because all the dimension tables are connected to the central fact table, and so, querying the data becomes very easy. If you query the data, the engine just has to reach to the required dimension table and ignore the other tables that are connected to the fact table.

The snowflake schema is more...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image