# Data transformations editor

> This page describes how to customize data transformations from within **Process Mining**. The **Data transformations** editor is integrated in the dashboard editor. Check out [Working with the dashboard editor](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/working-with-the-dashboard-editor#working-with-the-dashboard-editor).

This page describes how to customize data transformations from within **Process Mining**. The **Data transformations** editor is integrated in the dashboard editor. Check out [Working with the dashboard editor](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/working-with-the-dashboard-editor#working-with-the-dashboard-editor).

**Data transformations** enable you to:
* add new fields for `group by` and filters. For example, **Quality check type**.
* add events. For example, **Invoice quality check done**.
* add tags. For example, **Failed to meet SLA**, **Four eyes violation**.
* add business logic for calculating KPIs. For example, `Case_has_maverick_buying`.

## Prerequisites

When starting editing data transformations it is strongly recommended that you:

* have in-depth knowledge of SQL;
* are familiar with the source system that is used for data extraction.

## Data transformations editor

The data transformations editor consists of the following sections.

* [Input](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/input-data#input-data)
* [Transformations](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/editing-and-testing-the-data-transformations#editing-data-transformations)
* [Output](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/data-models#data-models)

SQL files and input files are displayed in a tab. When you open a SQL file or an input file, a new tab is opened in the Data transformations editor. You can open and edit or view multiple files simultaneously.

## Useful links

* [Tips for writing SQL](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/tips-for-writing-sql#tips-for-writing-sql)
* [SQL examples for configuring Tags](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/configuring-tags#sql-examples-for-configuring-tags)
* [SQL examples for configuring Due dates](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/configuring-due-dates#sql-examples-for-configuring-due-dates)

## Opening Data transformations

1. Select the menu in the header bar of the dashboard editor and select **Data transformations** from the drop-down menu.

The in-line data transformations editor is displayed.

:::note
Select the menu in the header bar and select **Dashboards** to go back to the dashboard editor.
:::

## Transformations

Select **Transformations** to view the structure of the transformations and to display the `.sql` files.

Refer to [Structure of transformations](https://docs.uipath.com/process-mining/automation-cloud/latest/user-guide/structure-of-transformations#structure-of-transformations) for more information on the structure of the transformations.

Each `.sql` file defines a new table in the data model. If you select the a `.sql` file in the **Transformations** panel, the SQL query is displayed in the **Transformations** and a preview of the data file you are editing is displayed in the **Preview** panel.

When editing a query, you can see a preview of the data of the last time the query was run in the **Preview** panel.

:::important
If there are any unsaved changes in the transformations, the **Save** button is enabled. Select **Save** to save the changes. The status of the transofrmation will be set to **Up to date**.
:::