Sample Eventlog Files: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
 
(42 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Sample files contain case and event data that can be used for demo purposes.  
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 ==
* Excel sample files:  
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_OrderToCash.xlsx Dynamics_OrderToCash.xlsx]  
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/Dynamics_ProcureToPay.xlsx Dynamics_ProcureToPay.xlsx]
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/Epicor_OrderToCash.xlsx Epicor_OrderToCash.xlsx]
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/Healthcare_Patient_Journey.xlsx Healthcare_Patient_Journey.xlsx]
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/LoanApproval.xlsx LoanApproval.xlsx]
* 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]
** [http://files.qpr.com/releases/PASampleFiles/excel/O2C_Manufacturing.xlsx O2C_Manufacturing.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash.xlsx SAP_OrderToCash.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_10K.xlsx SAP_OrderToCash_10K.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_Extended.xlsx SAP_OrderToCash_Extended.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_OrderToCash_v2.xlsx SAP_OrderToCash_v2.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay.xlsx SAP_PurchaseToPay.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/SAP_PurchaseToPay_v2.xlsx SAP_PurchaseToPay_v2.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceNow_IncidentManagement.xlsx ServiceNow_IncidentManagement.xlsx]
** [http://files.qpr.com/releases/PASampleFiles/excel/ServiceTicket.xlsx ServiceTicket.xlsx]


== PACM Files ==
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_OrderToCash.pacm Dynamics_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_ProcureToPay.pacm Dynamics_ProcureToPay.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Epicor_OrderToCash.pacm Epicor_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/Healthcare_Patient_Journey.pacm Healthcare_Patient_Journey.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/O2C_Manufacturing.pacm O2C_Manufacturing.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash.pacm SAP_OrderToCash.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_10K.pacm SAP_OrderToCash_10K.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_Extended.pacm SAP_OrderToCash_Extended.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_v2.pacm SAP_OrderToCash_v2.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay.pacm SAP_PurchaseToPay.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay_v2.pacm SAP_PurchaseToPay_v2.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceNow_IncidentManagement.pacm ServiceNow_IncidentManagement.pacm]
* [https://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]


* PACM sample files:
== XES Files ==
** [http://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_OrderToCash.pacm Dynamics_OrderToCash.pacm]
* 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].
** [http://files.qpr.com/releases/PASampleFiles/pacm/Dynamics_ProcureToPay.pacm Dynamics_ProcureToPay.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/Epicor_OrderToCash.pacm Epicor_OrderToCash.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/Healthcare_Patient_Journey.pacm Healthcare_Patient_Journey.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/LoanApproval.pacm LoanApproval.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/O2C_Manufacturing.pacm O2C_Manufacturing.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash.pacm SAP_OrderToCash.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_10K.pacm SAP_OrderToCash_10K.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_Extended.pacm SAP_OrderToCash_Extended.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_OrderToCash_v2.pacm SAP_OrderToCash_v2.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay.pacm SAP_PurchaseToPay.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/SAP_PurchaseToPay_v2.pacm SAP_PurchaseToPay_v2.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/ServiceNow_IncidentManagement.pacm ServiceNow_IncidentManagement.pacm]
** [http://files.qpr.com/releases/PASampleFiles/pacm/ServiceTicket.pacm ServiceTicket.pacm]


 
== OCEL 2.0 Files ==
* CSV sample files:
Example OCEL 2.0 eventlogs: https://www.ocel-standard.org/event-logs/overview/ (download the json format supported by QPR ProcessAnalyzer)
**  '''(WORK IN PROGRESS)''' Dynamics_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_OrderToCash_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' Dynamics_ProcureToPay model: [http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_ProcureToPay_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/Dynamics_ProcureToPay_CaseAttributes.csv Case Attributes]
** Epicor_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/Epicor_OrderToCash_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/Epicor_OrderToCash_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' Healthcare_Patient_Journey_Events model: [http://files.qpr.com/releases/PASampleFiles/csv/Healthcare_Patient_Journey_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/Healthcare_Patient_Journey_CaseAttributes.csv Case Attributes]
**  LoanApproval model: [http://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/LoanApproval_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' O2C_Manufacturing model: [http://files.qpr.com/releases/PASampleFiles/csv/O2C_Manufacturing_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/O2C_Manufacturing_CaseAttribues.csv Case Attributes]
**  SAP_OrderToCash model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and  [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_10K model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_10K_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_Extended model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_Extended_CaseAttributes.csv Case Attributes]
**  SAP_OrderToCash_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_Events.csv Event Data] (event date format: d.M.yyyy H\:mm) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_OrderToCash_v2_CaseAttributes.csv Case Attributes]
**  SAP_PurchaseToPay model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_Events.csv Event Data] (event date format: d.M.yyyy H\:mm\:ss) and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' SAP_PurchaseToPay_v2 model: [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/SAP_PurchaseToPay_v2_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' ServiceNow_IncidentManagement model: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceNow_IncidentManagement_CaseAttributes.csv Case Attributes]
**  '''(WORK IN PROGRESS)''' ServiceTicket model: [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_Events.csv Event Data] and [http://files.qpr.com/releases/PASampleFiles/csv/ServiceTicket_CaseAttributes.csv Case Attributes]
 
== Creating Model from Excel Sample Files ==
#To load events to QPR ProcessAnalyzer, select the worksheet that contains Event Data.
#On the QPR tab, select '''Project Workspace'''.
#Click the '''Import...''' button.
#The Import Wizard opens. Select '''Events''' to be imported and click '''Next'''.
#Select '''Current Worksheet''' and click '''Next'''.
#Select '''Create New''' and from the '''Project''' drop-down menu, select either "Create New Project" or choose an existing project.
#In '''Model Name''', type in a name for the model and click '''Import'''.
#Next, the case data will be imported to the model. Select the Excel worksheet that contains Case Attribute Data.
#On the QPR tab, click '''Project Workspace'''.
#In the Workspace dialog, click the '''Import...''' button.
#The Import Wizard opens. Select '''Case Attributes''' to be imported and click '''Next'''.
#Select '''Current Worksheet''' and click '''Next'''.
#Select '''Add to Existing''' and select the model for which you gave the name earlier.
#Click '''Import'''.
#The resulting model will now have Events and Case Data. In the '''Project Workspace''' dialog, select the model and click '''Open'''.

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"