Data Format
Data Format
The ValueData Miner requires data in the form of an event log. There must be a table with the following data:
- CaseID: Each event must be assigned to a case. Therefore each event needs a unique identification number. For an online store, for example, this would be the order number or invoice number. All associated events then have the identification number entered in the 'CaseID' column.
- ActivityName: The individual process steps (activities) must be given a uniform name. Examples of activities for an online store would be 'payment received' or 'order dispatched'.
- Timestamp: Each event must be provided with a timestamp.
Example of an event log:
|
CaseID |
ActivityName |
TimeStamp |
|
1001 |
order_receive |
12:00 am |
|
1001 |
order_payment_complete |
12:01 am |
|
1001 |
order_ship |
12:45 am |
|
1001 |
order_complete |
6:00 pm |
|
1002 |
order_receive |
10:00 am |
|
1002 |
order_payment_complete |
1:15 pm |
|
1002 |
order_ship |
1:50 pm |
|
1003 |
order_receive |
3:00 pm |
|
1003 |
order_cancel |
3:05 pm |
Data formats: CaseID and ActivityName must be as string, Timestamp as Date String.
These three columns must be contained in one table. The table can also contain other columns, the ValueData miner does not consider them. The columns may also be named differently. The only important thing is the correct assignment in the data view of the ValueData Miner (see screenshot). Make sure to change the timestamp format from 'Date Hierarchy' to 'TimeStamp'.
You can find a suitable example in our demo report.