3

I have the following database schema from which I want to create DW with the needed dimensions for the following KPIs:

  • Number of personel by training (formations)
  • HR turnover
  • Absences by category

Employee database

What I'm trying to figure out is which dimensions should provide the contextual information for the facts table.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Baha
  • 56
  • 7
  • the schema provided contains french words while the question is in english. Can you describe what are the tables (in english) and relations found in the database – Hadi Mar 15 '19 at 23:05
  • 1
    Personnel (Employee), Formation(Training), Conge (Vacation - Days off), and each category is for a department. – Baha Mar 15 '19 at 23:11
  • How HR turnover are detected from the data? – Hadi Mar 15 '19 at 23:34
  • 1
    When one employee changes from one department(category) to another, that's considered as a turnover. (Internal hr turnover) – Baha Mar 15 '19 at 23:37
  • 1
    @Baha you've got the right answer, why not accepting it?? – Yahfoufi Mar 18 '19 at 14:35

1 Answers1

2

The following suggestions are based on your comments:

  1. To extract Absences by category you need to specify CATEGORIE and ABSENCE tables as dimensions.
  2. To extract Number of personnel by training (formations) you need to specify FORMATION table as dimension
  3. To extract the HR turnovers you need to specify CATEGORIE table as dimension
Hadi
  • 36,233
  • 13
  • 65
  • 124