In process mining, you analyze business processes using data that has been transformed into event logs. The event logs are used by the Process Explorer, Variant Explorer, and Case Explorer components in Views to visualize your business processes and their details.
If you have a look at the Knowledge Model, you can see all the event logs and their metadata.
Take note that this training is based on an Object-Centric Data Model (OCDM). For more information about this, check out the Object-Centric Process Mining: Foundations course.
The Process Explorer, Variant Explorer, and Case Explorer components can also consume event logs from case-centric Data Models.
Let’s see how the event logs are used to configure the components through an example use case.
Imagine you are working with a business user, who is the new delivery process lead of a wholesale company. The business user has received feedback that the customers are dissatisfied with the order processing, partly due to the “poor delivery” of the orders. The business user would like to explore the delivery process end to end - from the orders being made all the way up to the items being delivered to the customers. They already have an idea of what it's like but they are open to seeing what kind of insights they can get from Celonis!
For the delivery process, the business user has identified 4 key objects from the Order Management process data: Sales Order, Sales Order Item, Delivery, and Delivery Item. If you are not familiar with these objects, check out their descriptions below.
Sales Order Sales Order Item Delivery Delivery Item
When a customer places an order, a sales order is created that lists all the sales order items the customer has ordered. Once the order has been processed and confirmed, a delivery document is produced that has all information surrounding how and when the order will be shipped to the customer - including the delivery items that correspond to the sales order items. The delivery order is tracked until the customer receives the order. The customer is then given a feedback survey to rate how satisfied they are with their order experience.
Since the business user wants to have a clear understanding of the delivery process, you’ve been asked to create a dashboard in a View that visualizes the process. So let’s start by setting up the View itself. After speaking with the business user, you’ve identified a few key metrics that are important to them.
Using the View you’ve just created, add a KPI List component to it and fill it up with the following information…
KPI 1
PQL Query: COUNT(DISTINCT "o_celonis_SalesOrder"."ID")
Name: # Sales Orders
Format: Rounded Number (#,###)
KPI 2
PQL Query: COUNT(DISTINCT "o_celonis_SalesOrderItem"."ID")
Name: # Sales Order Items
Format: Rounded Number (#,###)
KPI 3
PQL Query: COUNT(DISTINCT "o_celonis_Delivery"."ID")
Name: # Deliveries
Format: Rounded Number (#,###)
KPI 4
PQL Query: COUNT(DISTINCT "o_celonis_DeliveryItem"."ID")
Name: # Delivery Items
Format: Rounded Number (#,###)
Widen the KPI List component and place it at the top of the View.
Add a Line Chart component and fill it up using the following information…
Dimension
PQL Query: ROUND_MONTH("o_celonis_SalesOrder"."CreationTime")
Name: Date
Format: Date: Year-Month (Y-M)
Metric
PQL Query: AVG("o_celonis_SalesOrder"."custom_SatisfactionRating")
Name: Avg Satisfaction Rating
Format: Decimal Number (#.##)
Column Settings - Data Labels: Enabled, matching mark color
Axis settings - Y Axis Range
Min: 1
Max: 5
Widen the Line Chart component and place it below the KPI List component.
Here’s how you’d do it…
In practice, business users would be concerned about more KPIs and you’d want to consider different ways of visualizing these KPIs based on your business users’ needs. For example, your business user might also need the net order value of their sales orders categorized by their customer groups, which could be visualized using a bar chart.
But for this exercise, let’s just say the business user is happy enough with these numbers.
_Media:_
- https://fast.wistia.net/embed/iframe/9tmw2w0dab?seo=true&videoFoam=true