Design challenges of data modeling
We will now provide some useful tips for dealing with more complex data models, specifically those used for dealing with multiple fact tables in a single QlikView document.
We will take a hands-on approach and we will continue using the Airline Operations document that we have previously used. The design challenge we will describe in this section will be aimed at integrating a new fact table into our data model, one that contains Airline Employment Statistics.
The Airline Employment statistics table
The table we will be adding to the data model contains monthly information about the number of employees per airline, separated by full time and part time, and also showing the equivalent total of full time employees. ...
Get QlikView 11 for Developers 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.
