Chapter 4. Data Modeling

Up until now, we've seen the HighCloud Airlines team becoming familiar with QlikView and its powerful analytic capabilities and data association engine. The time has come to establish how their first production application will be developed, starting with its very core: the Data Model.

We've constructed a data model in the preceding chapters using pre-processed tables, so it was an easy task. In this chapter however, we will dig into the hows and whys of data model design in QlikView, exploring different scenarios and learning about the inner workings of QlikView's associative engine. This enables us to take the most advantage of the dataset we will be analyzing.

In this chapter, you will learn about:

• Which type of data model is best suited for QlikView

• The different "rules" that need to be followed when designing data models for a QlikView document

• How to best take advantage of the associative data model to make your documents highly dynamic

• How to work with tables and...