The data model for the Human Capital Management application looks like what is shown in the following screenshot:
There are six tables in this application:
Employees: This is the main table, which has one record per employee and month. It contains all of the relevant information about the employee such as country, position, salary, and so on. It would probably be possible to normalize this table into one table containing employee information that doesn't change over time and another table with the time-dependent information.
However, since the Qlik® engine analyzes the data just as efficiently either way, we don't ...