Analysis of the portfolio cash flows in MS Power BI

Contents:

1. Analysis of portfolio cash flow from MS Project Server in MS Power BI
2. Setting up the "Portfolio cash flow from MS Project Server" dashboard in MS Power BI
3. Chat

Analysis of portfolio cash flow in MS Power BI

Based on cash flow data, general information on portfolio costs is calculated. The calculation presents planned and actual information on portfolio receipts and costs. The profit and ROI of the project are calculated, as well as the deviation for each parameter.

Using information about payments to portfolio, we can conduct an analysis and identify cash gaps or inefficient use of funds in portfolio accounts.

The Analysis page presents a cash flow model with grouping by items of both receipts and payments of the portfolio. The table presents the data:

• Cash receipt plan
• Cash receipt plan cumulative total
• Fact of cash receipt
• Fact of cash receipt cumulative total
• Payment plan
• Payment plan cumulative total
• Fact of payments
• Fact of payments cumulative total

The cash flow chart shows the overall level of cash inflows and outflows in a portfolio.

In a detailed analysis of the portfolio's funds, all planned and actual values ​​of payments and expenses in the portfolio are displayed in one model.

This model shows not only the total amounts, but also the names of the counter parties, contracts, dates and descriptions of payments.

Setting up the "Portfolio cash flow in MS Project Server" dashboard in MS Power BI

How to get the dashboard 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 the 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 (take into account the bit depth 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.