Design Business Processes with SAP Signavio Solutions

Learning the Basics for Consultants

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use a powerful language to get the best out of process mining to obtain business insights

SiGNAL in SAP Signavio Process Intelligence Introduction

Course Overview

This course covers all you need to know to use SiGNAL in SAP Signavio Process Intelligence. We'll start with the basics and our approach for using this for process mining. This course also focuses on creating advanced queries for the best exploitation of process and data mining.

After completing this course, you will be able to:

  • Use a powerful language to get the best out of process mining to obtain business insights
  • Create your individualized analysis
  • Use the extension of the standard SAP Signavio Process Intelligence

How to Complete This Course:

  • Once you have explored all the content, there will be a knowledge check at the end of the course.
  • This course takes about 1 hour.
  • Ready to begin? Just click the Start Course button on the top.

Business Case

Our lesson will start by looking at a business case process that we can use as our example throughout the lesson. This process is based on a simplified Order to Cash scenario at an international company that sells high quality, fair-trade T-shirts with prints on it. The customer can either order a pre-printed shirt from the online shop or can chose a custom print. In both cases, a prepayment is required before the order gets shipped.

The image shows the BPMN diagram of the Order to Cash process.

The image shows the BPMN diagram of the Order to Cash process.

Dataset

  • The dataset consists of events and attributes.
  • Events in our dataset represent the activities that are executed in our Order to Cash process. The event log therefore shows the individual activities such as Receive Payment, Print T-shirt, etc. The attributes dataset contains additional information such as order status, customer type, type of goods, etc.
  • The dataset is needed to analyze the process with the events and the attributes.
  • In the hands-on exercise, we will use the dataset to analyze SiGNAL data such as number of orders of T-shirts, payment type and many other data.

Let's look at the events and attributes in our Order to Cash process. Click each card for more information.

Get Your Own 30-day Trial Version!

Feel free to register for a free 30-day trial version and explore the SAP Signavio Process Intelligence (and other products of SAP Signavio Business Transformation Suite). No credit card / payment is required. With your trial license, you can implement the practical exercise directly in SAP Signavio.

Download Exercise Worksheet

Download the Exercise Worksheet to solve the tasks after the course. After completing the chapters in the course, you will be able to solve the exercises on your own.

Download Exercise: Exercise

Download Datasheet: Datasheet

Next, we're going to look at the basics of SiGNAL.

What is SiGNAL?

SIGN (SIGNAVIO) A (Analytics) L (Language)

SiGNAL is SAP Signavio's dedicated query language for process analytics. It provides an editable backend to:

  • Create more in-depth process queries
  • Retrieve data and perform calculations
  • Visualize your results in detailed charts

SiGNAL Benefits

The advantage of SiGNAL is its flexibility and extensibility. You can use the data from:

  • SAP Signavio Suite (models and dictionary content, hub usage, workflows, etc.)
  • External systems
  • Machine learning models
  • Simulation scenarios

With SiGNAL it's possible to get data visualizations of your results. Queries can be run for process-related behavior and KPI computation. SiGNAL is a SQL-oriented language, which makes it more familiar and easier to learn.

The SiGNAL Mining Engine is a cloud-based in-memory query engine that can process large event logs in real-time.

Click each tab to learn more about the benefits of SiGNAL.

How does SiGNAL work?

The interaction below shows all the functions offered for SiGNAL. Don't get overwhelmed by the amount of functions! Once you begin using it, you will see which ones are commonly used for your organization.

With SiGNAL, simple as well as complex queries can be created. Let's have a look on a more complex one, to show you what functions SiGNAL supports.

Select each option on the left-hand side to highlight the code associated with that function.

Breakdown Widget

VP Commentary on SiGNAL

To see what our Product VP for Process Intelligence has to say about SiGNAL, watch the following video: Introduction to SiGNAL.

In the next lesson, we'll compare SiGNAL to SQL.

How is SiGNAL different from SQL?

The difference between SiGNAL and SQL is the data model. With SQL, you query the data from multiple tables. However, SiGNAL queries the data from only one table, which contains nested events. Additionally, SiGNAL provides custom functions to work more effectively with this data structure.

SiGNAL vs SQL

  • SiGNAL is not able to create inner joins like SQL.
  • SiGNAL is not in data table format! This means that no data records can be deleted, written, moved, or changed.
  • SiGNAL is used to start queries, we only use the data from the tables, we do not change them, we retrieve the data to perform analysis.

Great! So far, so good! In the next lesson, we will learn the basics of creating simple queries.

Queries

A query is a request for information. In computer programming, a query is also a request for information, except the information that is requested comes from a database. You can manipulate data with queries, so you can add, delete, or change data from database tables.

It's not easy to write a query. In order to do this, you need to know a predefined code that the database understands in order to manipulate the data. This code is called the query language.

For database management, the standard query language is the Structured Query Language (SQL). Of course there are different languages, such as AQL and DMX, but SQL is the most popular.

The following hints may help you create queries faster and keep them comprehensible.

Click each hint for more information.

Next, let's take a deeper look at the data models for queries.

Cases, Attributes, Events

The columns case_id, event_name, and end_time are always present. Case attributes like Customer ID, Status, and City have the same value throughout the case. An additional event attribute, such as Payment method, can have different values for each event.

There are two ways to use this data:

  • Per case: Each case is treated as one row. The nested events and event attributes are represented as a nested table.
  • Per event: Each event is treated as one row. The case ID and case attributes are repeated for each event.

Data Types

Data Types

The Data Type column defines which value the column can hold. All data types can occur on both case level and event level (nested).

SiGNAL supports the data types shown.

All of these data types can appear in the source file and in the query result.

Both case and event attributes can be Null, indicating the absence of a value or an unknown value.

SiGNAL Syntax Example

SiGNAL Syntax

The Syntax of SiGNAL is SQL oriented but includes extensions:

  • SELECT expressions
  • FROM table or process
  • WHERE conditions

The SELECT statement is used to select data from a process. The data returned is the result set. The FROM clause produces the tabular structure – the starting set of data on which all other operations in a SELECT statement are performed. The WHERE statement is used to filter the records and to set conditions.

Let's look at an example. The image below shows a query for the number of canceled orders by Premium Customers. This is the type of query you can type in SiGNAL to obtain your data results and visualizations.

How can we use the data model for creating queries to analyze our processes?

When mining the data of a process, you retrieve the data of a single table. This table contains the case attributes and their events.

The following table shows this structure:

Using the Data Model to Create Queries - Example 1

Using the Data Model to Create Queries - Example 2

In the next lesson, we will introduce operators and functions for SiGNAL. We will learn how to use these to solve the questions from the exercise sheet. 

SiGNAL - Functions

SiGNAL supports a variety of aggregation functions.

Click each card for more information on the aggregation functions.

Click each card for more information on the aggregation functions.

Click each card for more information on the aggregation functions.

Click each card for more information on the aggregation functions.

Save progress to your learning plan by logging in or creating an account