Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
(74 intermediate revisions by 4 users not shown)
Line 1: Line 1:
QPR ProcessAnalyzer Excel Client comes with a library of sample files in Excel format containing cases and events data, which can be loaded as QPR ProcessAnalyzer models. Sample files are stored in the '''C:\ProgramData\QPR Software\QPR ProcessAnalyzer\201X.X\Samples''' folder in computer having QPR ProcessAnalyzer Excel Client.
These files contain sample datasets that can be directly imported to QPR ProcessAnalyzer, and they can be used for learning and demo purposes. There are two tabular datasets needed to create a process mining model: event data (eventlog) and case attributes. When using CSV files, these two datasets need to be imported from separate files. When using PACM or XES formats, the single file contains both the events and case attributes data. See how to [[Exporting_and_Importing_Data_in_QPR_ProcessAnalyzer|import CSV, PACM and XES files]] to QPR ProcessAnalyzer.


== Accessing Sample Files ==
== CSV Files ==
# Log in to QPR ProcessAnalyzer.
*  SAP Order-to-cash: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_CaseAttributes.csv Case Attributes]
# To access the sample data files, go to the QPR tab, click the '''Help''' button in the ribbon and select '''Sample Files'''.
*  SAP purchase-to-pay: [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_CaseAttributes.csv Case Attributes]
# Open the file that you want to use.
*  Loan approval: [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_CaseAttributes.csv Case Attributes]
*  ServiceNow incident management: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
*  Service tickets: [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
*  Order-to-cash (900k cases / 92k events): [https://files.qpr.com/releases/PASampleFiles/csv/OTC_Events_900k.csv Event Data] and [https://files.qpr.com/releases/PASampleFiles/csv/OTC_Cases_92k.csv Case Attributes]


== Creating Model from Sample Files ==
== PACM Files ==  
#To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_OrderToCash.pacm Dynamics_OrderToCash.pacm]
#On the QPR tab, select '''Project Workspace'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_ProcureToPay.pacm Dynamics_ProcureToPay.pacm]
#Click the '''Import...''' button.
* [https://files.qpr.com/releases/PASampleFiles/pacm/Epicor_OrderToCash.pacm Epicor_OrderToCash.pacm]
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/Healthcare_Patient_Journey.pacm Healthcare_Patient_Journey.pacm]
#Select '''Current Worksheet''' and click '''Next'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
#Select '''Create New''' and from the '''Project''' drop-down menu, select either "Create New Project" or choose an existing project.
* [https://files.qpr.com/releases/PASampleFiles/pacm/O2C_Manufacturing.pacm O2C_Manufacturing.pacm]
#In '''Model Name''', type in a name for the model and click '''Import'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash.pacm SAP_OrderToCash.pacm]
#Next, the case data will be imported to the model. Select the Excel worksheet that contains Case Attribute Data.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_10K.pacm SAP_OrderToCash_10K.pacm]
#On the QPR tab, click '''Project Workspace'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_Extended.pacm SAP_OrderToCash_Extended.pacm]
#In the Workspace dialog, click the '''Import...''' button.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_v2.pacm SAP_OrderToCash_v2.pacm]
#The Import Wizard opens. Select '''Case Attributes''' to be imported and click '''Next'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay.pacm SAP_PurchaseToPay.pacm]
#Select '''Current Worksheet''' and click '''Next'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay_v2.pacm SAP_PurchaseToPay_v2.pacm]
#Select '''Add to Existing''' and select the model for which you gave the name earlier.
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceNow_IncidentManagement.pacm ServiceNow_IncidentManagement.pacm]
#Click '''Import'''.
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]
#The resulting model will now have Events and Case Data. In the '''Project Workspace''' dialog, select the model and click '''Open'''.
 
== XES Files ==
* Real-life eventlogs in XES format can be found in [https://www.tf-pm.org/resources/xes-standard/about-xes/event-logs IEEE Task Force on Process Mining repository].
 
== OCEL 2.0 Files ==
Example OCEL 2.0 eventlogs: https://www.ocel-standard.org/event-logs/overview/ (download the json format supported by QPR ProcessAnalyzer)

Latest revision as of 09:09, 14 October 2024

These files contain sample datasets that can be directly imported to QPR ProcessAnalyzer, and they can be used for learning and demo purposes. There are two tabular datasets needed to create a process mining model: event data (eventlog) and case attributes. When using CSV files, these two datasets need to be imported from separate files. When using PACM or XES formats, the single file contains both the events and case attributes data. See how to import CSV, PACM and XES files to QPR ProcessAnalyzer.

CSV Files

PACM Files

XES Files

OCEL 2.0 Files

Example OCEL 2.0 eventlogs: https://www.ocel-standard.org/event-logs/overview/ (download the json format supported by QPR ProcessAnalyzer)

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