# Data Prep (Projects)

Data Prep is a tool to prepare your data for applications quickly. It allows you to explore and transform data with built-in SQL actions, then automate the pipeline for your data apps

### What is a Data Prep Project?&#x20;

Data Prep is a tool to prepare your data for applications quickly. It allows you to explore and transform data with built-in SQL actions, then automate the pipeline for your data apps. A project is used to **manage multiple tables**, **perform actions,** and **collaborate** with your teammates.&#x20;

<figure><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FOaFBCDPr3xIc4b2R7QQ1%2Fimage.png?alt=media&#x26;token=c92f7861-fa3f-4181-886b-65519b9eae15" alt=""><figcaption></figcaption></figure>

### How does a project work?&#x20;

In a project, you do not have to worry about **overwriting or altering** the original database that you have imported. You may perform whatever action you like and be able to go back in action.&#x20;

Within the project, you may create many “table tabs”. These tabs are sourced from your database so that you may edit multiple tables all in once.  Though they may look like a tab from your internet browser, there is a **data pipeline behind each table tab**. It means that you must always apply [**actions in sequence**](https://docs.acho.io/acho-studio/applying-actions#action-sequence), and make changes to each action logically. For example, you cannot merge a table that is not open in a project or edit a filter that you have applied several steps earlier.&#x20;

A project also works as a foundation for other projects on Acho Studio such as Visual Panel. When you have applied a series of actions on a project, that will produce a table you can work on **further** on Visual Panel.&#x20;

### Where to start Data Prep

**Data Prep**<img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FRimNA2j6XLWu3RlttQKd%2Fimage.png?alt=media&#x26;token=40a5424d-5095-4e0d-88c1-83ce11fd1512" alt="" data-size="line">can be conveniently accessed from the sidebar menu. To initiate the interface, simply click on the "Data Prep" in the sidebar. Upon entering this interface, you will see a layout listing all the project you have. If there is no project in the organization, you will be led to create a **Data Prep Project** from resources.&#x20;

{% hint style="info" %}
In order to create **Data Prep Project** you need to have at least one [**Resource**](https://docs.acho.io/acho-studio/resources) in your organization.
{% endhint %}

<figure><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FJt3y6cIyNzBqtLwn5iua%2Fimage.png?alt=media&#x26;token=8166fdb0-adda-4aee-97d7-2e180cacdce3" alt=""><figcaption></figcaption></figure>

### Learn more about

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Create a Data Prep Project</strong></td><td>Create a data preparation project (Data Prep) in Acho Studio</td><td></td><td><a href="data-prep-projects/create-a-project">create-a-project</a></td></tr><tr><td><strong>Apply an action</strong></td><td>Explore, clean and transform data with <strong>built-in SQL actions</strong>, such as sort, filter, join, deduplicate and flatten.</td><td></td><td><a href="data-prep-projects/applying-actions">applying-actions</a></td></tr><tr><td><strong>Pipeline</strong></td><td>Create and visualize automated process to transform your data.</td><td></td><td><a href="data-prep-projects/pipeline">pipeline</a></td></tr></tbody></table>
