Portfolio change requests analysis in MS Power BI

Contents:

1. Using portfolio change request analysis report in MS Power BI
2. Setting up the portfolio change request analysis report in MS Power BI
3. Chat

Using portfolio change requests analysis report in MS Power BI

Analysis of the registry of requests for changes to the server project portfolio in MS Power BI is a report that allows project administrators and project office analysts to analyze information on requests for changes to the project portfolio. Project teams record all requests for changes from stakeholders on the MS Project Server server. Analysis of information on change requests is carried out separately in a report in MS Power BI.

The document "Portfolio change request analysis" in MS Power BI allows you to quickly and conveniently analyze information about requests for changes to the projects of the portfolio and manage them. Project administrators record all requests for changes, and project managers in the registry of requests for projects in MS Share Point. Project office specialists evaluate the quality of work with requests for changes.

1. The project administrator enters information about incoming requests for changes in the registry.
2. The project manager, together with the project team, analyzes the incoming requests and evaluates the degree of their impact on the project deadlines and costs.
3. The project manager coordinates the analysis results with stakeholders and appoints a person responsible for making changes to the project.
4. Responsible team members make the changes assigned to them in the project documents.

Project office specialists analyze the quality of work with requests for changes.

The report uses filters:

• Project - a list of company projects for which there are requests for changes.
• Initiator - a list of initiators of changes in the project.
• Period - a filter that allows you to select changes by deadlines.
• Priority. The "Priority" filter allows you to select the highest priority change requests.
• Impact. The "Impact" filter allows you to select requests with the highest level of impact on the project.
• Status. The "Status" filter selects requests based on their status. "Current" - ​​a change request that is still awaiting processing. "Closed" - a request that has been rejected by the initiator. "Completed" - changes to the request have been made to the project.

Setting up the portfolio change requests analysis report in MS Power BI

How to get the report in MS Power BI

1. Register or log in to this site.
2. Make a payment.
3. Download the report file.

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.