Cost analysis of contractors' work costs of project portfolio dashboard in MS Power BI

Contents:

1. Cost analysis of contractors' work in the project portfolio in MS Power BI
2. Customize dashboard “Cost analysis of contractors' work in project portfolio” in MS Power BI
3. Chat

Cost analysis of contractors' work in the project portfolio in MS Power BI

Based on the data of the register of certificates of completed works of the project portfolio and the register of payments to contractors, as well as the tasks of contractor projects, you can answer the following questions

• How well the payments to contractors are planned compared to the planned tasks.
• How well the plan of payments to contractors corresponds to actual payments and actually completed tasks in projects.
• To what extent the fact of payments to contractors corresponds to signed acts of completed works and completed tasks of contractors in projects.

The graph “Deviation by planned costs by periods” shows the difference between planned costs and planned payments with increasing total. The more the graph departs from the zeros of the axis, the more problems with planning the costs of contractors' tasks.

The graph “Base costs (nr). Planned costs (n/a) and Payment plan (n/a) by periods” shows the value of base costs, planned costs and payment plan by increasing total.

The “Plan” page displays information about planned costs by time periods:

• Base costs - approved costs of project tasks assigned to contracting organizations
• Planned costs - planned costs of project tasks assigned to contracting organizations
• Plan payment - sum of planned payments under the contract.
• Base costs (cml) - base costs with increasing total.
• Plan costs (cml) - planned costs with increasing total.
• Payment plan (cml) - the sum of planned payments under the contract in cumulative total.
• Deviation on planned costs - the difference between planned costs and planned payments on an accruing total. By this indicator you can evaluate the quality of planning of contractor tasks costs and payments.

On the “Fact” page you can track the work with contractors of the portfolio projects.

The graph “Deviation by actual costs by period” shows the difference between actual costs and actual payments with increasing total. The more the graph departs from the zeros of the axis, the more problems with the actual costs of contractors' tasks.

The graph “Actual Costs (cml), Actual Costs (cml) and Actual Payments (cml) by Period” shows the value of actual costs of project tasks, actual payments and the sum of acts in cumulative total.

The “Actual” page displays information about planned costs by time periods:

• Project actual costs - planned costs of project tasks assigned to contracting organizations.
• Actual payment - sum of planned payments under the contract.
• Costs of acts - sum of costs according to acts of completed works.
• Project actual costs (cml) - basic costs with increasing total.
• Actual payment (cml) - the sum of planned payments under the contract.
• Costs of acts (cml) - sum of costs under the acts of completed works on a growing total.

Effective evaluation of actual data is possible with quality planning and tracking of contractors' tasks. On the “Acts” page you can compare the facts of pro

By comparing the cumulative cost figures on the "Variance" page, you can find problems with planning and tracking project contract costs.

The graph shows deviations for planned and actual project costs, as well as deviations for actual payments and costs by acts. For completed periods the deviation should be zero. For future periods the deviation should not be greater than the limit values.

All cost parameters are displayed on the graph “Incremental costs”.

The table displays information about the costs accruing by time periods:

• Project base costs (coml) - the sum of approved costs in the projects on an accrual basis.
• Project costs (coml) - sum of planned costs in projects cumulatively.
• Project actual costs (coml) - the sum of actual costs in projects on an accrual basis.
• Plan payments (coml) - sum of planned payments under the contract on an accrual basis.
• Actual payments (coml) - the sum of actual payments under the contract on an accrual basis.
• Costs of the act (coml) - the sum of work performed under the contract on an accrual basis.
• Cost variance (project plan & fact) - the difference between the costs of planned payments and the costs of acts of work performed under the contract on an accrual basis. By this indicator you can evaluate the quality of planning of contract payments.
• Cost variance (peyments & acts) - the difference between the costs of actual payments and the costs of certificates of completed works on an accrual basis.

Customize dashboard “Cost analysis of contractors' work in project portfolio” in MS Power BI

How to get the dashboard “Cost analysis of contractors' work in project portfolio” in MS Power BI

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

How to customize the dashboard in MS Power BI

• Download MS Power BI and log in with your account.
• Open the report in MS Power BI.
• Go to “Data” menu, “Get Data” item and sub-item “Launch Power Query Editor”.
• To do this, click on the “Path” parameter and replace the line “https://studyoberemokii.sharepoint.com/sites/en/” with your server address.
• Go to the “Home” menu item and the “Refresh Preview” sub-item.
• Refine the portfolios and portfolio types in the “Projects” table and the resource groups in the “Resources” table.
• In the same “Home” menu item, click the “Close & Load” button.