Learning the Basics Flashcards
In a data set what does events, event log and attributes show?
events represent the activities that are executed in our process
event log shows individual activities eg. receiving payment
attributes contain additional information eg. customer type, order status, case ID
What does a dataset consist of?
events and attributes
What is a dataset need for?
analysing the process with the events and attributes
What does SIGNAL stand for?
SIGNavio, Analytics, Language
What is signal?
a dedicated query language for process analytics
What does signal provide?
It provides an editable backend to:
- Create in-depth process queries
- Retrieve data and perform calculations
- Visualize your results in detailed charts
where can signal receive data from?
-SAP Signavio Suite (models and dictionary content, hub usage, workflows, etc.)
-External systems
-Machine learning models
-Simulation scenarios
What language does SQL use?
SiGNAL is a SQL-oriented language
What is SiGNAL Mining Engine?
a cloud-based in-memory query engine that can process large event logs in real-time
What are the 4 benefits of SIGNAL?
[PEPSi]
1. Process mining
2. Exploration at scale
3. process-related queries
4. SQL orientated
Explain how process mining is a benefit of signal?
Signal is optimised for process mining you can:
- measure process conformance
- reduce cycle types
- reduce the amount of rework
Explain how Exploration at scale is a benefit of signal?
signal supports exploration at scale with all kinds of PI users
Explain how process-related queries is a benefit of signal?
can run queries for process related behaviour and KPI computation
Explain how SQL orientated is a benefit of signal?
being SQL makes it easier to learn and use
How does SIGNAL work?
by offering functions
List functions offered
-date functions
-dynamic bucketing [useful to find groupings in continuous data e.g select date_trunc(‘year’,’oppCreatedDate’) as ‘create’]
- selective aggregations
- sequence matching
- conditional functions
- math functions
- time functions
- event-log sub queries
- sort
What is the main difference between SQL and SIGNAL?
the data model
signal queries data from one table with nested events instead of multiple and provides custom functions to work effectively with this data structure
What are other differences between SQL
- signal can’t create inner joins
- not in a data table format so data records can’t be edited, we just retrieve data for analysis
What is a query in computer programming terms?
a request for information where the data comes from a database
what is query language?
predefined code that the database understands in order to manipulate data
[writing queries hints] what are attributes and values written in?
Attributes are written in “ “
Values are written in () and are case sensitive
[writing queries hints] as events and attributes are not visually distinguished what can you do to see what’s available?
- open a new tab with your investigation
- click on a widget filter to see which events for which level is available
[writing queries hints] how to view selection of available data?
Ctrl. + Space
which attribute columns are always present?
case_id, event_name, and end_time
attributes can have the same value or different values, give example of such.
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.
What are 2 ways to use this (attribute?) 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.
What does the data type column define
which value the column can hold
Which level can data occur?
both case level and event level (nested)
Where can data types appear?
in the source file and in the query result
What is ‘Null’
indicates the absence of a value or an unknown value
What is the basic syntax of SIGNAL?
SELECT expressions
FROM table or process
WHERE conditions
Describe the ‘SELECT’ ‘FROM’ ‘WHERE’
SELECT - select data from a process
FROM - starting point on which all operation in SELECT statement are performed
WHERE - filter the records and to set conditions
[signal functions]
-difference between COUNT and COUNT(DISTINCT)
- what does FIRST() and LAST() do
- what BOOL_OR
- what BOOL_AND
– COUNT() returns the number of rows and COUNT(DISTINCT) returns the no. of unique row which doesn’t include duplicates or NULL values
– FIRST() returns first element and LAST() returns last element
–BOOL_OR : returns TRUE if any of the conditions are true
–BOOL_AND : returns TRUE if all conditions are true
