Analysis of project task duration deviations in MS Power BI

Contents:

1. Using the "Project task duration variance analysis" report in MS Power BI
2. Setting up the "Project task duration variance analysis" report in MS Power BI
3. Chat

Using the "Project task duration variance analysis" report in MS Power BI

The "Project Task Duration Deviation Analysis" report in MS Power BI is used by project office employees to analyze the duration of tasks in projects of the same type. Subject matter experts are involved in the analysis process to draw conclusions on issues of improving the technology for implementing the task and minimizing the impact of risk events.

The report uses filters;

• Portfolio. The "Portfolio" filter allows you to filter by portfolios and project types.
• Responsible. The "Responsible" filter allows you to filter by departments and responsible.
• Priority. The "Priority" filter allows you to filter tasks by priority. "High" - from 1000 to 700. "Middel" - from 700 to 300. "Low" - from 300 to 0.
• Level. The "Level" filter allows you to filter first and second level tasks.

Setting up the "Project task duration variance analysis" report in MS Power BI

How to get a report:

• Register or log in to the site.
• Make a payment.
• Download the report file.

The report uses custom fields:

• Portfolio. A corporate field of the system that contains project portfolios.
• Project types. A corporate field that contains a list of project types.
• Departments. A corporate field that contains a list of company departments.
• Responsible. A corporate field that contains a list of people responsible for tasks.

How to customize a report in MS Power BI

1. Download MS Power BI from the link https://www.microsoft.com/en-us/download/details.aspx?id=58494.
2. Install MS Power BI (consider the bitness of your operating system).
3. Load MS Power BI and log in with your account.
4. Open the report in MS Power BI.
5. Go to the “Home” menu item and the “Transform data” sub-item.
6. Go through all the tables and change the server address.
7. To do this, click on the “Source” item and replace the line “https://studyoberemokii.sharepoint.com/sites/en/” with the address of your server.
8. Go to the “Home” menu item and the “Update all” sub-item.
9. In the same “Home” item, click the “Close and Apply” button.