The Power BI model

The analysis in this chapter is based on the model below.

You can download the Power BI model for this chapter, 2.8 Personnel Planning.pbix, from this link: https://github.com/PacktPublishing/Extreme-DAX/tree/main/Chapter2.8.

Figure 2.8.1: Power BI model diagram for personnel planning

The model contains two main fact tables:

• fProjectSales contains projects sold. The primary information in the table is the project type, which is the main characteristic of a project. The table also contains a Number column, which denotes the size of the project in terms of the project type. For example, a project can have type A and number 3, meaning that the project is comparable to three typical type A projects. The table contains the project budget as well.
• fFTE is a fact table with information about project types. It is an atypical fact table, as it does not contain any data that is strictly time-related. Instead, for each project...