QPR ProcessAnalyzer Wiki: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
(Added system library link)
 
(612 intermediate revisions by 5 users not shown)
Line 1: Line 1:
== Introduction ==
<div class="downloadButton" style="width:190px;float:right;margin: 3px 12px 0px 15px;">[[Online_Learning_Platform|Online Learning<br />Platform]]</div>
This wiki contains documentation for QPR ProcessAnalyzer - the tool for turning event data into visual process intelligence. Read [[What is QPR ProcessAnalyzer]] for an introduction of the tool. If you are new to process mining, you can start by learning about [[Process Mining Concept| concepts of process mining]].


== Analysts ==
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.
QPR ProcessAnalyzer is used via web browser. In QPR ProcessAnalyzer application you can perform various analyses on your process model. If you prefer standalone installation, you can use excel client for analyses.


<table style="width:100%; display: table;border-spacing: 10px;">
<div style="height:5px;"></div>
<tr>
== For Process Analysts ==
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:33%; min-width: 200px;display: table-cell; vertical-align:top;">
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.
=== Using ProcessAnalyzer ===
 
<div style="align:left; font-size:1em; float:left; width:100%;">
<div style="display: flex;flex-wrap: wrap;">
* [[QPR ProcessAnalyzer Presentation Object (PAPO)|QPR ProcessAnalyzer UI]]
<div style="flex: 1 0 210px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
=== Getting Started ===
* [[Getting Started with QPR ProcessAnalyzer]]
* [[QPR_ProcessAnalyzer_Native_App_in_Snowflake|Snowflake Native App]]
* [[Introduction to Process Mining|Introduction to Process Mining]]
* [[Process_Mining_Concepts|Process Mining Concepts]]
* [[Log_in_QPR_ProcessAnalyzer|Log in QPR ProcessAnalyzer]]
* [[Languages and Localization|Language and Localization Settings]]
* [[User Settings|User Settings]]
* [[Navigation_Menu|Navigation Menu Functions]]
</div>
</div>
</td>
 
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:33%; min-width: 200px;display: table-cell; vertical-align:top;">
<div style="flex: 1 0 210px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
=== Available analyses ===
 
<div style="align:left; font-size:1em; float:left; width:40%;">
=== Working with Dashboards ===
* [[Case_Analysis (PAPO)|Case Analysis]]
* [[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]]
* [[Duration_Analysis (PAPO)|Duration Analysis]]
* [[Filtering_in_QPR_ProcessAnalyzer|Using Filters]]
* [[Event_Analysis (PAPO)|Event Analysis]]
* [[QPR ProcessAnalyzer Dashboard Designer|Creating Dashboards]]
* [[Event_Type_Analysis (PAPO)|Event Type Analysis]]
* [[AI Assistant for QPR ProcessAnalyzer|AI Assistant]] (powered by generative AI)
* [[Flowchart_Analysis (PAPO)|Flowchart Analysis]]
* [[Dashboard Variables|Dynamic Variables in Dashboards]]
* [[Business Calendar|Business Calendar to Calculate Durations]]
* [[Best Practices for Designing Dashboards|Best Practices for Designing Dashboards]]
</div>
</div>
<div style="align:left; font-size:1em; float:left; width:60%;">
 
* [[Flowchart_Influence_Analysis (PAPO)|Flowchart Influence Analysis]]
<div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
* [[Influence_Analysis_for_Case_Attributes (PAPO)|Influence Analysis for Case Attributes]]
 
