> For the complete documentation index, see [llms.txt](https://docs.getinfinity.app/user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getinfinity.app/user-guide/comprehensive-user-guide/2.-charts/creating-charts/data-explorer.md).
# Data Explorer
In this article, we will explain how to create and customize a line chart. So let's get started!
The **Data Explorer** in Infinity provides an advanced SQL-based interface for users who prefer to manually query datasets, customize visualizations, and leverage AI assistance for SQL generation. Follow these steps to build and analyze data using SQL.
***
### **Step 1: Access the Data Explorer**
1. Click on **"Data Explore"** from the left sidebar.
💡 *This opens the SQL based Data Explorer, where you can write queries and explore data.*
***
### **Step 2: Add a New Query**
1. Click **"Add New Query"** to create a new query workspace.
2. A new query editor box will appear.
📌 *Each query box is independent, allowing multiple datasets to be built simultaneously.*
***
### **Step 3: Select the Relevant Data Source**
1. Choose the appropriate **database or uploaded dataset** from the available options.
🔍 *Ensure you select the correct source before running queries to avoid errors.*
***
### **Step 4: Write the SQL Query to Build a Dataset**
1. In the query editor, enter your SQL query.
* Example:
```sql
SELECT sales, orderdate FROM orders;
```
2. Modify the query based on the dataset requirements.
🛠️ *This step allows full control over how the dataset is structured.*
***
### **Step 5: Click "EXECUTE" to Run the Query**
1. Once the query is written, click **"EXECUTE"** to run it.
2. The results will be displayed in a table format below the query box.
📊 *Executing the query fetches the relevant data for visualization.*
***
### **Step 6: Use AI Bot for SQL Assistance**
1. Click on the **AI Bot** feature to get SQL assistance.
2. AI can **suggest, auto-fix, or optimize** your SQL query.
🔹 *Helpful for users who are unsure about SQL syntax or need optimization suggestions.*\
***
### **Step 7: Automatically Fix Query Syntax Errors**
1. If your query has errors, AI will suggest corrections.
2. Click **"Apply Fix"** to correct syntax issues automatically.
🛠️ *This ensures that queries run without manual troubleshooting.*
***
### **Step 8: Click "EXECUTE" Again**
1. If the query was fixed or modified, click **"EXECUTE"** again to retrieve updated results.
🔄 *Re-executing the query applies changes and fetches fresh data.*
***
### **Step 9: Use AI to Generate a Visualization from the Dataset**
1. Click on **"Visualization"** to let AI suggest a suitable chart for the dataset.
2. The system will automatically determine the best **chart type, layout, and formatting**.
📌 *AI-driven visualizations help quickly convert raw data into meaningful insights.*
***
### **Step 10: Customize the Table and Chart**
1. Click **"Customize the Table"** to manually format/create the chart.
2. The user will be taken to the chart customization page.
🎨 *This step allows users to create and refine the chart before saving it.*
***
### **Final Step: Save the Chart**
1. Once the visualization is complete, click **"Save"** to store it.
2. The chart will be available in your **feed**.
💾 *Your SQL-powered chart is now ready for sharing and further analysis!*
***
### **Next Steps**
For more advanced customization, refer to the [**Chart Customization Guide**](/user-guide/comprehensive-user-guide/2.-charts/chart-customization.md) to explore:
* **Using interactive filters and drill-downs**.
* **Applying custom themes and layouts**.
* **Integrating AI-powered insights into reports**.
The **Data Explorer** in Infinity provides **full SQL control, AI assistance, and powerful visualization tools**, making it an ideal solution for **data analysts, engineers, and SQL-savvy users**. 🚀
