Knowing PQL, the process query language, can be a useful skill for both Celonis EMS users and those applying for in-demand, data-centric jobs. PQL is a domain-specific, programming language used to run process-related queries on the custom-built Celonis PQL Engine.
Now, you can learn PQL in bite-sized chunks and while you’re on the go with new microlearning courses from Celonis Academy. Microlearning courses are short e-learning modules that cover a single topic and usually take less than 15 minutes. The new PQL courses are all designed to take 6 minutes or less, so you can learn almost anywhere.
Celonis Academy offers dozens of microlearning courses on process mining, task mining, execution management, sustainability and the Celonis EMS (execution management system). In May 2022, they released a series of new courses on PQL:
Celonis PQL: Design Goals & History - (video, 4 min): Find out about the five main pillars and history of Celonis PQL.
Basic Coding with PQL - CASE WHEN (video, 3 min): Have a look at what you can do with the CASE WHEN function.
CALC_THROUGHPUT - Basic Coding with PQL (video, 3 min): Calculate the time between two activities.
Process Index Functions - Basic Coding with PQL (video, 6 min): What is an index and what are index functions doing?
MATCH_PROCESS_REGEX - Basic Coding with PQL (video, 5 min): Look at specific process variants with this powerful regex function.
PROCESS EQUALS - Basic Coding with PQL (video, 4 min): Define a specific process pattern.
DateTime Modifications - Basic Coding with PQL (video, 2 min): Modify your timestamps and dates.
ISNULL and IS NULL - Basic Coding with PQL (video, 2 min): Check for NULL values.
LIKE - Basic Coding with PQL (video, 3 min): Let's do a fuzzy match.
BETWEEN - Basic Coding with PQL (video, 2 min): Use this function to look at a specific value range.
CASE WHEN - Basic Coding with PQL (video, 3 min): Have a look at what you can do with the CASE WHEN function.
COALESCE - Basic Coding with PQL (video, 4 min): Have a look at what you can do with CASE WHEN function.
Understand Basic SAP P2P Data (video, 2 min): Familiarize yourself with tables in SAP on a P2P process.
Introduction to the P2P Process (video, 1 min): What does a P2P Process consist of?
Celonis Academy offers over 300 courses to help you learn theprocess mining, process management, and execution management skills that today’s employers are looking for…all online and all for free. It’s quick and easy to register for Celonis Academy. For more information about the on-demand training courses and learning material available from Celonis, check out the following resources:
Process Mining: From Theory to Execution (free 10-hour, on-demand course developed by Celonis and the Process and Data Science (PADS) group)
Celopeers job market message board
If you want to help build the execution management and process mining systems that will be part of every enterprise IT toolkit, come work for Celonis!