Power BI Widget: KPI and Business Intelligence on Digital Workplace
A great new feature of Synigo Pulse is to share Business Intelligence KPI's with your colleagues using the brand new Power BI widget. Let us show you how to do this. Below we give some examples how the endresult could be.
In the first screenshot you see a diagram of a personal KPI about profitability. The second shows the KPI of a HRM Department, the number of active employees. The next one represents the actual sales of units per business line. The fourth screenshot is an example how the digital workplace looks like on the mobile phone. This little pie diagram gives you the distribution of sessions per type of browser of a website. Interestingly, we have Google Analytics data connected with Microsoft PowerBi.
Step 1. Good KPI
The first step in your Power BI journey for the Digital Workplace is to think about which KPI is compelling to your users. A KPI can be personal or only relevant to a group, team or department. In Synigo Pulse you can define audiences or roles for the Digital Workplace that see unique KPI's. In general a good KPI should be actionable. It must move you to do something (or do nothing).
Step 2. Make up your PowerBI data
You need to have data in Power BI. With Microsoft Power BI you can make fantastic live tiles, dashboards (overview), reports (details) and datasets (the raw data). You always start with the dataset. For example, below you see the HRM dashboard that pulls data together about the hiring process of the organization. Microsoft PowerBI lets you integrate many kind of datasets. Please learn more about Power BI here or consult an expert.
Step 3 Add the Power BI widget
In Synigo Pulse you add the Power BI widget to your portal. Go to the list of widgets and press on the three dots. You see the list of available widgets. Select Power BI widget and add it your environment.
Step 4 Configure Power BI widget
Following the tabs from left to right you fill in the following information:
Settings
Here you fill in information how the widget is displayed on your Digital Workplace.
Power BI Settings
Go to Microsoft Power BI and open your Power BI dashboard (or report). Make sure the Power BI dashboard/report/dataset is shared with the proper users. In Power BI you control this using the Workspaces (Office 365 groups). Copy/paste the URL of the Power BI dashboard and paste it in the field URL and press Apply.
Write a title that clearly describes the view of this tile/graphic. This title is shown in the toggle menu on the Digital Workplace. If needed users can toggle between different views of the Power BI dashboard/report.
Choose the desired resolution of the widget: (4:3) square or (16:9) rectangular. I choose square by default.
My Widgets listing
These fields help users to find the widget in the widget pane. This only applies in case the widget is optional.
Advanced settings
Widget key
Fill in: sn-power-bi
Personalization key
Fill in: powerBI
Source
Fill in: /api/powerbi/accesstoken
Sync
leave unchecked
Custom Properties
You don't have to add anything here.
Press save and publish
Step 5 Test and share
Always test the effectivity of the KPI on your Digital Workplace. You could do this using in a test audience and assign a portal definition to this AD group.
Enjoy, and get in touch in case you have any questions.