Human resources data model

The HR data model is a transactional fact table with discrete events. This includes the employee-related events along with a few financial events that help us measure productivity. We record the following events in this model:

• Employee payroll

• Employee absences

• Employee training

• Employee hiring and dismissals

• General Journal (GJ) entries related to sales, costs, and expenses

Here is a representation of this model:

We combine these events into one fact table and use the same type of master calendar as in Chapter 2, Sales Perspective. The data model includes a new dimension table called Employees. Let's review the 7Ws of our HR data model.

Dimensions
7Ws	Fields	Comments
Who	Employee	This is the focus of our HR data model. We include various attributes that are related to their role in the company and general demographic information here.
When	Month, Year	This is where we include a single master calendar that describes the exact date of an event.
Where	Office...