How the application was developed

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 see any great benefit in spending time structuring the data more.

  

  Preview of the Employees table

• Hierarchy: This table contains information about the manager of the employee.

• Survey: This table contains the results from an external survey made on employee satisfaction. Such surveys are usually made once in a year, so if the results from several surveys...