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:

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