QPR ProcessAnalyzer Wiki: Difference between revisions
(54 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div class="downloadButton" style="width: | <div class="downloadButton" style="width:190px;float:right;margin: 3px 12px 0px 15px;">[[Online_Learning_Platform|Online Learning<br />Platform]]</div> | ||
Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is | Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is a software for turning event and transactional data into visual process analysis and intelligence. Topics in this documentation are divided based on user roles for process analysts, developers and administrators. | ||
<div style="height:5px;"></div> | <div style="height:5px;"></div> | ||
== For Process Analysts == | == For Process Analysts == | ||
QPR ProcessAnalyzer | This section contains information how to get started with QPR ProcessAnalyzer and how to create your first dashboards! This section also describes how to use filters and how to make different kinds of analyses with QPR ProcessAnalyzer. | ||
<div style="display: flex;flex-wrap: wrap;"> | <div style="display: flex;flex-wrap: wrap;"> | ||
Line 11: | Line 11: | ||
=== Getting Started === | === Getting Started === | ||
* [[Getting Started with QPR ProcessAnalyzer]] | * [[Getting Started with QPR ProcessAnalyzer]] | ||
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|Snowflake Native App]] | |||
* [[Introduction to Process Mining|Introduction to Process Mining]] | * [[Introduction to Process Mining|Introduction to Process Mining]] | ||
* [[Process_Mining_Concepts|Process Mining | * [[Process_Mining_Concepts|Process Mining Concepts]] | ||
* [[Log_in_QPR_ProcessAnalyzer|Log in QPR ProcessAnalyzer]] | |||
* [[Languages and Localization|Language and Localization Settings]] | * [[Languages and Localization|Language and Localization Settings]] | ||
* [[ | * [[User Settings|User Settings]] | ||
* [[ | * [[Navigation_Menu|Navigation Menu Functions]] | ||
</div> | </div> | ||
Line 21: | Line 23: | ||
=== Working with Dashboards === | === Working with Dashboards === | ||
* [[QPR_ProcessAnalyzer_Project_Workspace|Project Workspace]]: [[QPR_ProcessAnalyzer_Project_Workspace#Projects|Projects]], [[QPR_ProcessAnalyzer_Project_Workspace#Dashboards|Dashboards]], [[QPR_ProcessAnalyzer_Project_Workspace#Models|Models]], [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|Datatables]], [[Managing_Scripts|Scripts]], [[QPR_ProcessAnalyzer_Project_Workspace#Recycle_Bin|Recycle Bin]] | * [[QPR_ProcessAnalyzer_Project_Workspace|Project Workspace]]: [[QPR_ProcessAnalyzer_Project_Workspace#Projects|Projects]], [[QPR_ProcessAnalyzer_Project_Workspace#Dashboards|Dashboards]], [[QPR_ProcessAnalyzer_Project_Workspace#Models|Models]], [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|Datatables]], [[Managing_Scripts|Scripts]], [[QPR_ProcessAnalyzer_Project_Workspace#Recycle_Bin|Recycle Bin]] | ||
* [[Filtering_in_QPR_ProcessAnalyzer|Using Filters]] | * [[Filtering_in_QPR_ProcessAnalyzer|Using Filters]] | ||
* [[QPR ProcessAnalyzer Dashboard Designer|Creating Dashboards]] | * [[QPR ProcessAnalyzer Dashboard Designer|Creating Dashboards]] | ||
* [[AI Assistant for QPR ProcessAnalyzer|AI Assistant]] (powered by generative AI) | |||
* [[Dashboard Variables|Dynamic Variables in Dashboards]] | * [[Dashboard Variables|Dynamic Variables in Dashboards]] | ||
* [[Business Calendar|Business Calendar | * [[Business Calendar|Business Calendar to Calculate Durations]] | ||
* [[Best Practices for Designing Dashboards|Best Practices for Designing Dashboards]] | * [[Best Practices for Designing Dashboards|Best Practices for Designing Dashboards]] | ||
</div> | </div> | ||
Line 34: | Line 36: | ||
=== Analyses and Visualizations === | === Analyses and Visualizations === | ||
<div style="float:left; width:50%;"> | <div style="float:left; width:50%;"> | ||
* [[QPR ProcessAnalyzer Chart|Chart]] / [[ | * [[Process Flowchart|Process Flowchart]] | ||
** [[QPR ProcessAnalyzer Graphs| | * [[QPR ProcessAnalyzer Chart|Chart]] / [[Snowflake Chart|Snowflake Chart]] | ||
** [[QPR ProcessAnalyzer Graphs|Graphs]] | |||
** [[QPR_ProcessAnalyzer_Table|Table]] | ** [[QPR_ProcessAnalyzer_Table|Table]] | ||
** [[QPR_ProcessAnalyzer_Pivot_Table|Pivot Table]] | ** [[QPR_ProcessAnalyzer_Pivot_Table|Pivot Table]] | ||
Line 42: | Line 45: | ||
** [[Chart_On-screen_Settings|On-screen Settings]] | ** [[Chart_On-screen_Settings|On-screen Settings]] | ||
** [[Chart_Linked_Settings|Linked Settings]] | ** [[Chart_Linked_Settings|Linked Settings]] | ||
* [[ | ** [[Actions_to_Run_Script_in_Table|Run Script Actions]] | ||
</div> | </div> | ||
<div style="float:left; width:50%;"> | <div style="float:left; width:50%;"> | ||
* [[Root Causes|Root Causes Analysis]] | * [[Root Causes|Root Causes Analysis]] | ||
* [[Clustering Analysis|Clustering Analysis]] | |||
* [[Conformance Analysis|Conformance Analysis]] | * [[Conformance Analysis|Conformance Analysis]] | ||
* [[QPR ProcessAnalyzer BPMN Editor|BPMN Editor | * [[Design Diagram|Design Diagram]] / [[QPR ProcessAnalyzer BPMN Editor|BPMN Editor]] | ||
* [[Gantt_Chart|Gantt Chart]] | * [[Gantt_Chart|Gantt Chart]] | ||
* [[Sankey_Chart|Sankey Chart]] | * [[Sankey_Chart|Sankey Chart]] | ||
* [[Label and Link]] | |||
* [[Image|Image]] | |||
* [[Filter_Selectors|Filter Selectors]] / [[Dropdown_List_Selector|Dropdown List Selector]] | |||
</div> | </div> | ||
</div> | </div> | ||
Line 59: | Line 62: | ||
</div> | </div> | ||
== For Developers == | == For Citizen Developers == | ||
This section describes how to build ETL scripts that transform the source data into process mining models. There is also a detailed description how the process mining models can be configured so that they are optimal for the desired analyses. Finally, there is reference documentation for all expression language related functionality, that can be used both when writing custom KPI's in dashboards and in the ETL scripts. | |||
<div style="display: flex;flex-wrap: wrap;"> | <div style="display: flex;flex-wrap: wrap;"> | ||
<div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;"> | <div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;"> | ||
=== Expression Language === | === Expression Language Reference === | ||
* [[SQL_Expressions|SQL Expressions for Snowflake]] | * [[SQL_Expressions|SQL Expressions for Snowflake]] | ||
* In-memory expressions: [[QPR_ProcessAnalyzer_Expressions|Basic Syntax and Operations]] / [[Generic Functions in QPR ProcessAnalyzer|Generic Functions]] | * In-memory expressions: [[QPR_ProcessAnalyzer_Expressions|Basic Syntax and Operations]] / [[Generic Functions in QPR ProcessAnalyzer|Generic Functions]] | ||
* [[Generic_Objects_in_Expression_Language|Generic types]] ([[Generic_Properties_in_Expression_Language|Generic Properties]], [[Generic_Objects_in_Expression_Language#Array|Array]], [[Generic_Objects_in_Expression_Language#DateTime|DateTime]], [[Generic_Objects_in_Expression_Language#String|String]], [[Generic_Objects_in_Expression_Language#Timespan|Timespan]], [[Generic_Objects_in_Expression_Language#Dictionary|Dictionary]]) | * [[Generic_Objects_in_Expression_Language|Generic types]] ([[Generic_Properties_in_Expression_Language|Generic Properties]], [[Generic_Objects_in_Expression_Language#Array|Array]], [[Generic_Objects_in_Expression_Language#DateTime|DateTime]], [[Generic_Objects_in_Expression_Language#String|String]], [[Generic_Objects_in_Expression_Language#Timespan|Timespan]], [[Generic_Objects_in_Expression_Language#Dictionary|Dictionary]]) | ||
* [[Process_Mining_Objects_in_Expression_Language|In-memory models API]] ([[Process_Mining_Objects_in_Expression_Language#AttributeType|AttributeType]], [[Process_Mining_Objects_in_Expression_Language#Case|Case]], [[Process_Mining_Objects_in_Expression_Language#Event|Event]], [[Process_Mining_Objects_in_Expression_Language#EventLog|EventLog]], [[Process_Mining_Objects_in_Expression_Language#EventType|EventType]], [[Process_Mining_Objects_in_Expression_Language#Flow|Flow]], [[Process_Mining_Objects_in_Expression_Language#FlowOccurrence|FlowOccurrence]], [[Process_Mining_Objects_in_Expression_Language#Variation|Variation]]) | * [[Process_Mining_Objects_in_Expression_Language|In-memory models API]] ([[Process_Mining_Objects_in_Expression_Language#AttributeType|AttributeType]], [[Process_Mining_Objects_in_Expression_Language#Case|Case]], [[Process_Mining_Objects_in_Expression_Language#Event|Event]], [[Process_Mining_Objects_in_Expression_Language#EventLog|EventLog]], [[Process_Mining_Objects_in_Expression_Language#EventType|EventType]], [[Process_Mining_Objects_in_Expression_Language#Flow|Flow]], [[Process_Mining_Objects_in_Expression_Language#FlowOccurrence|FlowOccurrence]], [[Process_Mining_Objects_in_Expression_Language#Variation|Variation]]) | ||
* Configuration objects ([[Datatable_in_Expression_Language|Datatable]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model|Model]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Filter]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|Script]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project|Project]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|User/Group]]) | * Configuration objects ([[Dashboard_in_Expression_Language|Dashboard]], [[Datatable_in_Expression_Language|Datatable]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Model|Model]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Filter]], [[Diagram_in_Expression_Language|Diagram]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Script|Script]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project|Project]], [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|User/Group]]) | ||
* Tabular data | * Tabular data ([[DataFrame in Expression Language|DataFrame]], [[SqlDataFrame in Expression Language|SqlDataFrame]], [[DataFlow_in_Expression_Language|DataFlow]]) | ||
* [[Machine_Learning_Functions_in_Expression_Language|Machine Learning API]] / [[Conformance_Checking|Conformance Checking]] | * [[Machine_Learning_Functions_in_Expression_Language|Machine Learning API]] / [[Conformance_Checking|Conformance Checking]] | ||
* [[Filtering_in_QPR_ProcessAnalyzer_Queries| | * [[Filtering_in_QPR_ProcessAnalyzer_Queries|Filter Rules JSON]] | ||
</div> | </div> | ||
<div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;"> | <div style="flex: 1 0 250px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;"> | ||
=== | === Create Process Mining Models === | ||
* [[Creating Process Mining Model|Creating Process Mining Model]] | * [[Creating Process Mining Model|Walkthrough: Creating Process Mining Model]] | ||
* [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|Importing Data from CSV, XES and PACM files]] | * [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|Importing Data from CSV, XES and PACM files]] | ||
* [[Object-centric_Process_Mining_Model|Object-centric Process Mining]] | |||
* [[Calculated Attributes in QPR ProcessAnalyzer|Calculated Case and Event Attributes]] | * [[Calculated Attributes in QPR ProcessAnalyzer|Calculated Case and Event Attributes]] | ||
* [[Email Notifications|Email Notifications]] | * [[Email Notifications|Email Notifications]] | ||
* [[QPR ProcessAnalyzer Model Datasources|Model datasources]] ([[QPR ProcessAnalyzer Model Datasources#Loading Data from Datatables|Datatable]], [[QPR ProcessAnalyzer Model Datasources#Loading Script|Loading Script]], [[QPR ProcessAnalyzer Model Datasources#ODBC_Datasource|ODBC]]) | * [[QPR ProcessAnalyzer Model Datasources|Model datasources]] ([[QPR ProcessAnalyzer Model Datasources#Loading Data from Datatables|Datatable]], [[QPR ProcessAnalyzer Model Datasources#Loading Script|Loading Script]], [[QPR ProcessAnalyzer Model Datasources#ODBC_Datasource|ODBC]]) | ||
* [[Case Level Permissions|Case Level Permissions]] | * [[Case Level Permissions|Case Level Permissions]] | ||
* [[Automatic Model Loading on Server Startup|Keeping Models Always Available]] | * [[Automatic Model Loading on Server Startup|Keeping Models Always Available]] | ||
* [[Event Ordering for Identical Timestamps|Event Ordering for Identical Timestamps]] | * [[Event Ordering for Identical Timestamps|Event Ordering for Identical Timestamps]] | ||
* [[Managing Time Zones and Local Time|Time Zones and Local Time]] | * [[Managing Time Zones and Local Time|Time Zones and Local Time]] | ||
* [[Best_Practices_for_Designing_Models|Best Practices for Designing Models]] | |||
* [[Create_Predicted_Eventlog|Create Predicted Eventlog]] | |||
</div> | </div> | ||
Line 95: | Line 99: | ||
=== Data Integrations and Connectors === | === Data Integrations and Connectors === | ||
* [[Managing Scripts|Managing Scripts in Workspace]] | * [[Managing Scripts|Managing Scripts in Workspace]] | ||
* [[Datatable_Properties_Dialog|Managing Datatables in Workspace]] | |||
* [[SQL Scripting for ETL|Writing SQL Scripts]] | * [[SQL Scripting for ETL|Writing SQL Scripts]] | ||
* [[SQL Scripting Commands|SQL Scripting Commands Reference]] | * [[SQL Scripting Commands|SQL Scripting Commands Reference]] | ||
* [[ | * [[Storing Secrets for Scripts|Storing Secrets]] | ||
* [[QPR ProcessAnalyzer ScriptLauncher|Installing and using QPR ScriptLauncher]] | * [[QPR ProcessAnalyzer ScriptLauncher|Installing and using QPR ScriptLauncher]] | ||
* [[Importing_Data_from_SAP|How to Import Data from SAP]] | * [[Importing_Data_from_SAP|How to Import Data from SAP]] | ||
* [[Anonymize data|Anonymize data]] | |||
* [[Expression Script Examples|Expression Script Examples]] | * [[Expression Script Examples|Expression Script Examples]] | ||
* [[QPR ProcessAnalyzer API|QPR ProcessAnalyzer REST API]] | * [[QPR ProcessAnalyzer API|QPR ProcessAnalyzer REST API]] | ||
* [[Sample Eventlog Files|Sample Eventlogs]] | * [[Sample Eventlog Files|Sample Eventlogs]] | ||
* [[QPR TaskRecorder]] | |||
</div> | </div> | ||
</div> | </div> | ||
== For System Administrators == | == For System Administrators == | ||
QPR ProcessAnalyzer | This section starts with the planning of QPR ProcessAnalyzer installation. After all requirements have been fulfilled, you can continue with the installation and configuration of QPR ProcessAnalyzer. Finally, learn how to manage users and perform other administrative tasks. | ||
<div style="display: flex;flex-wrap: wrap;"> | <div style="display: flex;flex-wrap: wrap;"> | ||
Line 117: | Line 124: | ||
* [[QPR ProcessAnalyzer Release Notes|QPR ProcessAnalyzer Release Notes]] | * [[QPR ProcessAnalyzer Release Notes|QPR ProcessAnalyzer Release Notes]] | ||
* [[QPR_TaskRecorder_Release_Notes|QPR TaskRecorder Release Notes]] | * [[QPR_TaskRecorder_Release_Notes|QPR TaskRecorder Release Notes]] | ||
* [[QPR_ProcessAnalyzer_Downloads|Downloads Page]] | |||
</div> | </div> | ||
Line 127: | Line 135: | ||
* [[SAML_2.0_Federated_Authentication|SAML 2.0 Authentication]] | * [[SAML_2.0_Federated_Authentication|SAML 2.0 Authentication]] | ||
* [[QPR ProcessAnalyzer Security Hardening|Security Hardening]] | * [[QPR ProcessAnalyzer Security Hardening|Security Hardening]] | ||
* [[Activate_QPR_ProcessAnalyzer_using_ActivationUtility| | * [[Activate_QPR_ProcessAnalyzer_using_ActivationUtility|Activation without Internet Connection]] | ||
</div> | </div> | ||
Line 133: | Line 141: | ||
=== Administrating System === | === Administrating System === | ||
* [[Roles and Permissions|User Permissions | * [[Roles and Permissions|User Roles and Permissions]] | ||
* [[Manage Users and Groups| | * [[Manage Users and Groups|Managing Users]] | ||
* [[PA_Configuration_database_table| | * [[PA_Configuration_database_table|System Configurations]] | ||
* [[QPR ProcessAnalyzer Logs|Logs for Audit | * [[QPR ProcessAnalyzer Logs|Logs for Audit and Troubleshooting]] | ||
* [[ | * [[In-memory_Models_Management|In-memory Models Management]] | ||
</div> | </div> | ||
</div> | </div> |
Latest revision as of 07:53, 3 October 2024
Welcome to QPR ProcessAnalyzer Wiki! QPR ProcessAnalyzer is a software for turning event and transactional data into visual process analysis and intelligence. Topics in this documentation are divided based on user roles for process analysts, developers and administrators.
For Process Analysts
This section contains information how to get started with QPR ProcessAnalyzer and how to create your first dashboards! This section also describes how to use filters and how to make different kinds of analyses with QPR ProcessAnalyzer.
Getting Started
Working with Dashboards
Analyses and Visualizations
For Citizen Developers
This section describes how to build ETL scripts that transform the source data into process mining models. There is also a detailed description how the process mining models can be configured so that they are optimal for the desired analyses. Finally, there is reference documentation for all expression language related functionality, that can be used both when writing custom KPI's in dashboards and in the ETL scripts.
Expression Language Reference
- SQL Expressions for Snowflake
- In-memory expressions: Basic Syntax and Operations / Generic Functions
- Generic types (Generic Properties, Array, DateTime, String, Timespan, Dictionary)
- In-memory models API (AttributeType, Case, Event, EventLog, EventType, Flow, FlowOccurrence, Variation)
- Configuration objects (Dashboard, Datatable, Model, Filter, Diagram, Script, Project, User/Group)
- Tabular data (DataFrame, SqlDataFrame, DataFlow)
- Machine Learning API / Conformance Checking
- Filter Rules JSON
Create Process Mining Models
- Walkthrough: Creating Process Mining Model
- Importing Data from CSV, XES and PACM files
- Object-centric Process Mining
- Calculated Case and Event Attributes
- Email Notifications
- Model datasources (Datatable, Loading Script, ODBC)
- Case Level Permissions
- Keeping Models Always Available
- Event Ordering for Identical Timestamps
- Time Zones and Local Time
- Best Practices for Designing Models
- Create Predicted Eventlog
Data Integrations and Connectors
- Managing Scripts in Workspace
- Managing Datatables in Workspace
- Writing SQL Scripts
- SQL Scripting Commands Reference
- Storing Secrets
- Installing and using QPR ScriptLauncher
- How to Import Data from SAP
- Anonymize data
- Expression Script Examples
- QPR ProcessAnalyzer REST API
- Sample Eventlogs
- QPR TaskRecorder
For System Administrators
This section starts with the planning of QPR ProcessAnalyzer installation. After all requirements have been fulfilled, you can continue with the installation and configuration of QPR ProcessAnalyzer. Finally, learn how to manage users and perform other administrative tasks.
Planning Installation
Installing and Configuring
Agreements
See the QPR End User Software License Agreement and QPR Software as a Service Agreement.