Loading...
Quick Links

Out-of-the-Box Dashboards and Reports for Microsoft PPM

Microsoft just announced an updated Power BI Content Pack for Microsoft PPM, which allows organizations to get started quickly with dashboards and reports without requiring any customizations in Project Online.  This content pack utilizes the latest visualizations and features available in Power BI and contains 13 pages supporting portfolio, resource, and project reporting:

  • Portfolio reporting – focuses on viewing key data across the entire portfolio of projects, including which projects are in the governance phases, by owner, department, project type, and key performance indicators. It also includes a portfolio timeline, roll up of costs, summary of key milestones, as well as risks and issues across the entire portfolio.
  • Resource reporting – focuses on understanding resource availability across the organization, including the ability to zoom in on specific departments and groups. It also allows resource managers to quickly drill down into the data to see which projects their staff is working on and what the detailed work is.  Predictive analytics reporting shows forecasted demand based on historical information.
  • Project reporting – provides an automated project-level status report that summarizes key data on the project and highlights variances for cost, work, and the schedule. It summarizes all completed milestones and upcoming milestones, and provides links to the project schedule as well as the project site.

Dive deeper into this new release by viewing Ken and Raphael’s training webinar on-demand!


This content pack update will help you take your organization’s Project and Portfolio Management reporting to powerful new levels. It will support everyone in your organization, from highly visual executive dashboards, to resource utilization reporting for resource managers, down to detailed project reports for business sponsors and project managers.

Microsoft PPM Public Power BI Content Pack – Report details

1. Portfolio Dashboard

The Portfolio Dashboard provides an executive level dashboard which allows all levels of management to view the portfolio of projects on a single page.

The dashboard provides links to the SharePoint collaboration site for each project.

 

 

2. Portfolio Timeline

The Portfolio Timeline provides a visual overview of the projects in the portfolio. This report is often used to provide senior management visibility into the active projects in an organization.

 

 

 

3. Portfolio Costs

The Portfolio Costs page summarizes the project costs into a single dashboard to allow management to review project financials. The cost variance column allows management to focus on exceptions.

Users can drill into the data in the table to see where the costs are coming from.

 

4. Portfolio Milestones

The Portfolio Milestones report is a key management report, as it summarizes the milestones onto a single page with visibility into accomplishments (completed in the last 30 days) and near future goals (upcoming in the next 30 days).

From this report, users can click through to the detailed project schedule in Project Online.

 

5. Portfolio Risks

Management visibility of project risks is vital, as it surfaces the risks with the largest exposure to ensure management remains engaged and prepared to deal with the risks, should they begin to impact the projects.

Users can click through to the detailed risks on the project sites.

 

 

6. Portfolio Issues

As issues are immediate project challenges, it is important that they are highly visible to allow management to understand the nature and impact of the most critical issues. Project issues having senior management visibility helps ensure that all issues are resolved before they impact the project’s success factors.

Users can click through to the detailed issues on the project sites.

 

7. Resource Availability

The Resource Availability report allows resource managers to quickly and easily determine which resources are overallocated and need to have their workload reduced, as well as which resources have capacity to take on additional work.

 

 

 

8. Resource Overview

The Resource Overview report provides insights into the enterprise resource pool to better understand which resources are associated with the groups, departments, or RBS.

 

 

 

 

9. Resource Assignments

The Resource Assignments report shows which projects the team members are assigned to.

Users can drill into the data in the table to see the detailed assignments on these projects.

 

 

 

10. Resource Details

The Resource Details report shows detailed information for a single team member, including where they are in the organization, their all-up availability picture, assignment metrics, and which projects they are assigned to.

 

 

 

11. Resource Demand Forecast

The Resource Demand Forecast report uses historical data to predict future demand.  The predictive analytics functionality provides upper and lower bounds.

 

 

 

 

12. Project Status

The Project Status report shows the detailed status for a single project, including key data about the project itself, cost information, variances, completed and upcoming milestones and percent complete, as well as links to the project site and schedule.

 

 

 

13. Project Risks and Issues

The Project Risks & Issues report pulls together all the risks and issues from a single project. The risk matrix allows users to quickly spot those risks that are high impact and probability.  The issues charts allow for quick filtering to keep track of project issues.

 

 

 


