How the application was developed
The data model for the Human Capital Management application looks similar to what is shown in the following diagram:
There are six tables in this application:
Employees: This is the main table, which has one record per employee and month. It contains all the relevant information about the employee such as country, position, salary, and so on. It would probably be a cleaner data model if this table were split into one table containing employee information that doesn't change over time and another table with the time-dependent information.
However, since the QIX engine analyzes the data just as efficiently either way, ...