How the application was developed

The data model for the Human Capital Management application looks similar to what is shown in the following diagram:

How the application was developed

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, ...

Get Learning Qlik Sense® The Official Guide - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.