In this blog post I'd like to show how you can use the data submitted by Hawkeye beacons to create meaningful Power BI dashboards. The emphasis being on pivoting the table data to use the beacon properties as columns.
Before you create a Nintex Hawkeye Process Lens, you need to add some beacons to the processes you want to analyse. These process beacons will log additional data and properties about the item based on what business rules were applied by the workflow. In my example, I transmit the following properties using workflow beacons:
Once my workflow is running, Nintex records all this process beacon data and allows me to create a process lens in Hawkeye and export the Power BI template to Power BI Desktop. For more information on how to do this, see Dan Stoll's blog post on Getting Started with a Nintex Hawkeye Process Intelligence Lens.
Okay, so now that the Process Lens template has been opened in Power BI, I want to start creating a dashboard. The beacon data is stored in the table called ProcessBeacons and the two columns to look at are PropertyName and PropertyValue (ActivityID is the unique identifier for the item it relates to). You can view the table by selecting the relationships icon to the left of the screen. This is what the table looks like:
Now lets look at the table data. On the left of the Power BI interface, select the data icon. It will look something like this:
Oh dear... the PropertyName field contains all the columns I want to filter on and the PropertyValue contains all the row data! What now?
How to convert the PropertyName values to columns and set the PropertyValue values as row data
If you now go back to your Power BI dashboard, you can add dashboard elements and content filters by using the column values from your new table:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.