Chapter 8. Data Modeling Best Practices

In Chapter 4, Data Modeling, we started working with data modeling in QlikView and reviewed some guidelines to follow when designing a data model. Now that we have also reviewed how data manipulation via a script can be performed in QlikView, we are ready to expand on both topics and review some best practices to accomplish better and cleaner data model designs. We'll talk about how to overcome common modeling challenges, such as multiple fact tables, and look at various techniques for assuring that our data models are consistent and do not contain unnecessary data. Additionally, we will look at some best practices for dealing with date and time information.

We will learn how to:

• Make sure data models are consistent

• Work with complex data models and multiple fact tables

• Reduce storage requirements for a dataset

• Deal with date and time information

Let's get started!