Skip to main content

Celonis Product Documentation

Data Check

Digital Twin extraction
Data Quality Check

The Data Quality Check runs a set of tests on your data model. In case an issue is found, a warning or error is raised.

The user is still able to proceed in case there is a warning. In case there is an error, the issue must be fixed before the user can proceed.

60363488.png

Advanced:

Lift of all warnings and errors:

ID

Header

Error

Warning

empty-table

No cases were found in the data model.

There are no cases found in the provided data model. Please check your data model for missing data usage permissions and/or if there were issues with the datamodel load.

No

empty-activity-column

Empty values in the Activity column.

The Activity column contains more than 10% of empty values. Please remove them to proceed.

1234 events have no value for the Activity column. This could cause problems to the Digital Twin Extraction, please check your Data Model.

empty-case-id-column

Empty values in the Case ID column.

The Case ID column contains more than 10% of empty values. Please remove them to proceed.

1234 events have no value for the Case ID column. This could cause problems to the Digital Twin Extraction, please check your data model.

empty-timestamp-column

Empty values in the Timestamp column.

The Timestamp column contains more than 10% of empty values. Please remove them to proceed.

1234 events have no value for the Timestamp column. This could cause problems to the Digital Twin Extraction, please check your Data Model.

activity-case-table-mismatch

Mismatch in cases in the Activity and Case table.

-

There are 1234 cases in the Activity Table that are missing from the Case Table. This could cause problems to the Digital Twin Extraction, please check your Data Model.

eventtime-start-column

Event time start column is same as event time end column.

The Event time start column is the same as the Event time end column (as defined in the data model). Please select a different column or leave empty if the start times are not available.

-

day-based-activities

Timestamps are rounded the Eventday.

Timestamps are rounded at the Eventday. Please include the hours and minutes in the Timestamp columns of the data model.

1234 Timestamps are rounded at the Eventday.This could cause problems to the Digital Twin Extraction, please check your Data Model and include the hours and minutes in the Timestamp columns of the data model.

empty_user_id

Empty values in the User ID column.

More than half of the events are missing a User ID. Please include the ID's in the data model or unselect the User ID column if the data is not available.

-

empty_user_type

Empty values in the User Type column.

More than half of the events are missing a User Type value. Please include the User type in the data model or unselect the User Type column if the data is not available.

-