Skip to main content

Celonis Product Documentation

Validating data with Data Explorer

Data validation is an essential part of every Celonis project to secure data quality before handing it over to Data Analysts. After data extractions, transformations, and the creation of a Data Model, Data Engineers can use the Data Explorer to run an effective data validation within a single dashboard.

The main things that you can check are:

  • if the data types of the columns are configured correctly,

  • if the ranges of numbers and dates make sense,

  • if and where Null values occur, and whether uniqueness is met where needed,

  • and where outliers occur.

If you used the Data Explorer for all these validations, you can also directly share the Explorer with the Analyst for them to get familiar with your data model.

In the screenshot below you see how to use Data Explorer components to validate your data.

DataExplorer_validating_data.png
Process mining data validation best practices

Data validation is an essential part of every Celonis project to secure data quality before handing it over to Data Analysts. Here are some ideas on how you can use Data Explorer to make sure that your data is reliable.

  1. Check the sequence of activities for a selected case:

    1. Filter on a specific case.

    2. Select your activity table and configure your table to show:

      • Case key

      • Activity

      • Event time

    3. Verify if all activities are shown and if all attributes, such as even time, are correct.

      DataValidation1.png
  2. Check the range of the event time column of your activity table:

    1. Go to the distribution component and make sure that you don’t have any outliers.

      DataExplorer_validation2.png
  3. Check amounts for specific columns and their values:

    1. Select your case table in the example below e.g. BSEG (Accounting).

    2. Toggle group and aggregate.

    3. Group by the column you are interested e.g. BUKRS (Company Code).

    4. Show “count distinct” of column “CASE_KEY”.

    DataExplorer_validation1.png
  4. Check amounts:

    1. Select your case table in the example below BSEG-Accounting.

    2. Toggle Group and aggregate.

    3. Show “sum” of column e.g. “WRBTR (amount )”.

    4. Check if the sum matches the one in your source system.

    5. (optional) Check amounts for specific columns:

      1. At the bottom of your current exploration, click Add exploration.

      2. Group by the column you are interested e.g. BUKRS (Company Code).

      3. Check is the sum matches the one in your source system.

    DataExplorer_datavalidation3.png