The Power of Microsoft's Power BI – a Revolution for Data Driven PPM

Tue, Sep 8, '20 / by Power Framework


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. 

Power Framework is a great tool to rapidly implement a highly personalised project database and adopt a consistent process framework. It’s the combination with Power BI that raises this solution to another level.

What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.

As a cloud service within Microsoft 365 it is instantly available and connects easily to a wide range of data sources. 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 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 connect to 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. 

Tags: Power BI

New call-to-action