Chapter 4. Data Modeling Challenges

In creating a data model, you will come across challenges in terms of different formats of data, loading multiple fact tables, and performance issues. There are techniques to resolve these challenges.

In this chapter we shall:

  • Learn about loading a Crosstable
  • Learn about the Autonumber function
  • Learn about creating a link table to load multiple fact tables
  • Learn about variable overview
  • Learn about creating a master calendar
  • Handle SCD using IntervalMatch
  • Store and read data from QVDs (QlikView data files)
  • Learn about optimized load
  • Discuss best practices for data modeling

Crosstable essentials

In your downloaded folder, look at EmployeeSalesTarget.xls. This file is located in C:\QlikViewEssentials\Data.

Some of the properties ...

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.