Blog Posts

Case Study: Auditing With Process Mining — Part V: Raw Data

Step 4: Raw data

This is the 5th article in our case study series on auditing with process mining. The series is written by Jasmine Handler and Andreas Preslmayr from the City of Vienna. You can find an overview of all the articles in the series here.

The data for our process mining analysis was stored in two different systems: SAP and the WMD xSuite feeder. We had identified the data tables that needed to be extracted from these systems when we specified the data model. We had no direct access to the Wiener Stadtwerke’s information systems. Thus, the audited party extracted the data tables for us and provided the raw data in CSV files.

From the data model, we already knew in which tables the timestamps for each activity were located. For example, we knew that the timestamp for ‘Create purchase request’ could be found in the EBAN table. The timestamp for the ‘Release purchase request’ activity could be found in the WMD table, and so on. However, because the raw data was distributed across multiple CSV files, we also needed to find the connections between the individual data tables so that we could merge the files into one (see Figure 6 for the connections between the tables – click on the image to see a larger version).

Raw data with connections between the tables
Figure 6: Raw data with connections between the tables

For each table, we identified which information could be used as a timestamp for an activity, resources, and other activity- or case-related attributes.

Based on the knowledge of the relevant data fields for the activity timestamps, attributes, and resources, and with this understanding of the connections between the raw data tables, we now had the basis for building our event log.

New parts in this auditing series will appear on this blog every week. Simply come back or sign up to be notified about new blog entries here.

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples