In the latest Process Mining Café, Rudi and I went through the most frequent questions around data. An event log is something that you make, and getting the data is often one of the first challenges you have at the beginning of your process mining project.

We also show you two common data transformations based on a practical example. Building the data on a logical level is a crucial step in understanding the choices you make preparing the data. Even a small sample data set can serve as the blueprint to explain how you need the data to be.

You can now watch the recording here if you missed the live broadcast or want to re-watch the café. Thanks again to all of you for joining us!

Links

Here are the links that we mentioned during the session:

• Data extraction checklist

• Marc Tollens from KLM shows how he analyzed Jira data at Process Mining Camp 2018

• Mark Pijnenburg and Carmen Bratosin analyzed data from the MRI machines at Philips Healthcare during Process Mining Camp 2019

• Skills and roles needed in your process mining team

• Manual activities need to be taken into account when you interpret your process map

• Which process mining project should you start with?

• Data suitability checklist

• Data requirements for new IT systems

• Jasmine Handler and Andreas Preslmayr did their own data preparation in this audit project, which enabled them to fully understand the data and the choices that needed to be made

• Combining data sets in Excel, in an ETL tool, and with SQL

• Column-formatted data often has missing timestamps for activity repetitions

• Transposing the data in Excel and with an ETL tool

• Put additional information in separate columns to preserve the flexibility to unfold individual activities

• You can get creative and find data for process mining everywhere. See also the Process Mining Café with Léonard Studer from the City of Lausanne in Switzerland, where we look at different examples of “Sequences of Stuff”

• Privacy, Security, and Ethics are becoming more and more important. See also the Process Mining Café with Dirk Fahland and Felix Mannhardt from TU Eindhoven, where we talk about how to be a responsible process miner

Contact us via cafe@fluxicon.com if you have questions or suggestions for the café anytime.

Have you already seen that the Process Mining Café is now also available as a podcast? So, if you prefer to listen to our episodes in your favorite podcast player, you can get them all here.

Sign up to our café mailing list, the YouTube playlist, follow Fluxicon on LinkedIn, or add the café calendar to never miss a Process Mining Café in the future.

Anne Rozinat

Market, customers, and everything else

• anne@fluxicon.com
• annerozinat
• @arozinat

Anne knows how to mine a process like no other. She has conducted a large number of process mining projects with companies such as Philips Healthcare, Océ, ASML, Philips Consumer Lifestyle, and many others.