Step by Step: From Database to Event Log

52:14Recorded on 15 June 2015 at TU Eindhoven

Mieke Jans(Hasselt University, Belgium)

When you create an event log from ERP data, you need to make certain choices during the data preparation that influence the kinds of process mining analyses you can do. Mieke walks you through these choices step by step.

Synopsis

Extracting process mining data from ERP systems like SAP and Oracle is a challenging task. The problem is not only to find the right data in the thousands of business tables, but there is a whole range of other questions that have a direct impact on the suitability of the data that you get.

Mieke Jans created her first event log from a relational database already 8 years ago as part of her PhD research and elaborated her experience later in industry. By now, she has created dozens of event logs from different relational databases (from standard ERP systems to custom-made legacy systems).

Mieke walks you through a step-by-step approach for extracting a good event log from any relational database. Based on illustrations of each step you will learn about the implications of your decisions and get a unique head start the next time you need to extract process mining data from a database.

More from Process Mining Camp 2015

Studying a Lengthy Administrative Process

Léonard Studer (City of Lausanne)

Léonard and his colleague Ines analyzed the construction permit process at the City of Lausanne, which is regulated by 27 different laws from Swiss federal law, cantonal law, and communal regulation.

How to Manage your Process Mining Analysis

Willy van der Schoot (Atos)

Willy focuses on how to stay organized in your process mining analysis. She shares tips about preparing the data with optimal flexibility, taking different perspectives on the process, and communicating the results to an audience unfamiliar with process mining.

Manufacturing Improvement

Joris Keizers (Veco)

Joris demonstrates how process mining has helped to cut the lead time of their core production process in half by unlocking relevant process knowledge of key employees who have less of a feeling for statistical methods.

Process Mining in Healthcare

Bart van Acker (Radboudumc)

Bart shows us how process mining can help to bridge the gap between process improvement professionals and the medical staff based on the example of the Intensive care unit and the Head and Neck Care chain at Radboudumc hospital.

Using Process Mining in an Event-Driven Environment

Edmar Kok (DUO)

Edmar demonstrates how process mining can be used to very quickly uncover technical errors and KPIs in the pilot phase of a new system based on a project at DUO, the study financing arm of the Dutch Ministry of Education.

Process Mining Metrics

Anne Rozinat (Fluxicon)

Anne gives a deep-dive into the world of metrics: What constitutes a good metric? What are the pitfalls? What kind of questions you can answer with process mining?

Fireside Chat

Wil van der Aalst (TU Eindhoven) and Anne Rozinat (Fluxicon)

Wil and Anne discuss the state of the field of process mining and take questions from the audience.

Explore Process Mining Camp 2015

© 2024 by Fluxicon BV, all rights reserved.
You can read our privacy policy here.

Page created in 14.3 ms.