Tutorial: Get started with process mining (preview)
[This topic is pre-release documentation and is subject to change.]
This tutorial allows you to experience process mining with sample data. In this tutorial, you'll create a process, import data, and then analyze it.
If you're not able to see all of the features described below and are using your default environment, create a new environment and retry.
Download the sample data
For the process mining tutorial, download the sample event log CSV file:
The sample data in this tutorial is for illustration only and is fictitious. No real association is intended or inferred.
Create a process
Sign in to Power Automate.
Select your environment.
On the navigation pane to the left, select Process advisor.
In the Create new process section, select Start here.
In the Create a new process screen, enter a process name, and then select Data (preview).
(Optional) Enter a description for your process.
In the Choose a data source screen, select Text/CSV.
Under the Connection settings heading, select Upload file (Preview).
Find and select SampleData_AP_Refunds_Financial_EventLog.csv, which you downloaded previously.
When you see the power query, which allows you to transform your data, select Next.
Match the Attribute Name from sample data to the Attribute Type as appropriate. In this sample, the data attributes you’ll change are InvoiceValue, Resource, StartTimestamp, EndTimestamp, CaseId, and ActivityName.
When you're finished, the attribute mapping should look like the following screenshot.
Select Save and analyze. The analysis may take a few minutes to run.
When the analysis process is complete, you’ll see a process map and a dashboard with other insights about your process. On the dashboard, you can view many metrics that will help you analyze your process. To learn how to analyze the process map and metrics, go to Visualize and gain insights from processes in process advisor.
Analyze a process
Let’s take the analysis of our process beyond KPIs. We'll use the minit desktop application, where you can edit and analyze your processes created in process advisor.
On the process advisor home page, download the minit desktop application.
On the top right of the Process hub screen, select the environment.
Search for the process that you created on process advisor (Hello World).
Select Default to display the default view.
You’re ready to use the advanced capabilities of the minit desktop application in process advisor.
In the dropdown menu for Frequency, select Case count
The following process displays.
In the Customize panel, select the clock icon, and then select Mean duration from the dropdown menu.
Notice that the Refund with special voucher step has a long mean duration compared to other steps.
Select the finance icon, and then select Mean from the dropdown menu.
Notice that the same Refund With Special Voucher step involves only $656.31 in invoice value, which is less than half of most of the other steps.
This step might be a good candidate for extra investigation, so select the step.
In the Customization panel, select Filter > Attributes.
Compare paths with different views
We want to compare the paths that have this Refund With Special Voucher step with the paths that don't have this step, but instead have another step called Refund With Standard Voucher. Let's filter for paths that have Refund With Special Voucher and not Refund With Standard Voucher. Let's also filter for paths with Refund With Standard Voucher and without Refund With Special Voucher.
Create the 'Refund With Special Voucher' view
On the filter page, ensure Refund With Special Voucher is selected in the holds any of the values field.
Select (+), and then select Attributes. This time, select Does not include from the Filter result dropdown menu.
Select Refund With Standard Voucher from the holds any of the values field.
In the bottom right corner, select Apply.
In the command bar at the top, select Save > Save as, and enter Refund w/ Special Voucher.
Create the 'Refund With Standard Voucher' view
Go back to the filter screen by selecting the Filter button in the bottom left of the screen.
Repeat steps 10 through 13, but choose Refund With Standard Voucher and Refund With Special Voucher, respectively.
In the command bar at the top, select Save > Save as, and enter Refund w/ Standard Voucher.
We've created two different views. One view shows the paths that have the Refund With Special Voucher step but not the Refund With Standard Voucher step (Refund w/ Special Voucher). The other view is its inverse (Refund w/ Standard Voucher). Let's compare these two views.
In the left panel, select Process compare.
In the bottom right corner, select (+).
From the Views dropdown menu, select Refund w/ Special Voucher, and then select ADD LAYER.
The process map that's created is a comparison of the two views. In the Customize panel, ensure that Mean duration is selected as the metric.
Save this view as Standard vs. Special.
Understand the process map with different views
The orange nodes represent steps common to both views. Green nodes represent the steps that take place in only the process with a special voucher. Blue nodes represent steps that take place only in the paths with standard voucher.
From the screenshot in the earlier screenshot, we can see that there were only nine cases with Refund With Special Voucher, but on average, that step lengthens the process by almost 17 hours according to the process compare map immediately above.
Notice that cases that have the Refund With Standard Voucher step also have the possibility of invoices being rejected as the Reject Invoice step suggests. This Reject Invoice step contributes only 2.8 hours on average to the process.
Based on insights we derived from this analysis, let's summarize our findings, derive a conclusion, and offer some recommendations for this process.
Refund With Special Voucher:
Takes place only a few times in the process compared to other steps.
Has a relatively low amount of money flowing through it.
Significantly increases the mean duration of the entire process.
Refund With Standard Voucher:
- Often causes the invoice to be subsequently rejected which only adds a little bit of time to the mean duration of the process.
Considerations for choosing a special or standard voucher
This organization has two ways to make refunds using vouchers: Refund With Special Voucher or Refund With Standard Voucher. The latter may sometimes cause some rework because some of those invoices are subsequently rejected. On the other hand, using the special voucher never causes invoice rejection, which may make it seem like using a special voucher should be the consistent course of action.
However, having the possibility of the invoice being rejected via a standard voucher saves the organization more time than using a special voucher, which never causes the invoice to be rejected—in fact the difference in mean duration is approximately 13.79 hours.
An organization should focus on using standard vouchers versus special vouchers because just a few special vouchers can add a lot of time to the process.
An organization should do further analysis to determine why using the standard invoice often causes invoice rejection. If they're able to uncover a remedy for this, the organization can implement this to further improve the process.
To learn more about how to take advantage of the advanced capabilities of the minit desktop application, go to Minit desktop application overview (preview).