Using Power BI with BrightWork Project Reports
BrightWork offers incredible reporting capabilities across SharePoint site collections giving you visibility, clarity, and control of your projects.
You may want to incorporate some of that information into business dashboards; combine project data with operational data in real-time from various sources e.g. project data from SharePoint, vendor costs from SAP, accounts from QuickBooks, and so on.
There are lots of tools emerging over the past few years to help with data mining and data extraction. An increasingly popular tool is Power BI from Microsoft.
Power BI integrates well with many of Microsoft’s technologies and applications, as well as 3rd party products that are continuously growing.
Power BI can query the three BrightWork Cache lists to run reports against the entire site collection. The three Cache lists are Project, Status Reports, and Work cache. Any fields that are mapped into your cache lists can be reported on.
BrightWork and Power BI
This is where BrightWork can really stand out! You can create a dashboard to query to the Project Cache and pull metrics across the organization. Imagine a dashboard on Power BI that pulls in all your Planned, Actual, and Remaining costs for all your organizational projects that updates on a timer job that you can set how often it updates.
This would combine and report on costs from any project tracking planned, actual or remaining costs in a task list, issues list, risk list, and so on.
Remember – BrightWork has advanced SharePoint reporting features out of the box! BrightWork includes cross-project charts and reports with real-time portfolio dashboards in SharePoint as standard.
By incorporating with Power BI, the information contained within BrightWork can increase visibility and control by combining the data with other enterprise data.
Power BI and BrightWork Example
Taking an example where a project’s planned and actual costs are calculated at the level of a project and aggregated up to the project office, this information can be pulled into Power BI and included in more complex cross-enterprise reporting.
If you’d like to learn more about using BrightWork and Power BI for project reporting, take a look at the below links or contact us for more information.
- Integrate Power BI Reports into SharePoint Project Sites
- Using Project Cache and Power BI for Enterprise Reporting