Skip to main content

Celonis Product Documentation

Data Explorer

Data Explorer enables users to easily validate their data and quickly build their Process Query Language (PQL) queries. Data Explorer is an asset in Studio.

As the main target audience for the Data Explorer are Data Analysts and Engineers, it is only visible inside Studio. Business Users can’t access it in Apps. If you’re a Data Engineer, Data Explorer allows you to validate data in a Data Model and run a quality check on it before you pass it on to your Data Analyst. If you’re a Data Analyst, Data Explorer can help you get a thorough understanding of your data before you start building automations and dashboards.

Data Explorer lives on top of a Knowledge Model, so you can easily save KPIs, filters and records to your Knowledge Model.

DataExplorer_structure.png

What's in Data Explorer

Data Explorer consists of multiple components which will allow you to analyze and work with your data faster. Here’s an overview of all Data Explorer components.

DataExplorer_v2.png

1. Filter input

2. Knowledge Model, Data Model and Documentation

3. Data Exploration tile

4. Create more Data Explorations or Aggregations

5. Share feedback with the product team

Table component

Table components allow you to visualize selected columns as tables including the data profile of the column. You can select up to 20 columns to be displayed in your view including columns from tables that are related to a selected table.

DataExplorer_tablecomponentNEW.png

Details component

Allows you to explore data in your columns one by one and get an overview of the respective values in the selected column.

DataExplorer_DetailstabNEW.png

Distribution component

Easily switch between your Date columns and drill down to the point of time of your interest by simply clicking on a given time period and the component will re-compute itself and zoom in on the selected period of time.

DataExplorer_DistributionNEW.png

In this section