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.