Process mining turns your existing data into a map of how work actually flows through your organization. Instead of asking people how a process works, you let the system logs tell you. Every time a transaction, case, or order moves from one step to the next, it leaves a digital footprint. Process mining reads those footprints and builds the real process, not the one on the whiteboard.
Use process mining when you have a system that records activity logs with timestamps, such as an ERP, CRM, MES, ticketing system, or hospital EMR. If your system tracks who did what and when, you have the raw material for process mining. It works best when you suspect the process is more complex than anyone realizes, or when you need to analyze hundreds or thousands of cases at once, which no manual observation method can do.
Your data needs three columns. The Case ID is a unique identifier for each instance of the process, such as an order number, patient ID, or ticket number. Every row that belongs to the same case shares the same Case ID. The Activity column describes what happened at that step, such as “Intake,” “Review,” or “Approve.” The Timestamp records when that activity occurred. Together, these three columns let the tool reconstruct the sequence of events for every case and calculate how long each transition took. Your column names can be anything in your spreadsheet. You will map them to the right fields in the next step.
Process mining is Gemba for the digital age. In Lean thinking, Gemba means going to the actual place where work happens to observe what is really occurring. The traditional approach to understanding a process is process mapping: a team physically goes to where the work happens, observes the steps, interviews the people doing them, and draws the process by hand on a whiteboard or sticky notes. That map reflects what the team saw and heard over a few days. It is powerful for building shared understanding and designing solutions, but it shows you the process as people experienced and remembered it, one observation at a time.
Process mining applies the same Gemba principle to your digital records. Instead of walking the floor, you walk the event log. Every case your system has ever recorded becomes an observation. The tool reconstructs the full picture automatically, surfacing rework cycles where work loops back to a step it already completed, and bottlenecks where cases pile up waiting for the next activity. Where process mapping captures what a team observed on a given day, process mining surfaces every variant across thousands of cases simultaneously, with no filtering and no memory gaps.
Use process mapping to engage the people who do the work and design the future state. Use process mining to understand what is actually happening at scale before you walk into the room.
Your spreadsheet needs at least three columns. Names can vary.
| A | B | C | |
|---|---|---|---|
| 1 | CaseID | Activity | Timestamp |
| 2 | 1001 | Intake | 1/2/24 8:00 |
| 3 | 1001 | Review | 1/2/24 10:30 |
| 4 | 1001 | Approve | 1/3/24 9:15 |
| 5 | 1002 | Intake | 1/2/24 9:00 |
Click any cell, select all, then copy the data.
| A | B | C | |
|---|---|---|---|
| 1 | CaseID | Activity | Timestamp |
| 2 | 1001 | Intake | 1/2/24 8:00 |
| 3 | 1001 | Review | 1/2/24 10:30 |
| 4 | 1001 | Approve | 1/3/24 9:15 |
| 5 | 1002 | Intake | 1/2/24 9:00 |
Click inside the text area on the next screen and paste.
1001,Intake,2024-01-02 08:00
1001,Review,2024-01-02 10:30
1001,Approve,2024-01-03 09:15
1002,Intake,2024-01-02 09:00
...
* Bottlenecks prioritize highest average wait time between activities.