Power BI

(Work in progress)

Overview

Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Note that Power BI does not have a built-in database, rather it connects to many different data sources (files, databases, etc). For a full list of available data sources, see Power BI data sources.

OpenFn has experience setting up databases structured in a way that Power BI can pull from.

Integration Use Cases

An iNGO uses CommCare, Kobo Toolbox and Survey CTO for different maternal health projects in several different geographies. This iNGO would like to use a business intelligence tool, like Power BI, to create data visualisations for it's projects' key indicators. To accomplish this, the iNGO uses OpenFn to take the survey data from CommCare, Kobo Toolbox and Survey CTO and then create a structured database from it using MySQL. Once the structured database is established, OpenFn assists the iNGO with connecting this data to Power BI.

Refer to the diagram below for a visualization of the data flow cited in the above use case.