Analysis of portfolio cost and task cost on the server in MS Power BI

Contents:

1. Analysis of portfolio cost and task cost on the server in MS Power BI
2. Setting up the "Project task cost analysis on server" dashboard in MS Power BI
3. Chat

Analysis of portfolio cost and task cost on the server in MS Power BI

The "Main" page of the MS Power BI dashboard provides basic cost information. The list of project cost parameters includes:

• Budgets.
• Provision (difference between budgets and planned costs).
• Baseline costs.
• Planned costs.
• Cost variance (baseline from planned costs).
• Actual costs.
• Remaining costs.

The "Cumulative total" page shows a graph of project cost indicators in cumulative total. This graph is a particular implementation of the S-curve of project costs.

The "Project Costs in Cumulative Total" graph shows the following indicators in cumulative total:

• Budgets.
• Baseline costs.
• Planned costs.
• Actual costs.

The indicators are presented for the entire portfolio and for individual projects. You can also highlight different time periods.

With the graph data, the project team clarifies the reason for deviations in the indicators.

You can analyze the information about the cumulative total of project costs in detail on the “Cumulative” page.

The "Tasks cost" page displays the costs of the top-level tasks. The table shows the following cost indicators for the project tasks:

• Baseline Cost
• Planned Cost
• Cost Variance
• Actual Cost
• Remaining Cost.

Using the Cost Variance column, the project team can see the tasks that are diverging from the baseline plan and decide whether to reschedule.

Setting up the "Project task cost analysis on server" dashboard in MS Power BI

How to get the the "Project task cost analysis on server" dashboard  in MS Power BI

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

How to customize a dashboard 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” item and the "Edit parameters" sub-item .
6. To do this, click on the “Source” item and replace the line “https://studyoberemokii.sharepoint.com/sites/en/” with the address of your server.
7. Go to the “Home” menu item and the “Refresh” sub-item.