Introduction and Configuration
In the Power Framework App, the Project Modelling module is enhanced by ‘Project Modelling’ report, which is live-connected to the main semantic model: ‘Dataset PF w Modelling’. This dataset aggregates modelling information through the dataflow: ‘Modelling’ which is sourced from both Dataverse and SQL service via OData.
To configure, create a dataflow on the Power BI Service via OData. Use credentials and Azure Service API in Power Framework and Licensing App and connect to it from the ‘Dataset PF w Modelling’ by updating parameters WorkspaceID and DataflowID accordingly. Additionally, modify CDS URL and the PowerAppID.
Reports Details
The report comprises several sections and dashboards:
Project Modelling Overview:
- Business Value Details
- Financial Investment Details
- Resource Demand Details
- Risk Details
Modelling: Comparative Analysis of Two Model:
- Overview
- Details
- Data
- Investment: Multi Measure for Multi Model Display
- Investment: Multi-Model One Measure Display
- Resources: Multi Measure for Multi Model Display
- Resources: Multi-Model One Measure Display
Project Modelling Overview
This report provides a summary of the general Modelling data, including calculations for:
- Finished projects in their original and modelled states.
- Delays in days
- Differences between the original and modelled data.
Note that the differences in Investment, Demand, Utilisation are only meaningful when viewed at a time-phased level (not on a general level).
This page allows you to drill down into one specific model to access Model details.
Business Value Details
This report shows the total Project count, finished Project count, total delay days, and offers insights into finished projects and delay days at the Portfolio, Strategy, and Time-phased levels, as well as project-level details inside the model.
Financial Investment Details
This section displays the comparison between Investment in the Model and the Original across Portfolio, Strategy, Budget Category, Budget Category Type, and Time-phased levels, along with detailed Project information. It's important to note that the Investment Model matches Investment Original until filtered by a time-phased visualization.
Resource Demand Details
This report provides the comparison between Resource Demand in the Model and the Original across Project, Portfolio, Strategy, Role, Team member and Time-phased levels. It also covers Utilization on Role, Team Member, and Time-phased levels, as well as Capacity data at the Model and Time-phased levels.
Risk Details
This page reflects Risk Scores at Project level and this information can also be viewed at Portfolio, Strategy, and Time -phased level.
Modelling: Comparative Analysis of Two Models
This report allows you to conduct a comprehensive comparison of two models. It consists of three bookmarks.
Overview
This page summarizes the key metrics for each model, including the Number of Projects, Completed Projects, Investment, Demand, Utilization, and Delay Days. Additionally, two graphical representations are provided, showing Investment by Year and Demand by Year.
Details
Within this section, data can be explored further, allowing you to analyse Investment, Demand, and Utilization metrics across various dimensions such as Portfolio, Strategy, Role, Team Member, and Time-Phased breakdowns.
Data
This bookmark provides an overview of the main metrics detailed by project.
Investment: Multi Measure for Multi Model Display
This page provides exploration of a variety of investment metrics (Budget, Forecast, Investment) across different models, each presented through distinct graphical representations. Additionally, it shows the supporting tables that provide detailed project-level information for each selected model.
Investment: Multi-Model One Measure Display
This page provides comparing of a single investment metric across different models, all displayed on the same graph. Further exploration of this metric by project or budget category type is available through additional graphics. Additionally, a supporting table is provided to offer detailed project-level information for each selected model.
Resources: Multi Measure for Multi Model Display
This report allows you to explore a variety of Resource Demand metrics (Demand, Utilisation, Capacity Remaining) across different models, each presented through distinct graphical representations. Additionally, a supporting table is available to provide detailed project-level information for each selected model.
Resources: Multi-Model One Measure Display
This page offers the opportunity to compare a single Resource Demand metric across different models, all displayed on the same graph. Further exploration of this metric can be achieved by examining Role or Team Member breakdowns through additional graphics. Additionally, a supporting table is provided to offer detailed information on Role and Team Member levels for each selected model.