# 251|CELONIS – Process Mining

**URL:** <https://www.techhub.training/t/251-celonis-process-mining/4835>\
**Category:** Challenges\
**Tags:** beginner, celonis, process-mining, i2c\
**Created:** [April 17, 2025, 12:53am UTC](https://www.techhub.training/t/251-celonis-process-mining/4835 "2025-04-17T00:53:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/j/7993a0/32.png) [@Jason\_Nguyen](https://www.techhub.training/u/Jason_Nguyen)\
**Post date:** [April 17, 2025, 12:53am UTC](https://www.techhub.training/t/251-celonis-process-mining/4835/1 "2025-04-17T00:53:09Z")

</div>

_BYU Student Author_: @Jason_Nguyen  
_Reviewers_: @Michael_Barney, @James_Behling  
_Estimated Time to Solve:_ 20 Minutes

We provide the solution to this challenge using:

- Celonis

Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138).

**Overview**  
You are a financial analyst at a mid-sized firm, Courgary, struggling with delayed payments from customers. Your boss has noticed increasing Days Sales Outstanding (DSO) and wants a data-driven approach to find the bottlenecks in the process and improve the overall efficiency to reduce bad debt expense.

Your manager has provided event log data extracted from the company’s ERP system, and you need to use Celonis EMS to analyze and optimize the Invoice-to-Cash (I2C) process. Your task is to identify bottlenecks, rework loops, and deviations from the ideal process. You should make some suggestions to improve the I2C process.

**Instructions**

1. Sign up for a Celonis account. Click [here](https://signup.celonis.com/ui/sign-up/get-started) to register

2. After signing up and completing the account set up process, log in to your account. Here is the [log in link](https://id.celonis.cloud/user/ui/login), just in case.

3. As you finished logging in, this figure will show up. Please follow the instruction to reach to dashboard.

 ![Step3Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/85463bbb7175920ac85ef48fa6e78be840325408.png)

1. Under “Analyze an event log” section, upload the dataset by clicking the leftmost button, CSV/XLSX file

2. Under “Map your data” section, allocate the “Case ID”, “Activities”, “Timestamp” to the corresponding columns.

3. Go to “Process Discovery” in Celonis. Exploring options such as  
a. “What does your process look like?”  
b. “How long does your process take?”

4. It will generate a Process Model (a flowchart of how invoices move through the system).

5. Analyze the actual process vs. ideal process:  
a. Are there long delays between invoice approval and payment?  
b. Are there rework loops (e.g., invoices going back for re-approval)?  
c. What is the throughput time and target hit rate?  
d. Make some suggestions to tackle the bottleneck problem, if any

6. Write two paragraphs summarizing your key analysis from the process discovery section and your suggestions to tackle any problems that you have found.

**Data Files**

[Challenge251\_CELONIS\_DataSet.docx](https://byu.box.com/shared/static/u8j59nwjvo9q0opasz6p4u0ucpc3jf7v)

> **Suggestions and Hints**
>
> [Challenge251\_CELONIS\_Suggestions & Hints](https://byu.box.com/shared/static/7osz1wd1grwwdojwslclv4qwlvmdu3lk)

**Solution**

[Challenge251\_CELONIS\_solution.docx](https://byu.box.com/shared/static/f512eoakzs0pplm0555y3cyrvji8g9dy)

_Solution Video:_ [Challenge 251|CELONIS\_Solution video](https://youtu.be/mH54RMqGw3w)

Here is what your process should look like. Analyzing the data from the process.

 ![SolutionImage](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/4/4a2e9496ab06d04d18259b2975b518c2374bbeb5.png)