In this chapter, we learned about resolving data modeling challenges by loading a Crosstable and a link table. We also learned about the importance and creation of a master calendar.
Slowly changing dimensions are also handled using the IntervalMatch
function.
Once done with all the data transformations, we loaded tables in QVDs, as reading data from QVDs is faster than reading from a database. We learned about optimized load to improve data load performance. This finished the scripting and data modeling in QlikView. This chapter also provided the best practices of data modeling that should be followed in order to create a better performing data model.
In upcoming chapters, we will learn about creating visualizations in QlikView using the data model we created so far. In the next chapter, we will learn about data visualization best practices and will create different charts and tables.