* [[KPI Analysis]]
=== Analyses and Visualizations ===
* [[Profiling_Analysis (PAPO)|Profiling Analysis]]
<div style="float:left; width:50%;">
* [[Variation_Analysis (PAPO)|Variation Analysis]]
* [[Process Flowchart|Process Flowchart]]
* [[Object-Centric_Flowchart|Object-Centric Flowchart]]
* [[QPR ProcessAnalyzer Chart|Chart]] / [[Snowflake Chart|Snowflake Chart]]
** [[QPR ProcessAnalyzer Graphs|Graphs]]
** [[QPR_ProcessAnalyzer_Table|Table]]
** [[QPR_ProcessAnalyzer_Pivot_Table|Pivot Table]]
** [[QPR_ProcessAnalyzer_KPI_Card|KPI Card]]
** [[Measure,_Dimension_and_Column_Settings|Measure Settings]]
** [[Chart_On-screen_Settings|On-screen Settings]]
** [[Chart_Linked_Settings|Linked Settings]]
** [[Actions_to_Run_Script_in_Table|Run Script Actions]]
</div>
<div style="float:left; width:50%;">
* [[Root Causes|Root Causes Analysis]]
* [[Clustering Analysis|Clustering Analysis]]
* [[Conformance Analysis|Conformance Analysis]]
* [[Design Diagram|Design Diagram]] / [[QPR ProcessAnalyzer BPMN Editor|BPMN Editor]]
* [[Gantt_Chart|Gantt Chart]]
* [[Sankey_Chart|Sankey Chart]]
* [[Label and Link]]
* [[Image|Image]]
* [[Filter_Selectors|Filter Selectors]] / [[Dropdown_List_Selector|Dropdown List Selector]]
</div>
</div>
</td>
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:33%; min-width: 200px;display: table-cell; vertical-align:top;">
=== Excel client ===
<div style="align:left; font-size:1em; float:left; width:100%;">
* [[QPR ProcessAnalyzer Excel Client|QPR ProcessAnalyzer Excel Client]]
* [[Installing QPR ProcessAnalyzer|Install QPR ProcessAnalyzer Excel client]]
</div>
</div>
</td>
</tr>
</table>


== Developers ==
</div>
To create QPR ProcessAnalyzer models, you need to Extract data from source system(s), transform data to a format compatible with QPR ProcessAnalyzer and finally load data as process model(s). To perform these tasks, you can use T-SQL and QPR ProcessAnalyzer scripting commands. When you have created a model, end-users can analyze it easily by using QPR UI’s ProcessAnalyzer application. If needed, there are plenty of tools to customize the end-user experience in QPR UI.


<table style="width:100%; display: table;border-spacing: 10px;">
== For Citizen Developers ==
<tr>
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.
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:25%; display: table-cell; vertical-align:top;">
 
