Databases Reference
In-Depth Information
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 of the dimension fields are already part of the Airline Operations
data model and the only new fields are those related to the actual measurements
of employment.