Related Content

Webinars (watch for free now!):
Report Basics: Build an Agile Kanban Board in Microsoft Project
It’s All About… Reports!

Articles:
Create a Monthly Cash Flow Report in Microsoft Project 2013
Creating Milestone Reports in Microsoft Project
Creating a Custom Report in Project 2013: This Week’s Tasks


Share This Post
15 Comments
  1. Hi! These look great! I notice the article mentions Project Online and I’m curious if this content pack will also work with on-premise Project Server.

    Reply
  2. Kenneth Steiness

    Hi Kevin, the Power BI Content Pack is targeted at Project Online, but you can also deploy it against your on-premises Project Server environments as long as you use the Enterprise Gateway (or Power BI Report Server).

    Reply
  3. Given the above reply, what version of Project Server would be needed?

    Reply
  4. These look great and are exactly the type of information we are trying to extract from our project data. What level of Project Online license is required for Executives to view these reports, specifically the Portfolio views?

    Reply
  5. Kenneth Steiness

    Bruce, anyone needing to look across the entire portfolio should have a Project Online Premium subscription by Microsoft’s definitions. And, of course, they’ll need a Power BI license as well, either Power BI Pro or if your organization has Premium.

    Reply
  6. Kenneth Steiness

    Kevin, you can download the PBIT file from GitHub and use it against any Project Server version, although if you go back far enough there may be a few changes needed to the reports.

    Reply
  7. This is great! Thanks for sharing. God knows how much time I spent to get similar views manually using project and resource center exports and timesheet data! are these available for Project 2016 or 2013 as well? Does Microsoft have any guide on the source of these BI reports for e.g. where the report reads project risk and issues from? or where the resource assignments come from, timesheets or schedule?

    Reply
  8. Kenneth Steiness

    Mary, yes, you can use these with Project Server 2013/2016 provided you use the Enterprise Gateway. The source is the content database, so the risks and issues come from the SharePoint collaboration site. The assignments come from the tasks in the schedule, etc. There’s an MPUG webinar on this next week that I would you encourage you to attend to see more and get your questions answered. Also, be sure to watch the video walkthrough here: https://www.youtube.com/watch?v=pVQmco-rd5A.

    Reply
  9. Am Struggling to install the new content pack

    We couldn’t install Microsoft Project Online

    Please check that any info you entered is correct. If unsuccessful, please try again later.
    Please try again later or contact support. If you contact support, please provide these details.
    Activity ID85bcb378-52a2-4451-8972-68c959d99f32
    Request ID97c3cf53-cad6-677f-5cc6-b37f35d836d3
    Correlation ID2add2a1f-ab23-eafe-f98d-9c0a890e381b
    Status code400
    TimeWed Dec 13 2017 13:59:12 GMT+0530 (India Standard Time)
    Version13.0.3419.168
    Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net

    Learn more about solving this issue

    Reply
  10. Dear Kenneth,

    Please let me know from where I can download content pack for project server 2016 on-premise ?

    Reply
  11. Kenneth Steiness

    Hi Basim, the Power BI Content Pack is targeted at Project Online, but you can also deploy it against your on-premises Project Server environments as long as you use the Enterprise Gateway (or Power BI Report Server).

    Reply
  12. We have the content pack deployed = however having problem with the Gantt view reporting all projecst and gantt timelines – has anyone else figured out how to do this?

    Reply
  13. Hi Linda, the default Gantt view will display all projects that are published. Please ensure that you haven’t used either the slicers at the top or the timeline to filter any of your projects out. We haven’t yet experienced the issue you describe – if no filters are set, perhaps you could provide more details.

    Reply
  14. Now that I sent the previous message, I’ve noted that the default view of this page does in fact filter some projects on start date using the timeline, so if you scroll to the right, you can select the additional months in which your projects may start to include them all. 🙂

    Reply
  15. Hi
    I am new to Power BI and till now i have been able to use the Dashboards for Project Online.
    On my projects, i have used the cost fields to represent various component of costs on the project. The Odata does not bring the information of those cost fields so that i can use them to create other dashboards.
    Can anyone assist or guide me on how to achieve this?
    Many thanks.
    Navin

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

4 + 5 =

Thanks for submitting your comment!
You must be logged in to comment.