BYU Student Author: @Jimmy_Han
Reviewers: @Trent_Barlow, @Benjamin_Lau
Estimated Time to Solve: 20 Minutes
We provide the solution to this challenge using:
- Celonis
Celonis is a tool that helps businesses understand how their work is accomplished. Consider it as a detective tool for your company’s tasks. It analyzes the data from your daily activities and presents you with a map of your processes. This map can help you identify areas where operations are slow or where you might be performing unnecessary steps. By recognizing these inefficiencies, you can streamline your work, eliminating unhelpful parts and making your processes faster and more efficient.
Overview
As a new process analyst at a management consulting firm, your first job is to look into how Cougar Hamburger Restaurant does things to help them work faster and better. They’re having some issues that slow down their service and make customers less happy. Your manager first reviewed the case and asked you to dig deeper into certain areas. 1) Find out if the restaurant often has to call customers back to double-check orders. This could mean there’s a problem with how they’re taking orders in the first place. 2) See if they can get their deliveries out quicker by planning the delivery routes right when they get the order, instead of waiting until the food is ready. Your work is all about making sure the restaurant serves their customers faster and more accurately, improving how happy customers are with their service.
Instructions
- Sign up for the Celonis website.
a. You need a Celonis Academic Alliance account to access Celonis Studio. Sign up for free here. Once you sign in, you will see the screen below. Click on “[Your Name]’s Academic Alliance” to access your Studio.
- Sign in to Celonis Academic Alliance and import the “Data File” included in this challenge.
a. You will land on the “Configure” screen first. Since the data is already tidy, just hit “Next”.
b. Next, you’ll get to the “Map your data” page. This step is to check that your data file’s columns match what we need for the analysis. Select the columns in the following order: CASE IDENTIFIER, ACTIVITY, AND TIMESTAMP. - Create a Process Explorer.
a. Find the Studio in the left sidebar.
b. Click on “Create Package” at the top of the menu.
c. When it asks for a Package name, type “Hamburger” and create.
d. Look for the Choose data model option, pick [Quickstarts] CSV/XLSX (this is how the file you uploaded is labeled). Hit Next, swap the Key name to “Hamburger,” and save it.
e. Now, hit Create Analysis, enter “Hamburger analysis” for the name, and select the “Hamburger” data model variable. Click Create.
f. Go ahead and click on “Process Explorer” - Use the Process Analysis page to answer a few questions
a. How many cases have there been where the restaurant needed to call customers? Check out Hint 1 if you’re stuck.
b. Could Cougar Hamburger cut down on delivery time by planning routes right when orders come in? If you think so, how many minutes can they save for delivery? See Hint 2 for a little help figuring this out.
Data Files
Suggestions and Hints
-
Push the “Activity” slider upwards, located on the right side of your screen. By default, Celonis typically shows only the more frequent activities, leaving out the rarer ones. By sliding it up, you’ll begin to see more of these infrequent activities in the process map, helping you catch those less common but possibly key events.
-
Click on the icon
at the top left of your canvas to display the average Throughput Time between activities. Throughput time measures the total time it takes to finish a task from start to end. Remember to hover over the icon to change the throughput time format from “days” to “minutes”.
Solution
Solution Video: Challenge 183|CELONIS – Discover Cougar Hamburger Process