# Datasets

Datasets is one of our more advanced features. It allows you to curate and clean your data to produce a table that will work better with Athenic AI. To use this feature, you will need to be proficient in SQL.

**For Enterprise Users:** Take advantage of 3 hours of complimentary consultation to optimize your datasets, ensuring an optimal experience with Athenic AI.

**Accessing Dataset**

* Navigate to the <mark style="color:orange;">Datasets tab</mark> and click the <mark style="color:orange;">"Create Dataset"</mark> button to begin.

<figure><img src="https://2503620627-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVqTQOKxSAPs7Xr7cb4Ms%2Fuploads%2FCZbaKYiZjyGat1uYm4Lj%2FFrame%2012.png?alt=media&#x26;token=15d0decc-cd8d-4ea3-8505-ada3ec1de9d8" alt=""><figcaption><p>Select Tables and Columns</p></figcaption></figure>

**Dataset Manipulation:**

**‍**On the create dataset page, you'll find your tables listed on the left. Select any to view their columns and data types. The <mark style="color:orange;">central SQL editor lets you craft your dataset</mark>.

<figure><img src="https://2503620627-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVqTQOKxSAPs7Xr7cb4Ms%2Fuploads%2Fhfzk5gAdpzr1g7KXZ8AO%2FScreenshot%202024-12-12%20at%2010.30.24%E2%80%AFAM.png?alt=media&#x26;token=342a0686-ba9f-4bcc-9736-533eb30ee8f8" alt=""><figcaption><p>SQL Commands</p></figcaption></figure>

‍

**Common Uses and methods:**

* **Join** selected columns from different tables (which Athenic AI can do dynamically in queries)
* **Filter** out unnecessary columns
* **Rename** columns for clarity
* **Standardize** data entries (e.g., converting "California" to "CA")

**Run SQL**

* **‍**Execute your SQL to see the resultant table displayed below. Once satisfied, enter a name for your dataset in the top left field and save. After saving, your dataset will be listed under the Datasets tab, ready to be added to your project by selecting it.**‍**

By following these steps, you can craft a refined dataset tailored for your analysis with Athenic AI.