The video below shows how easy it can be for users to create ad-hoc Power BI dashboards using Macess Workflow Classification data and Service Form data.
This same data can also be made available to other reporting tools such as Tableau, Qlik, or Cognos.
Typically, in order to create reports for Workflow Classification data or Service Form field data you must have an in depth knowledge of both the Macess database and T-SQL. As the video above shows, this is not the case if the necessary data preparation steps are taken.
Users are able to simply drag and drop fields from the field list on the right to build reports and dashboards.
In the screenshots below, Workflow Classification fields and Service Form fields have been exposed and organized in ways that will be familiar to any Macess user. No database or T-SQL knowledge required.
You can see on the right side in the following screenshot that Macess Service Form fields have been arranged in to their “tabs” as users are familiar with.
Power BI is an incredible reporting and dashboard solution that Microsoft has released as a competitor to tools like Tableau and Qlik. You can learn more about Power BI at their website.
We’ve created dashboards using Power BI that make it easy to visualize data from Macess Workflow and Macess Service Forms.
The video below demonstrates a Power BI dashboard built for Macess Workflow that shows production metrics. If you’d like free access to an interactive demo of this dashboard, send an email to Jason.Hendrix@HendrixCorp.com
Hendrix Corporation is a Microsoft Cloud Solution Provider and a reseller of Power BI licenses. If you don’t already have a Power BI Pro account and need one, reach out to us for a discounted subscription.