Top Power BI Features for Microsoft PPM Professionals
Microsoft Project Online is a flexible online solution for project portfolio management (PPM); and Power BI is one of those tools that definitely makes reporting easier from Project Online. Power BI Content Pack for Microsoft PPM employs the latest visualizations and features available in Power BI and contains portfolio-, resource-, and project-related reports.
Portfolio reporting – focuses primarily on viewing core data across the entire portfolio of projects. Includes portfolio timeline, summary of key milestones, roll up of costs, risks and issues. Resource reporting – helps to understand resource availability across the organization, zoom in on specific departments and teams, as well as predict demand based on the historical information. Project reporting – automatically delivers a project-level status report summarizing key project data: e.g. completed milestones, upcoming milestones, etc.
A list of Power BI advantages could be very long, but we’ll try to summarize the key aspects of why this solution is helpful for the PPM professionals.
Data is everywhere
While Project does an amazing job tracking every Project Management aspect that matters, it is not designed as an ultimate reporting tool. Project can feed information or incorporate information, but Power BI has the ability to combine that data in more different ways than Project allows. And what’s even more important, Power BI can combine the data from several different sources and present it in exactly the type of report you need. It has the ability to do that quickly and effectively without having to build temporary tables.
The bigger picture
Power BI’s capability of combining data from various sources also means that we can now get a more complete picture of what’s going on in our organization and see how different areas may affect each other. In other words, we can now view Project information about who is doing what, when, and where, and additionally, we can combine that information with the other systems to get a more comprehensive and encompassing view.
Complex data that is easy to understand
To combine different data from many systems often meant putting data into an Excel pivot table. This way, we had everything we needed to get the bigger picture, but only if spreadsheets and pivot tables are something that we enjoyed and knew how to deal with. With Power BI’s visual dashboards, we can view and understand the data we need very quickly. So, the ability of Power BI to show various combinations of complex data in visuals that are easy to comprehend is a huge advantage.
To summarize, using Power BI we can now effortlessly combine more data from more diverse sources than ever before and see our Project data in the format we need. With Power BI, Project Online users can have a better portfolio reporting, allowing for adequate decision making on different levels in the organization. And, combining Project Online data with other sources, enables a better overview over resource, financials, and portfolio health.
To help users expand portfolio visibility even more and drill down to the tiniest project detail, FluentPro has launched Power BI content pack for Microsoft Project Online with the following standard reports: Portfolio Overview, Project-related (work summary, cost summary, variances summary, governance), and Resource-related (summary, utilization, allocation analysis, governance, engagements vs. assignments, timesheet summary, timesheets governance).
Instant and beautiful dashboards are now at hand making the right information available in time for confident, informed decisions.