To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R03_Project that contains the following data:
|
ID |
Project |
Phase |
Name |
Scheduled_Work |
Start_Date |
Finish_Date |
% Complete |
Earned Value |
Actual Cost |
|
3 |
The Project |
Phase 1 |
Task 1 |
24 |
1/13/2020 |
1/13/2020 |
1 |
2,040 |
2,040 |
|
4 |
The Project |
Phase 1 |
Task 2 |
160 |
1/14/2020 |
1/27/2020 |
1 |
14,400 |
20,160 |
|
5 |
The Project |
Phase 1 |
Task 3 |
40 |
1/28/2020 |
2/3/2020 |
1 |
3,400 |
2,720 |
|
7 |
The Project |
Phase 2 |
Task 4 |
240 |
2/4/2020 |
2/24/2020 |
.75 |
16,200 |
12,960 |
|
8 |
The Project |
Phase 2 |
Task 5 |
200 |
2/25/2020 |
3/30/2020 |
.5 |
9,500 |
12,920 |
|
9 |
The Project |
Phase 2 |
Task 6 |
160 |
3/31/2020 |
4/27/2020 |
.25 |
3,400 |
1,360 |
|
11 |
The Project |
Phase 3 |
Task 7 |
120 |
4/28/2020 |
5/4/2020 |
0 |
0 |
0 |
|
12 |
The Project |
Phase 3 |
Task 8 |
240 |
5/5/2020 |
5/25/2020 |
0 |
0 |
0 |
|
13 |
The Project |
Phase 3 |
Task 9 |
80 |
5/26/2020 |
6/8/2020 |
0 |
0 |
0 |
- Create a table called R06_Calendar using the following formula:
R06_Calendar = CALENDAR(DATE(2020,1,1),DATE(2020,6,30))
The R06_Project table represents the project plan. This project plan has three phases and nine tasks. The Scheduled_Work column in the R06_Project table provides the number of hours each task is expected to take to complete. The Earned Value and Actual Cost columns are necessary inputs to create a schedule variance. To learn how to calculate Earned Value and Actual Cost, refer to the Estimating earned value and Achieving actual cost recipes in Chapter 8, Processing Project Performance.