Academy Related Posts

PQL Microlearning: Learn process query language on the go with these free courses

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 PQL microlearning courses

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?

Learn process mining and execution management skills

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:

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!

bill detwiler author headshot celosphere 2022 1024x1024
Bill Detwiler
Senior Communications Strategist and Editor Celonis Blog

Bill Detwiler is Senior Communications Strategist and Editor of the Celonis blog. He is the former Editor in Chief of TechRepublic, where he hosted the Dynamic Developer podcast and Cracking Open, CNET’s popular online show. Bill is an award-winning journalist, who’s covered the tech industry for more than two decades. Prior his career in the software industry and tech media, he was an IT professional in the social research and energy industries.

Dear visitor, you're using an outdated browser. Parts of this website will not work correctly. For a better experience, update or change your browser.