Process management currently focuses on large sets of processes. The problem of large dimensions occurs by increasing the number of processes and their features [57]. event logs may have challenges such as heterogeneity, large volume, correlation with other processes, and missing data; on the other hand, there is a wide variety of innovative techniques in the mining process, which makes the blind application of these techniques ineffective in real, complex, and very flexible processes. In fact, it is necessary to adapt the chosen approach to the characteristics of each case study and frame its application with an understanding of the problem in question [58].
In this regard, a number of 35642 data related to 16490 workflows in the logistics process of Ayandeh Bank during the six months of 2020 were extracted from the automation and correspondence system of bank offices. To select the extracted data analysis tool, a list of the most common process tools used in the 2019 process mining competition held at the University of Lisbon is shown in Table 2. As observed, Disco, ProM and Excel tools are used frequently. In this study, Excel software and its Power Query feature were used to refine and prepare. Furthermore, Disco 2.14 software was used for analyzing the event graphs
Table 2. Common tools of process mining [59]
The present study was considered descriptive in terms of the information analysis method. In addition, this study was applied since this study aimed to improve the logistics processes of the bank. This study was data-driven based on the nature of the study which was the use of logistics process data.
Data analysis
Data preparation is considered as one of the most significant parts of data analysis. A small error at this level can change the final result of the study completely and avoid correct results [60].
Findings
After entering the information and running the software, Fig. 3 was extracted as the actual diagram of the process.
Implementation of discovery technique
After running the software, 23 independent workflows were extracted for this process. Table 3 presents the ratio of workflow and included activities along with the number of their repetitions.
Table 3. Analysis of discovered workflows
No.
|
Ratio of activities
|
Ratio of workflows
|
Number of repetitions
|
1
|
63%
|
68%
|
11248
|
2
|
17%
|
12%
|
2042
|
3
|
5%
|
10%
|
1807
|
4
|
3%
|
3%
|
559
|
5
|
<1%
|
<1%
|
287
|
6
|
<2%
|
<1%
|
137
|
7
|
<2%
|
<1%
|
117
|
8
|
<1%
|
<1%
|
84
|
9
|
<1%
|
<1%
|
53
|
10
|
<1%
|
<1%
|
37
|
11
|
<1%
|
<1%
|
26
|
12
|
<1%
|
<1%
|
25
|
13
|
<1%
|
<1%
|
19
|
14
|
<1%
|
<1%
|
12
|
15
|
<1%
|
<1%
|
11
|
16
|
<1%
|
<1%
|
7
|
17
|
<1%
|
<1%
|
7
|
18
|
<1%
|
<1%
|
3
|
19
|
<1%
|
<1%
|
3
|
20
|
<1%
|
<1%
|
2
|
21
|
<1%
|
<1%
|
2
|
22
|
<1%
|
<1%
|
1
|
23
|
<1%
|
<1%
|
1
|
It should be noted that no new workflow or activity is observed, which was predictable since the automation and administrative correspondence system does not allow any other workflow or activity except the predetermined items in the system.
Implementation of checking and adaptation technique
Table 3 indicates some points about the primacy and recency of activities. As a result, 596 product requests have not followed the predetermined rules of the process. Such non-adaptation can be categorized into six groups.
Implementation of improvement techniques
Improvement is considered as one of the techniques of process mining which is used in the redesign and improvement of a workflow by identifying the process bugs, shortcomings, and bottlenecks [5]. This technique aims to use the information in the actual running processes and the recorded event charts of the process for improving or developing the processes [61].
Analysis of input and output
The number of input and duration of each activity are among the parameters used in process mining. Table 4 shows the number of inputs for each activity in the logistics process of the bank.
Table 4.The number and ratio of input for each activity
Row
|
Activity
|
Number of incoming demands
|
Ratio of total demands
|
1
|
Submitting the product demand
|
16490
|
100%
|
2
|
Checking and determining the amount by electronic banking
|
2798
|
17%
|
3
|
Registering a purchase demand
|
521
|
3%
|
4
|
Sending to purchase process
|
521
|
3%
|
5
|
Registering the order
|
518
|
3%
|
6
|
Registering the purchase invoice
|
380
|
2%
|
7
|
Registering the warehouse receipt
|
374
|
2%
|
8
|
Sending products to the warehouse
|
307
|
2%
|
9
|
Issuing the warehouse remittance and delivering to the customer
|
13733
|
83%
|
Process duration analysis
Checking the process duration is one of the most effective points in process mining. Fig. 4 displays the actual average duration of the logistics process.
Figure 4 shows an overview of the process. The maximum time interval between the two activities is 15.5 days which is related to issuing warehouse remittance and delivering to the applicant, as well as checking and determining the amount by electronic banking. This demand is practically removed from the data range since it is identified as a demand for defective products in the adaptation technique. Accordingly, the maximum time interval between the two activities is 15.4 days which is related to the two activities of sending to the warehouse and registering the warehouse receipt. Based on the software output, the average total process implementation for completed demands is 5.7 days. Table 5 presents the from-to process of activities related to the logistics process of the bank along with the total spent time. As shown, the calculation of the defective workflow identified in the adaptation technique is avoided.
Table 5. From-to process of logistics
Row
|
From
|
To
|
Amount
|
Total spent time
|
1
|
Submitting the product demand
|
Checking and determining the amount by electronic banking
|
2620
|
23.4 year
|
2
|
Submitting the product demand
|
Registering a purchase demand
|
521
|
21.7 day
|
3
|
Submitting the product demand
|
Issuing the warehouse remittance and delivering to the customer
|
11255
|
157.5 year
|
4
|
Submitting the product demand
|
Checking and determining the amount by electronic banking
|
170
|
41.5 month
|
5
|
Submitting the product demand
|
Sending to purchase process
|
350
|
73.3 month
|
6
|
Checking and determining the amount by electronic banking
|
Issuing the warehouse remittance and delivering to the customer
|
2042
|
22.5 year
|
7
|
Checking and determining the amount by electronic banking
|
Sending to purchase process
|
171
|
20.1 day
|
8
|
Sending to purchase process
|
Registering the order
|
518
|
10.8 year
|
9
|
Registering the order
|
Registering the purchase invoice
|
380
|
13.9 year
|
10
|
Registering the purchase invoice
|
Sending products to the warehouse
|
307
|
29.9 month
|
11
|
Sending products to the warehouse
|
Registering the warehouse receipt
|
302
|
12.7 year
|
12
|
Sending products to the warehouse
|
Issuing the warehouse remittance and delivering to the customer
|
101
|
50.3 week
|
The average period of each activity can be obtained from the data shown in Table 5. Such information is summarized and displayed in Fig. 5.
Fig. 5. The average period of each activity
The maximum average period is for "registering the warehouse receipt", "registering the purchase invoice" and "registering the order" which is one of the activities related to the process of purchasing products and services.
Analysis of categories and subcategories
Tables 6 and 7 show the delivery time for each category and sub-category was extracted.
Table 6. Average delivery time by categories
Row
|
Category
|
Number
|
Average completion time (days)*
|
The number of delivery
|
The ratio of delivery
|
1
|
Properties
|
1409
|
9.6
|
571
|
40.5%
|
2
|
Securities
|
4940
|
5
|
4631
|
93.7%
|
3
|
Consumption
|
7336
|
5.4
|
6400
|
87.2%
|
4
|
Bank cards
|
2636
|
4.8
|
2124
|
80.6%
|
5
|
Bank stamps
|
129
|
0
|
0
|
0%
|
6
|
Others
|
40
|
3.4
|
7
|
17.5%
|
*This period is calculated for completed demands.
|
Based on the results, none of the demands for products in the category of bank stamps have reached the stage of issuing a warehouse remittance and delivering to the customer. In addition, the maximum delivery rate is related to securities, consumption, and bank cards, respectively. Finally, the maximum delivery time is related to properties.
Table 7. Average period of sub-categories
Category
|
Sub-category
|
Number
|
Average completion time (days)*
|
The number of delivery
|
The ratio of delivery
|
Properties
|
Electronic appliances
|
715
|
10.2
|
302
|
42%
|
Stationery
|
49
|
5.8
|
34
|
69%
|
Essentials
|
152
|
6.7
|
90
|
59%
|
Others
|
6
|
0
|
0
|
0%
|
Furniture and fixtures
|
189
|
18.8
|
47
|
25%
|
Furniture
|
298
|
7.5
|
98
|
33%
|
Consumption
|
Electronic
|
2084
|
5.7
|
1781
|
85%
|
Stationery
|
2059
|
5.3
|
1783
|
87%
|
Essentials
|
2904
|
5.3
|
2661
|
92%
|
Others
|
212
|
4.4
|
172
|
81%
|
Furniture and fixtures
|
61
|
1.5
|
2
|
3%
|
Furniture
|
16
|
1
|
1
|
6%
|
*This period is calculated for completed demands.
|
Analysis of undelivered items
Unfinished requests are those which have not reached the stage of issuing a warehouse transfer and delivering to the applicant. Fig. 6 displays the workflow flow chart of the process without considering the activity of "issuing the warehouse remittance and delivering to the customer". As shown, 2757 demands for products have not reached the stage of warehouse remittance and delivery to the customer. A number of 2757 product demands failed to reach the end of the process and the desired product was not delivered.
In this regard, it is necessary to evaluate the unfinished demands separately for each activity. Table 8 presents the number of unfinished demands from each activity and their corresponding figure. Each of these demands for product has not been completed because of a specific reason. Some bottlenecks in the process can be identified by analyzing these causes from another point of view.
Table 8. The number of unfinished demands from each activity
Row
|
From activity
|
Number of unfinished
|
1
|
Submitting the product demand
|
1807
|
2
|
Checking and determining the amount by electronic banking
|
559
|
3
|
Registering a purchase demand
|
3
|
4
|
The process of purchasing goods and services
|
Order registration
|
110
|
Registering the purchase invoice
|
1
|
Sending products to the warehouse
|
4
|
5
|
Registering the warehouse receipt
|
273
|
Total
|
2757
|
In the logistics process of banks, there are two stages for reviewing the demand and determining the amount conducted by the support deputy and the electronic banking deputy depending on the type of products. Based on the results, 391 demands for products failed to be completed after passing the stages of reviewing the demand review and determining the amount and the desired products have not been delivered to the customers. A number of 273 demands were stopped in the stage of registering the warehouse receipt which is the stage before the stage of issuing the warehouse remittance and delivering to the customer. Table 9 presents the 10 undelivered demands which passed the longest time since their last activity.
Table 9. Ten demands with the longest time
Row
|
Last stage
|
Number
|
Date of the last stage
|
Category
|
Sub-category
|
Delay time
|
1
|
Registering the order
|
1
|
2020/4/20
|
Consumption
|
Essentials
|
423
|
2
|
Registering the order
|
1
|
2020/4/21
|
Consumption
|
Essentials
|
422
|
3
|
Registering the invoice
|
2
|
2020/4/26
|
Properties
|
Essentials
|
417
|
4
|
Registering the order
|
38
|
2020/5/2
|
Bank stamp
|
Bank stamp
|
411
|
5
|
Registering the invoice
|
2
|
2020/5/3
|
Properties
|
Furniture and fixtures
|
410
|
6
|
Registering the invoice
|
2
|
2020/5/5
|
Consumption
|
Stationary
|
408
|
7
|
Registering the order
|
5
|
2020/5/6
|
Properties
|
Furniture
|
407
|
8
|
Registering the invoice
|
1
|
2020/5/7
|
Properties
|
Electronic appliances
|
406
|
9
|
Registering the order
|
1
|
2020/5/10
|
Consumption
|
Essentials
|
403
|
10
|
Registering the invoice
|
2
|
2020/5/12
|
Properties
|
Electronic appliances
|
401
|
As observed in Table 9, there are undelivered demands which have been over 400 days since their last activity. The average period of the last activity until the date of receiving the report for 391 undelivered demands is about 315.7 days. The category and sub-categories of these demands are one of the factors which can help in deciding to improve the process as shown in Tables 10 and 11.
Table 10. Number and average duration of uncompleted demands by categories
Row
|
Category
|
Number
|
Average period (days)
|
1
|
Properties
|
163
|
317.3
|
2
|
Securities
|
0
|
0
|
3
|
Consumption
|
181
|
294
|
4
|
Bank cards
|
0
|
0
|
5
|
Bank stamps
|
38
|
411
|
6
|
Others
|
9
|
322.3
|
As shown, there is no uncompleted approved demand in the securities and bank cards categories. In other categories, the average duration of the last activity is not a desirable condition. It is worth noting that 38 demands are available for products from the category of bank stamps, which are all demanded at the same time but not all of them reach the customers after approval.
Table 11. Number and average period of unfinished demands by sub-categories
Category
|
Sub-category
|
Number
|
Average period (days)
|
Properties
|
Electronic appliances
|
68
|
326.1
|
Stationary
|
1
|
93
|
Essentials
|
14
|
328.4
|
Others
|
3
|
238
|
Furniture and fixtures
|
56
|
307.9
|
Furniture
|
21
|
315.6
|
Consumption
|
Electronic appliances
|
89
|
298
|
Stationary
|
8
|
375.1
|
Essentials
|
33
|
297.1
|
Others
|
9
|
323.8
|
Furniture and fixtures
|
34
|
244.6
|
Furniture
|
8
|
331.75
|
The status of the sub-categories is similar to the categories, and the rest of the items are not in a desirable condition except the stationery sub-category in the properties category.