# Data transformations

> 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-suite/2023.10/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-suite/2023.10/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`.

## Data transformations editor

The data transformations editor consists of the following sections.

* Input data
* Transformations
* Data model
* Preview panel

## 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.

## Useful links

* [Event logs](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/structure-of-transformations#4-event-logs)
* [Tips for writing SQL](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/tips-for-writing-sql#tips-for-writing-sql)
* [SQL examples for configuring Tags](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/tags#sql-examples-for-configuring-tags)
* [SQL examples for configuring Due dates](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/due-dates#sql-examples-for-configuring-due-dates)

## Editing transformations locally

When you create a process app from an app template, you want to make sure the data used in the process app reflects your process in the correct way. With **Data transformations** you can customize the data used for **Process Mining**.

You can either customize the transformations from within **Process Mining** using **Data transformations**, or you can edit them locally on your desktop, check out [Editing data transformations in a local environment](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/customizing-data-transformations#editing-data-transformations-in-a-local-environment)

This page describes how to customize data transformations from within **Process Mining**. **Data transformations** are integrated in the dashboard editor. Check out [Working with the dashboard editor](https://docs.uipath.com/process-mining/automation-suite/2023.10/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.

## Opening Data transformations

1. Select the **Data transformations** button in the upper right corner of the dashboard editor to open the **Data transformations**.
   :::note
   If you open the in-line editor for the first time, it will take some time to load the editor.
   :::

The in-line data transformations editor is displayed.

## Input data

The input data panel shows the input tables that have been loaded into the process app as raw data. Select a table to see the fields and the data contents in the data preview. The data preview enables you to check if the input data looks as expected.

:::note
The preview shows 1000 records of data. If you want to filter for specific data, create a temporary debug query, refer to [Data transformations](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/editing-transformations#data-transformations).
:::
:::note
The **Preview** panel shows the data of the last data run in which this table was recalculated. If you have made recent changes, then start a new data run to view its results, refer to [Editing and testing data transformations](https://docs.uipath.com/process-mining/automation-suite/2023.10/user-guide/editing-and-testing-the-data-transformations#editing-and-testing-data-transformations).
:::

## 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-suite/2023.10/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**.
:::