The event log behind the dashboard belongs to a Dutch financial institute, which was officially published in the 13th International Workshop on Business Process Intelligence 2017. The data contains all applications filed through an online system in 2016 and subsequent events until February 1st, 2017. However, the system supporting the process has changed in the meantime. In particular, the system now allows for multiple offers per application. These offers can be tracked through their IDs in the log. The data set is simplified and manipulated for better understanding.

The following Power BI visuals can be found on the right side: 

Number of Resources per Activity: The number of assigned resources for each activity is presented in this visual.

Start Time: This visual provides the possibility to define an arbitrary time slot for more detailed analyses.

Origin/Activity: The event log used for this dashboard contains three main process sections: Application, Offer, and Workflow. In this visual, the user can choose between each of them. However, it is possible to observe all of them at the same time.

Number of loan activities: This visual shows the number of activities in the filtered loan cases.

Number of loan cases

Average of the requested amount: This shows the average applied loan values

Number of loan cases per goal per month: The behaviour of different loan goals in months can be observed in this visual. It is possible to drill down on the chart and see the daily trends in detail.

On the left side, the discovered process model by BIpm pro can be observed. Each node describes an activity whose name and frequency is written on it. Using the menu button in the upper left corner, the node label can be changed between the following options: Frequency, Case frequency, and Max repetition in cases. The same thing applies for the edges, where in addition to the frequency-related metrics, some time-related metrics are also available, like Average duration rime.

Based on the information that is presented by the visuals in this dashboard, lots of valuable hidden insights can be discovered. For instance, cancelling an offer usually takes twenty-three days, which seems too long at first glance. It takes nine days for an offer to be sent and two days to be accepted or refused.

In the Application procedure, it takes twenty-one days for an application to be cancelled on average, but it just takes eight days for an application to be validated.

Another remarkable insight in the Application procedure can be found rising the left slider (path threshold) to 100 %. All of the derived variants (a unique path between cases from start to end) have a sequential behaviour except the fifth variant V_5, which has a loop between A_Incomplete and A_Validating for ninety-five cases. More investigation seems to be necessary here. The tenth variant V_10 with six loan cases has the highest average of the requested amount (28.58K). It is about two times more than the total average.

The Loan dashboard by ProcessM helps you have a clear understanding of a loan process, including receiving an application from a customer, returning an offer from a financial enterprise or a bank to the customer, and the internal workflow of such procedure, employing BIpm Pro. Using our solution helps you find out the actual actions in your business, its bottlenecks, (non)compliance, and possible deviations from the optimal situation. With the aid of knowing all of those mentioned facts, a company could improve its processes, reduce its expenses and enhance its services or products. Join us in a different experience.