Implementing Data Modeling Techniques

In this chapter, we are going to focus on the basic concept of data modeling. We will look at the various types of the data modeling techniques and learn which technique is best suited for the Qlik Sense dashboards. We will also learn about the methods for linking data with each other using joins and concatenation. We will throw some light on how to we filter unwanted data while loading the data.

 We will learn about the Qlik Data format, QlikView Data (QVD), and why it should be used in the data modeling. We will also look at how to link multiple tables with different granularity (granularity being the level of data that is stored in the tables) of data using the link table. 

We will see how to handle the situation in which multiple dates are involved in the data model and situations when you want to calculate the accumulated values and rolling averages. Finally, we will look at the script optimization techniques to improve the script loading time.

This chapter will cover the following are the topics:

• An overview of data modeling
• Joining
• Concatenation
• Filtering
• Use of QVDs
• Link table
• Canonical dates
• As-Of Table
• Script optimization