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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.