Summary
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 ...
Get QlikView Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
