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.

The table contains the following fields:

• Year
• Month
• %Airline ID
• %Unique Carrier Code
• Unique Carrier
• Carrier Code
• Carrier Name
• %Carrier Group ID
• # FullTime Employees
• # PartTime Employees
• # Equivalent FTEs
• # Total Employees
• Period
• Month (#)

As you can see, all...