Heard about Power BI but not sure what it’s all about? At this year’s PMO Conference we have a full exhibition again and you can find out about all the latest PMO products and services in the break times throughout the day.
Gero Renker from Program Framework shares some insights with us about Power BI and why PMO professionals have been getting excited about it. Here’s Gero:
Why do organisations implement Project and Portfolio Management systems?
Invariably a key objective is gaining control and visibility of the project portfolio. We want to gather project information efficiently and turn it into insights to be shared with stakeholders promptly.
With many PMOs already opting for Project Online which is a great tool to rapidly implement a highly personalised project database and adopt a consistent process framework, they can now combine it with Power BI which takes Project Online to another level.
What is Power BI? This is how Microsoft explains it:
As a cloud service within Office 365 it is instantly available and connects easily to Project Online’s data sources (such as Projects, Resources, Tasks, Assignments, Risks, Issues, Timesheets and many more). Report authors use the Power BI Desktop tool to build reports and publish them to the Power BI Cloud Service – here charts and data visuals can be combined into top-level dashboards and shared with others. Users can reuse published data models to create their own reports and dashboards on the fly.
What’s so great about all this?
It works instantly – as a cloud service it spins up when you need it.
It can combine data sources from multiple applications – so you can connect to your accounting system to retrieve financials to combine with Project Online data. It can access your on-premise database by way of a gateway which is easily set up. Or how about bringing in Excel data for ultimate flexibility – easy!
It is powerful – while it is easy to use say Project Online’s standard data sources, expert BI developers can use the built-in PowerQuery for complex data extracts and transformations. The resulting data model, once published to end users, will hide this complexity and let others reuse the data easily to create their own reports.
It is easy to share – share with colleagues, external parties, embed into SharePoint or publish to the web, bundle reports into content packs, export to Excel or PowerPoint.
It is great value – to share a dashboard or view a shared one, users will need a Power BI Pro license, which comes at a cost (and there are other license models which we won’t cover here). However, if you consider the cost of traditional BI and data warehousing platforms then Power BI is amazing value.
People love it – whoever we talk to, everyone is excited about this tool. It looks beautiful and more and more organisations are selecting Power BI as their strategic BI platform.
The benefits for your project organisation are significant: Quite simply, this is the icing on the PPM solution cake. Power BI dashboards will help you measure adoption, identify projects in trouble, share project success, measure trends, and give you the insights to drive compliance and process maturity. They allow you to demonstrate the value of data to others, thus driving buy-in of those who need to supply it. Not to mention all the time saved that used to be spent manually creating and sharing reports.
Want to find out more? Talk to Gero on the Program Framework expo stand at this year’s PMO Conference 2018. Book your ticket and join 400 of your PMO peers in London on the 13th June.