=== Manage Environment ===
<div style="display: flex;flex-wrap: wrap;">
<div style="align:left; font-size:1em; float:left; width:100%;">
<div style="flex: 1 0 370px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
* [[Get Started with QPR ProcessAnalyzer Excel Client|Get Started]]
=== Expression Language Reference ===
* [[User Roles and Permissions in QPR ProcessAnalyzer|Permissions and Security Roles]]  
* [[SQL_Expressions|SQL Expressions for Snowflake]]
* [[Manage Users in QPR ProcessAnalyzer Excel Client|Manage Users in Excel Client]]
* In-memory expressions: [[QPR_ProcessAnalyzer_Expressions|Basic Syntax and Operations]] / [[Generic Functions in QPR ProcessAnalyzer|Generic Functions]]
* [[Project Workspace in QPR ProcessAnalyzer Excel Client|Manage Projects, Models and Data Tables in Excel Client]]
* [[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]])
* [[QPR ProcessAnalyzer Logs|Logging]]
* [[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 ([[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 ([[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]]
* [[Filtering_in_QPR_ProcessAnalyzer_Queries|Filter Rules JSON]]
* [[System Library]]
</div>
</div>
</td>
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:25%; display: table-cell; vertical-align:top;">


=== Working with model data ===
<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="align:left; font-size:1em; float:left; width:100%;">
 
* [[QPR ProcessAnalyzer Model JSON Settings|Model Settings]]
=== Create Process Mining Models ===
* [[QPR_ProcessAnalyzer_Expressions|Expression language overview]]
* [[Creating Process Mining Model|Walkthrough: Creating Process Mining Model]]
* [[Generic Properties and Functions in QPR ProcessAnalyzer Expressions|Generic expression functions]]
* [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|Importing Data from CSV, XES and PACM files]]
* [[Object Specific Properties and Functions in QPR ProcessAnalyzer Expressions|Object specific expression functions]]
* [[Object-centric_Process_Mining_Model|Object-centric Process Mining]]
* [[QPR ProcessAnalyzer KPI Analysis|Expression Analysis]]
* [[Event Ordering for Identical Timestamps|Event Ordering for Identical Timestamps]]
* [[Filtering_in_QPR_ProcessAnalyzer_Queries|Filtering in Data Queries]]
* [[Managing Time Zones and Local Time|Time Zones and Local Time]]
* [[Conformance_Checking_in_QPR_ProcessAnalyzer|Conformance Checking using BPMN]]
* [[Best_Practices_for_Designing_Models|Best Practices for Designing Models]]
* [[Open R in QPR ProcessAnalyzer|Analytics using Open R]]
* [[Create_Predicted_Eventlog|Create Predicted Eventlog]]
* [[Create Simulated Eventlog]]
==== For In-memory Models ====
* [[Calculated Attributes in QPR ProcessAnalyzer|Calculated Case and Event Attributes]]
* [[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]])
* [[Case Level Permissions|Case Level Permissions]]
* [[Automatic Model Loading on Server Startup|Keeping Models Always Available]]
</div>
</div>
</td>
<td style="border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:25%; display: table-cell; vertical-align:top;">


=== Integrating with Data ===
<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="align:left; font-size:1em; float:left; width:100%;">
 
* [[Data Extraction, Transformation, and Loading|Concept of ETL]]
=== Data Integrations and Connectors ===
* [[Manage Scripts in QPR ProcessAnalyzer Excel Client|Manage Scripts]]
* [[Managing Scripts|Managing Scripts in Workspace]]
* [[QPR ProcessAnalyzer Scripting Commands|Scripting commands]]
* [[Datatable_Properties_Dialog|Managing Datatables in Workspace]]
* [[QPR_ProcessAnalyzer_Model_JSON_Settings#Model_Datasources|ODBC datasources]]
* [[SQL Scripting for ETL|Writing SQL Scripts]]
* [[HTML Presentation Object: QPR ProcessAnalyzer CSV Data Import|CSV Data Import into QPR ProcessAnalyzer]]
* [[SQL Scripting Commands|SQL Scripting Commands Reference]]
* [[QPR ProcessAnalyzer Web Service API|Web API]]
* [[Storing Secrets for Scripts|Storing Secrets]]
* [[QPR ProcessAnalyzer ScriptLauncher|Installing and using QPR ScriptLauncher]]
* [[Importing_Data_from_SAP|How to Import Data from SAP]]
* [[Anonymize data|Anonymize data]]
* [[Expression Script Examples|Expression Script Examples]]
* [[QPR ProcessAnalyzer API|QPR ProcessAnalyzer REST API]]
* [[Sample Eventlog Files|Sample Eventlogs]]
* [[QPR TaskRecorder]]
</div>
</div>
</div>


</td>
== For System Administrators ==
<td style="border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:25%; display: table-cell; vertical-align:top;">
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.


=== Tutorials ===
<div style="display: flex;flex-wrap: wrap;">
<div style="align:left; font-size:1em; float:left; width:100%;">
<div style="flex: 1 0 290px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
* [[QPR ProcessAnalyzer ETL Tutorial | ETL Tutorial]]
=== Planning Installation ===
* [[QPR ProcessAnalyzer Certification]]
* [[QPR ProcessAnalyzer System Requirements|System Requirements]]
* [[Media:QPR_ProcessAnalyzer_training.pdf|QPR ProcessAnalyzer training material]]
* [[QPR ProcessAnalyzer System Architecture|System Architecture]]
* [[User Session Management|User Session Management]]
* [[QPR ProcessAnalyzer Release Notes|QPR ProcessAnalyzer Release Notes]]
* [[QPR_TaskRecorder_Release_Notes|QPR TaskRecorder Release Notes]]
* [[QPR_ProcessAnalyzer_Downloads|Downloads Page]]
</div>
</div>
</td>
</tr>
</table>


== Installation ==
<div style="flex: 1 0 290px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
QPR ProcessAnalyzer installation requires installing a server component and two databases. It is recommended to install also QPR UI server to fully utilize the power of QPR ProcessAnalyzer. With QPR UI installed, QPR ProcessAnalyzer can be used via web browser for analyzing process models and analyzer users do not need any additional software installed on their workstations. Developer users need also to have QPR ProcessAnalyzer Excel client installed.


<table style="width:100%; display: table;border-spacing: 10px;">
=== Installing and Configuring ===
<tr>
* [[Installing QPR ProcessAnalyzer Server|Install QPR ProcessAnalyzer Server]] (or [[Updating_QPR_ProcessAnalyzer_Server|update existing]])
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:50%; display: table-cell; vertical-align:top;">
* [[Snowflake_Connection_Configuration|Configure Snowflake Connection]]
=== Installing ProcessAnalyzer ===
* [[Setting_up_Scripting_Sandbox|Setting up SQL Scripting Sandbox]]
<div style="align:left; font-size:1em; float:left; width:100%;">
* [[SAML_2.0_Federated_Authentication|SAML 2.0 Authentication]]
* [[Installing QPR ProcessAnalyzer Server|New installation for QPR ProcessAnalyzer server]]
* [[QPR ProcessAnalyzer Security Hardening|Security Hardening]]
* [[Installing_QPR_ProcessAnalyzer_Server#Updating_QPR_ProcessAnalyzer_Server_to_Newer_Version|Update QPR ProcessAnalyzer Server to newer version]]
* [[Activate_QPR_ProcessAnalyzer_using_ActivationUtility|Activation without Internet Connection]]
* [[Installing QPR ProcessAnalyzer|Installing and upgrading QPR ProcessAnalyzer Excel client]]
</div>
</div>
</td>
<td style="word-wrap: break-word; border:1px solid #dfdfdf; padding:0 1em 1em 1em; align:left; font-size:1em; background-color:#F8F8FF; width:50%; display: table-cell; vertical-align:top;">


=== Installing QPR UI ===
<div style="flex: 1 0 290px;border:1px solid #dfdfdf;padding:0 1em 1em 1.5em;background-color:#F7FAFC;margin:10px 0px 0px 10px;">
<div style="align:left; font-size:1em; float:left; width:100%;">
 
* [[QPR UI Installation Checklist|Installing and upgrading QPR UI]]
=== Administrating System ===
* [[Roles and Permissions|User Roles and Permissions]]
* [[Manage Users and Groups|Managing Users]]
* [[PA_Configuration_database_table|System Configurations]]
* [[QPR ProcessAnalyzer Logs|Logs for Audit and Troubleshooting]]
* [[In-memory_Models_Management|In-memory Models Management]]
</div>
</div>
</div>
</td>
</tr>
</table>


== [[QPR End User Software License Agreement|Agreements]] ==
== Agreements ==
See the [[QPR End User Software License Agreement]] and [[QPR Software as a Service Agreement]].
See the [[QPR End User Software License Agreement]] and [[QPR Software as a Service Agreement]].


__NOTOC__
__NOTOC__

Latest revision as of 13:42, 19 November 2024

Online Learning
Platform

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.

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.

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.

Agreements

See the QPR End User Software License Agreement and QPR Software as a Service Agreement.


Retrieved from "https://wiki.onqpr.com/pa/index.php?title=QPR_ProcessAnalyzer_Wiki&oldid=25475"