Project request registry analysts report in MS Power BI

Contents:

1. Using the "Project request registry analysts" report in MS Power BI
2. Setting up the “Project request registry analysts” report in MS Power BI
3. Chat

Using the "Project request registry analysts" report in MS Power BI

The “Analysts of the register of requests for projects” report in MS Power BI is a tool that provides analysis of the description of the company’s strategy in future projects. This report also allows you to analyze the effectiveness of planning the company's future projects.

The “Project Request Registry Analysts” report in MS Power BI is filled out based on data from the project request registry in MS SharePoint. The Project Request Register is a user-created tool based on MS Project Server (server). Before using this report, you must create a project request register and populate it with information.

An assessment of the completion of the project request register is carried out using the analysis page. Using various filters (slices), project office specialists, together with company management, evaluate the quality of filling out the register of requests for the project.

The following sections were created in the presented report:

• Location - the location of the project or the location of a subsidiary.
• Customer – the title or name of the project customer.
• Initiator – The unit that initiated the project.
• Start – year or quarter of the start of the project.
• Group – a portfolio or sub-portfolio of projects.
• Type of projects – a specific technology for implementing the project.
• Status – status of the project request

The assessment is carried out based on an analysis of the profitability and profitability of portfolio projects. The portfolio budget is also affected by development projects that do not have income, but their results increase the profitability of external projects.

The project office, together with the company's management, analyzes the register of requests for the project in order to better plan and further implement them.

Setting up the “Project request registry analysts” report in MS Power BI

How to get the "Project request registry analysts" report in MS Power BI

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

How to customize a report in MS Power BI

1. Download MS Power BI from the link.
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.