PPM Express provides a PPM Express Power BI pack for Executives.
In this article, we will give you a general overview and some tips on how to get the most out of it.
Executive report pack contains a set of reports that provide information for the Portfolios, Programs, Projects (and their sub-entities) progress.
You can review and access the main reports by clicking on the tiles on the Home page of the report.
The amount of data presented in the reports is determined by the filter values in the ‘Filters’ panel. The task of the default filters is to select the data of those entities for which the work has not yet been completed. For example:
To review other data, you need to reset the default filters and/or apply the necessary ones.
You can restore the default set of filters using the 'Reset to default' button.
Overview
The Overview report contains the following sections: Portfolio, Programs, Projects, and Overall Key Dates.
Portfolios View
The selected portfolios are displayed in a table.
The Portfolios by Overall Status chart presents the same portfolios, broken down by Overall Status. The chart also acts as a filter for the table.
The Projects by Overall Status chart displays projects that are part of the portfolio, both directly and through programs.
The Programs by Overall Status chart displays programs that are part of the portfolio.
Programs View
It includes two charts: Programs by Overall Status and Projects by Overall Status. The Projects by Overall Status chart displays projects that are part of the selected programs.
Projects View
This section displays all projects that meet the applied conditions. Projects may be part of programs/portfolios or exist independently.
Key Dates Summary
Key Dates data of all three entities: portfolios, programs, and projects, are included in a single presentation and decomposed by periods.
There are two ways to get details for the figure of interest.
The first way is to select the required cell in the table, then click the ‘More details' button.
The result will be available on a separate page.
The second way is to set the Tooltip switch to On. This will allow the contextual tooltip to be used for each number.
To represent data about Key Dates, the hierarchy is used: Portfolio -> Programs -> Projects.
Data on Key Dates of projects that are not included in any portfolio and/or in any program are presented in specially created folders.
The filters of the filter panel affect all table rows except those located in the ‘<out of portfolio content>’ folder.
Projects Summary report
The Projects Summary report allows you to quickly find insights and filter projects or their related entities (Key Dates, Risks, Issues, Deliverables) based on specified criteria.
For example:
Statuses View
- Projects where Overall Status = On Track.
- Projects where Cost Status = Done.
- Projects where Stage = Planning and Overall Status = Critical.
Key Dates View
Late Project Key dates:
Risks View
Project risks with probability > 70%:
Issues View
Project issues of high priority:
Deliverables View
Project deliverables At Risk:
Strategic Prioritization View
At the top, the projects are sorted in descending order by Alignment Score.
At the bottom, there is a “Project Alignment to Strategic Priorities” view, where Project Priorities are presented as abbreviations.
To sort the projects in descending order by the value of a certain Project Priority, select the corresponding Strategic Priority in the table on the left.
Portfolio Details report
These reports are supposed to work with any selected portfolio.
It is possible to select the required portfolio in two ways:
- using the filter panel
- by using the drill-through option from another report
Report data is grouped by tabs.
Project Details report
The Project Details report contains the following tabs: Project Summary, Budget, Key Dates, Project Tasks, PPM Express Schedule, Project Iterations and Prioritization.
To review the information as required you can use the tabs located at the top of this report.
The Key Dates tab displays information in table format and is sorted by Key Date date. The table includes a Timeline column, where dates are shown graphically. A vertical green line indicates today’s date. If baseline data is provided, it will be shown as lines on the display.
The charts at the top of the page display a Key Date summary. Both the bar charts and card charts are interactive.
The Project Iterations tab is presented in a table. The set of card visuals not only displays the Iteration State summary but also filters the table when you click on a card.
You can view information about iteration tasks in one of the following ways:
- Expand the “plus” icon next to the iteration name.
- Navigate to the Iteration Tasks report, where detailed task information is fully presented.
The Tasks Summary data is displayed using the charts.
The charts can filter each other as well as the iteration table. However, the table filtering applies only to iteration tasks. To see the filtered results in the table, the task level in the table hierarchy must be expanded.
The Tasks tab shows the information on the tasks from external systems and PPM Express (according to the filters selected). The Source Type field shows the list of fields specific to a particular system.
The column set can be selected. The “ALL” option displays all available OOB task fields.
The PPM Express Schedule tab gives information on the internal PPM Express tasks.
The goal of this report is to get information about the state of progress of a certain set of tasks and to evaluate it by comparing the value of the current progress with the planned one.
The 'Filters' panel is used to outline the scope of tasks to be analyzed. Gauge chart and Combo chart visualize progress if the corresponding project is selected on the filters panel. If no project is selected or several projects are selected, then visualization of progress by charts in this case is possible only if the same progress calculation rule is set for all projects in scope. The progress calculation rule that is valid for the selected project is displayed in the upper left corner of the report.
The gauge chart represents a high-level visualization of progress with the following metrics available:
- Schedule Progress
- Planned Schedule Progress
- Variance
Schedule Progress metric displays the same progress value that can be seen for that project in the PPM Express application in the Details section (if only the Project Name filter is applied to the report). The logic for calculating this metric in the report is the same as the calculation logic in the PPM Express application.
Planned Schedule Progress is a planned progress value of the selected set of PPM Express tasks for the current date (today). Values of this metric are calculated on the report side. There is no such metric in the PPM Express application.
Variance is calculated as the difference between Planned Schedule Progress to Schedule Progress.
The metrics described above are not static. The value of these metrics is dynamically recalculated when the filters are applied to the report. For example, applying additional filters, such as Resource Name or Task Status, will narrow down the report's scope of tasks, and the metrics will be recalculated.
The combo chart also offers high-level progress visualization, where Planned Schedule Progress is represented as an S-curve and Schedule Progress is represented as a column.
This chart displays the same metric values as the adjoining gauge visual. Both visuals show the progress of the same set of tasks, including the tasks with dates and tasks without them. Since the progress of tasks without dates cannot be associated with any particular time period, the progress of such tasks is added to the progress of each period. Thus, the Planned Scheduled Progress metric for each period is made up of two parts: the progress of tasks with dates for the period, plus the progress of all tasks without dates.
The Schedule Progress value presented as a column is calculated for the current date (as of today), and the Planned Schedule Progress value is calculated and displayed for the last date of the current period. To get the Planned Schedule Progress metric value calculated for the current date (as of today), you can use the tooltip.
The table at the bottom of the report provides details on the progress of the schedule level. The Planned Schedule Progress column displays the calculated schedule progress value as of the current date (today). The table also shows the number of columns involved in the calculation of the Planned Schedule Progress metric.
The Prioritization report tab shows how the report is aligned to Strategic Priorities. Also, it graphically correlates the alignment score of the project with the alignment score of other projects of the tenant or projects included in the portfolio/programs of the project under consideration.
1. The Alignment Score of the selected project:
2. The table below shows whether a project is fully aligned to a Strategic Priority or not:
Alignment details are shown in the tooltip for each Strategic Priority.
3. Project Alignment Status table includes the following rows:
- 'Entity Type' - the entities where the selected project belongs: Tenant, Portfolio and/or Program.
- 'Entity Name' – the names of the portfolios/programs, to which this project is added.
- 'Total Projects' – the number of projects within the entity.
- 'Project Alignment Rank' – the project number in the row of other projects The number of the project in the list of projects of a particular entity. The projects in this row are sorted by Alignment Score in descending order.
4. Column chart 'Projects by Alignment Score'.
Columns:
- The height of the column is the number of projects corresponding to the X-axis Alignment Score.
- The set of projects is determined by the selected line of the table “Project Alignment Status”. If there is no highlighted line in the table, then the set of projects corresponds to the set of tenant projects.
Vertical lines:
- Median Alignment Score.
- Current Project Alignment Score.
The position of the “Current Project Alignment Score” line relative to the “Median Alignment Score” line allows you to assess how the values of the Alignment Score metric of the selected project and other projects under consideration correlate.
The Budget tab displays the project's budget details.
By default, the data is limited to the current year.
This filter affects all metrics except Allocated Budget, which is not time-phased. Comparisons with this metric remain accurate only without a date filter.
Programs Details report
The Program Details report works very similarly to the Portfolio Details one.
Project RAID report
This report is an extension of the Project Details report, offering the following views: Risks, Issues, Action Items, Change Requests, Deliverables, and Dependencies. The structure of the views is similar: a table at the bottom and summary charts at the top.
The Dependencies report is more specific than the others. It offers three views: List, Timeline, and Diagram. The view switcher is located in the upper right corner.
The Dependencies report is also part of the specialized PPM Express RAID+ Registry report pack. You can explore its functionality by following this link: https://help.ppm.express/raid-registry-report-pack/1976992-ppm-express-raid-registry-report-pack#section-1.
Financials reports
There are three financial reports available:
- 'Project Financials'
- 'Portfolio Financials'
- 'Program Financials'