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...