<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: DashboardGPT</title>
    <description>The latest articles on DEV Community by DashboardGPT (@dashboardgpt).</description>
    <link>https://dev.to/dashboardgpt</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4249086%2F1b9a3b85-0b43-4813-bff0-f390af9ec50d.png</url>
      <title>DEV Community: DashboardGPT</title>
      <link>https://dev.to/dashboardgpt</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/dashboardgpt"/>
    <language>en</language>
    <item>
      <title>How to chat with a CSV file and get charts, not paragraphs</title>
      <dc:creator>DashboardGPT</dc:creator>
      <pubDate>Wed, 18 Nov 2026 14:20:38 +0000</pubDate>
      <link>https://dev.to/dashboardgpt/how-to-chat-with-a-csv-file-and-get-charts-not-paragraphs-874</link>
      <guid>https://dev.to/dashboardgpt/how-to-chat-with-a-csv-file-and-get-charts-not-paragraphs-874</guid>
      <description>&lt;p&gt;Upload, ask, follow up. A step-by-step walkthrough using an example e-commerce orders file, from a raw export to a canvas of answers you can share.&lt;/p&gt;

&lt;h2&gt;
  
  
  Key takeaways
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Spend two minutes cleaning the CSV first: clear headers, one row per record, real dates.&lt;/li&gt;
&lt;li&gt;Start with one headline question, then use follow-ups to narrow it down.&lt;/li&gt;
&lt;li&gt;Ask for a chart type or breakdown when you want one; otherwise the tool picks a sensible default.&lt;/li&gt;
&lt;li&gt;Check one number you already know before you share anything.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What you need
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;A CSV file.&lt;/strong&gt; Any export works: orders, subscriptions, ad spend, support tickets. The free Explore plan includes 10 MB of uploads a month and Team has no limit, and Excel files work too.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;A question you care about.&lt;/strong&gt; "Why were sales lower last month?" is a better starting point than "show me the data".&lt;/li&gt;
&lt;li&gt;&lt;strong&gt;Five minutes.&lt;/strong&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This walkthrough uses an example orders export from an online store, with one row per order and these columns:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Column&lt;/th&gt;
&lt;th&gt;Example value&lt;/th&gt;
&lt;th&gt;What it means&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;order_id&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;100482&lt;/td&gt;
&lt;td&gt;Unique order number&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;order_date&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;2026-08-14&lt;/td&gt;
&lt;td&gt;Date the order was placed&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;customer_id&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;C-20931&lt;/td&gt;
&lt;td&gt;Who placed it&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;region&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;West&lt;/td&gt;
&lt;td&gt;Shipping region&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;category&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Home &amp;amp; Kitchen&lt;/td&gt;
&lt;td&gt;Product category&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;channel&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;Paid search&lt;/td&gt;
&lt;td&gt;How the customer arrived&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;order_value_usd&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;84.50&lt;/td&gt;
&lt;td&gt;Order total in US dollars&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;discount_usd&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;10.00&lt;/td&gt;
&lt;td&gt;Discount applied&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;status&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;delivered&lt;/td&gt;
&lt;td&gt;delivered, returned or cancelled&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;h2&gt;
  
  
  Step 1: Prepare the file (two minutes)
&lt;/h2&gt;

&lt;p&gt;A few small fixes make every answer more reliable:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Use clear column names.&lt;/strong&gt; &lt;code&gt;order_value_usd&lt;/code&gt; is better than &lt;code&gt;val&lt;/code&gt; or &lt;code&gt;Amount (incl. tax) - USD&lt;/code&gt;. Keep them short, lowercase and without special characters.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Keep one row per record.&lt;/strong&gt; One row per order here. Remove subtotal rows, blank rows and notes at the bottom of the sheet.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Put dates in one format.&lt;/strong&gt; &lt;code&gt;YYYY-MM-DD&lt;/code&gt; avoids the 03/04 problem (March 4 or April 3?).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Keep numbers as numbers.&lt;/strong&gt; Remove currency symbols and thousands separators inside cells: &lt;code&gt;1250.00&lt;/code&gt;, not &lt;code&gt;$1,250.00&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Drop columns you don't need,&lt;/strong&gt; especially personal fields such as email addresses and phone numbers.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Step 2: Upload and let the columns be profiled
&lt;/h2&gt;

&lt;p&gt;Create a free account, then upload the CSV. DashboardGPT profiles each column as it loads: it detects that &lt;code&gt;order_date&lt;/code&gt; is a date, &lt;code&gt;order_value_usd&lt;/code&gt; is a currency amount, &lt;code&gt;region&lt;/code&gt; and &lt;code&gt;category&lt;/code&gt; are categories, and &lt;code&gt;order_id&lt;/code&gt; is an identifier that should be counted, not summed.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F3is72976teonznuadth1.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F3is72976teonznuadth1.webp" alt="The Upload data dialog with orders.csv uploaded and a message saying Online store orders is ready, with Close, Open dataset and Build a canvas buttons." width="800" height="478"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;A sample orders file with 3,089 rows, ready a few seconds after uploading. Build a canvas is offered straight away.&lt;/p&gt;

&lt;p&gt;Take ten seconds to check the Profile tab. It says what the import couldn't do cleanly: rows it couldn't read and left out, with their line numbers, columns it had to name because a header was empty or repeated, and columns that may have the wrong type, such as a zip code read as a number or amounts like $1,200 read as text.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxhv56sz8jfyarbn5wtuj.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxhv56sz8jfyarbn5wtuj.webp" alt="The Profile tab for Online store orders showing 3,089 rows, 8 columns, no duplicate rows and 100% completeness, with order\_value\_usd as the measure and order\_date as the date." width="800" height="893"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The Profile tab for a clean sample file. Nothing needed fixing, so it shows the counts and how each column will be used.&lt;/p&gt;

&lt;p&gt;If a type is wrong, fix it now: accept the suggestion on the Profile tab, or choose the pencil beside the type on the Schema tab. The file is imported again with the column read your way, and DashboardGPT warns you first about any chart the change would affect. Every later answer depends on it.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft9sjxg7r5j9apl73z52v.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft9sjxg7r5j9apl73z52v.webp" alt="The Schema tab listing each column with its type, role, distinct count and sample values, such as order\_date as a Date, order\_value\_usd as a Decimal number and customer\_zip as Text." width="800" height="1070"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The Schema tab. customer_zip was read as text, so codes such as 02139 keep their leading zero. The pencil beside each type changes it.&lt;/p&gt;

&lt;p&gt;Want the big picture before you ask anything? Choose Build a canvas when the upload is ready, and DashboardGPT lays out the charts that fit your columns. &lt;a href="https://www.dashboardgpt.org/learn/automatic-dashboard-from-a-spreadsheet" rel="noopener noreferrer"&gt;Turn a spreadsheet into a canvas of charts&lt;/a&gt; explains what you get.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 3: Ask one headline question
&lt;/h2&gt;

&lt;p&gt;Start with the number that matters most. For an orders file, that is usually revenue over time:&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;Try it on the demo data:&lt;/strong&gt; “What was total order value by month for the last 12 months?” &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;Try a question like this on demo data&lt;/a&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;You get a line chart of monthly revenue on the canvas, with a short written insight underneath, for example that August was the lowest month since March and down about 12% on July.&lt;/p&gt;

&lt;p&gt;That is a chart, not a paragraph. The written insight explains it and cites the figures, but the chart is the answer.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5oyfbvwogiljkqsvlwxg.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5oyfbvwogiljkqsvlwxg.webp" alt="The DashboardGPT playground with the question Show total revenue by month in the chat, a written answer about monthly revenue, and a line chart of revenue from January 2023 to December 2024 on the canvas." width="799" height="423"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;A headline question on the playground's retail sales demo data. The chart goes on the canvas, and the written answer appears in the chat.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 4: Follow up on the chart
&lt;/h2&gt;

&lt;p&gt;Select the chart and ask the next question. Because the follow-up knows which chart you are pointing at, you do not need to repeat the dataset, the metric or the time window:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;em&gt;Break August down by region.&lt;/em&gt; The drop is almost all in the West region.&lt;/li&gt;
&lt;li&gt;
&lt;em&gt;Now by channel, West only.&lt;/em&gt; Paid search orders fell by half; other channels were flat.&lt;/li&gt;
&lt;li&gt;
&lt;em&gt;Compare paid search orders per week in July and August.&lt;/em&gt; The fall starts in the second week of August.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Three follow-ups turn "revenue is down" into "paid search in the West dropped from the second week of August". That is something you can act on: check whether a campaign was paused or a budget ran out.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9u9o0vwueft6zz5uobiw.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9u9o0vwueft6zz5uobiw.webp" alt="A follow-up in the playground. The monthly revenue chart is selected as context, and the question Break this down by region adds a bar chart of revenue for West, North, South and East beside it." width="799" height="384"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;With the chart selected, the follow-up only needs the new part: break this down by region.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 5: Get the chart you want
&lt;/h2&gt;

&lt;p&gt;The tool picks a sensible chart for each result, but you can ask for a specific one:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;You want&lt;/th&gt;
&lt;th&gt;Ask like this&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;A trend&lt;/td&gt;
&lt;td&gt;"... by week as a line chart"&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;A ranking&lt;/td&gt;
&lt;td&gt;"Top 10 categories by revenue, as a bar chart, largest first"&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;A share of a total&lt;/td&gt;
&lt;td&gt;"Share of revenue by channel this quarter"&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;A single number&lt;/td&gt;
&lt;td&gt;"What was the average order value in August?"&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;A comparison&lt;/td&gt;
&lt;td&gt;"Compare July and August revenue by region side by side"&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;A table&lt;/td&gt;
&lt;td&gt;"List the 20 largest orders in August with region and channel"&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;You can also refine a chart after it appears: &lt;em&gt;"Show this as a percentage change"&lt;/em&gt;, &lt;em&gt;"Exclude cancelled orders"&lt;/em&gt; or &lt;em&gt;"Only include orders over $50"&lt;/em&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 6: Check the numbers
&lt;/h2&gt;

&lt;p&gt;Before you share anything, confirm one figure you already know. If your store dashboard says July revenue was $412,000, ask &lt;em&gt;"What was total order value in July?"&lt;/em&gt; and compare.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fbtj577m18e5zepv5sh0c.webp" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fbtj577m18e5zepv5sh0c.webp" alt="The monthly revenue chart shown as a table, listing total revenue for each month from January 2023, such as $4.5K in January and $5.3K in May." width="540" height="388"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Every chart can switch to a table, so you can check its numbers against figures you know.&lt;/p&gt;

&lt;p&gt;If it does not match, the cause is usually one of these:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Returned or cancelled orders are included.&lt;/strong&gt; Ask again with &lt;em&gt;"only delivered orders"&lt;/em&gt;.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Discounts are counted differently.&lt;/strong&gt; Decide whether revenue is before or after &lt;code&gt;discount_usd&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Dates cut off differently.&lt;/strong&gt; The export may use UTC while your dashboard uses local time.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;The file is not complete.&lt;/strong&gt; Exports are sometimes capped at a row limit.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;You can also open the chart's menu and choose &lt;strong&gt;How it's calculated&lt;/strong&gt;. It shows, step by step, which columns the chart uses and the kind of value each holds, which rows it keeps, how it groups them and how each figure is worked out. &lt;a href="https://www.dashboardgpt.org/learn/natural-language-to-chart#check-how-a-chart-was-calculated" rel="noopener noreferrer"&gt;Natural language to chart&lt;/a&gt; explains what to look for.&lt;/p&gt;

&lt;h2&gt;
  
  
  Step 7: Organise and share the canvas
&lt;/h2&gt;

&lt;p&gt;Every answer stays on the canvas, so the analysis builds up as you go. Before sharing:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Group related answers:&lt;/strong&gt; the headline chart, the regional breakdown and the channel breakdown together.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Delete dead ends&lt;/strong&gt; that did not lead anywhere.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Put the conclusion first:&lt;/strong&gt; the chart that explains the drop goes at the top.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;On the Team plan you can share the canvas with colleagues, so they see the answers and the questions that produced them.&lt;/p&gt;

&lt;h2&gt;
  
  
  Ten questions to try on an orders CSV
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;What was total order value by month for the last 12 months?&lt;/li&gt;
&lt;li&gt;What is the average order value by channel?&lt;/li&gt;
&lt;li&gt;Which 5 categories grew fastest this quarter compared with last quarter?&lt;/li&gt;
&lt;li&gt;What share of orders were returned, by category?&lt;/li&gt;
&lt;li&gt;How many new vs returning customers ordered each month?&lt;/li&gt;
&lt;li&gt;Which region has the highest average discount?&lt;/li&gt;
&lt;li&gt;What day of the week has the most orders?&lt;/li&gt;
&lt;li&gt;Which customers placed more than 5 orders this year?&lt;/li&gt;
&lt;li&gt;How does order value differ between discounted and full-price orders?&lt;/li&gt;
&lt;li&gt;Which channel brings customers with the highest repeat rate?&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Frequently asked questions
&lt;/h2&gt;

&lt;h3&gt;
  
  
  How big can the CSV be?
&lt;/h3&gt;

&lt;p&gt;The free Explore plan includes 10 MB of CSV and Excel uploads a month, and Team has no upload limit. Warehouse connections for live data are coming soon on Team.&lt;/p&gt;

&lt;h3&gt;
  
  
  Do I need to clean the file first?
&lt;/h3&gt;

&lt;p&gt;Not always, but two minutes of cleanup (clear headers, one row per record, consistent dates, numbers without symbols) makes answers noticeably more reliable.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I chat with an Excel file instead of a CSV?
&lt;/h3&gt;

&lt;p&gt;Yes. Excel files are supported on every plan, the same way as CSV files.&lt;/p&gt;

&lt;h3&gt;
  
  
  Why did I get a different number from my dashboard?
&lt;/h3&gt;

&lt;p&gt;The usual causes are returned or cancelled orders being included, discounts counted differently, time zone differences or an incomplete export. Ask how the number was calculated to see the query.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I ask for a specific chart type?
&lt;/h3&gt;

&lt;p&gt;Yes. Add it to the question, for example "as a bar chart, largest first", or ask to change a chart after it appears.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published on &lt;a href="https://www.dashboardgpt.org/learn/how-to-chat-with-a-csv-file" rel="noopener noreferrer"&gt;DashboardGPT Learn&lt;/a&gt;. DashboardGPT lets you ask questions of your data in plain English and get charts back. You can &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;try it in the playground&lt;/a&gt; without an account.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>ai</category>
      <category>tutorial</category>
      <category>datascience</category>
      <category>analytics</category>
    </item>
    <item>
      <title>Apache Superset + AI: adding natural language to your BI stack</title>
      <dc:creator>DashboardGPT</dc:creator>
      <pubDate>Wed, 18 Nov 2026 14:20:38 +0000</pubDate>
      <link>https://dev.to/dashboardgpt/apache-superset-ai-adding-natural-language-to-your-bi-stack-3j8d</link>
      <guid>https://dev.to/dashboardgpt/apache-superset-ai-adding-natural-language-to-your-bi-stack-3j8d</guid>
      <description>&lt;p&gt;We run DashboardGPT's questions on Apache Superset. This guide covers what AI means for Superset today, three ways to add plain-English questions, the architecture behind them, where they break and the safety rules to set first.&lt;/p&gt;

&lt;h2&gt;
  
  
  Key takeaways
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Superset runs queries and draws charts, but expects people to write SQL or build charts by hand. Plain-English questions come from a layer you add.&lt;/li&gt;
&lt;li&gt;There are three ways to add that layer: a helper inside SQL Lab, a separate text-to-SQL service, or a canvas on top of Superset.&lt;/li&gt;
&lt;li&gt;Five steps turn a question into a chart: schema context, prompt, SQL checks, running it through Superset and choosing the chart. Most wrong answers come from unclear data, not the model.&lt;/li&gt;
&lt;li&gt;You can build this yourself on Superset. Or you can use a tool like DashboardGPT that already runs it on Superset.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What AI in Superset means today
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://superset.apache.org/docs/intro" rel="noopener noreferrer"&gt;Apache Superset&lt;/a&gt; is a popular open-source BI tool (BI means business intelligence, the charts and reports a company runs on). It connects to most SQL databases and has a SQL editor called SQL Lab, many chart types and a dashboard builder. For teams that want BI without licence fees, it is a natural choice.&lt;/p&gt;

&lt;p&gt;Its limit is the person using it. To get value from Superset, you write SQL in SQL Lab or build charts by hand. That is fine for analysts. But a sales lead or a founder may just want to know &lt;em&gt;why churn went up last month&lt;/em&gt;. For them, SQL is a wall.&lt;/p&gt;

&lt;p&gt;AI can remove that wall, and it shows up in three places:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Built in.&lt;/strong&gt; Superset adds features with each release. Check the release notes for the version you run, because this area moves fast.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Plugins and add-ons.&lt;/strong&gt; Community extensions that help someone writing SQL, for example by drafting a query inside SQL Lab. The person still reads and checks the SQL.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;An external layer.&lt;/strong&gt; A separate tool that takes a plain-English question, writes the query, sends it to Superset to run and brings the chart back. Superset keeps doing what it is good at.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Which one you need depends on who asks the questions. If your analysts already live in SQL Lab, a helper there saves time. If the people asking cannot read SQL, you need a layer that works in plain English and shows the SQL only when someone asks.&lt;/p&gt;

&lt;p&gt;We run natural-language questions on Superset in production for DashboardGPT. The trade-offs in this guide come from running it, not from a demo.&lt;/p&gt;

&lt;h2&gt;
  
  
  Three ways to add natural language to Superset
&lt;/h2&gt;

&lt;p&gt;Teams usually pick one of three routes. The table shows who each suits and what it costs you.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Approach&lt;/th&gt;
&lt;th&gt;Who it suits&lt;/th&gt;
&lt;th&gt;What you build or buy&lt;/th&gt;
&lt;th&gt;Main trade-off&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;SQL Lab assistant&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;Analysts who already read SQL&lt;/td&gt;
&lt;td&gt;A helper inside the SQL editor that drafts a query for review&lt;/td&gt;
&lt;td&gt;Needs someone who can check SQL, and answers stay inside SQL Lab&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;External text-to-SQL service&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;Teams with platform engineers&lt;/td&gt;
&lt;td&gt;A separate service with column profiling, prompts, query checks, an interface and permissions&lt;/td&gt;
&lt;td&gt;The most control, and the most upkeep&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;strong&gt;A canvas on top of Superset&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;Mixed teams, including people who do not write SQL&lt;/td&gt;
&lt;td&gt;A chat and canvas layer where Superset runs the queries and draws the charts&lt;/td&gt;
&lt;td&gt;Less custom control. Follow-up questions and context come ready-made&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;h3&gt;
  
  
  SQL Lab assistant
&lt;/h3&gt;

&lt;p&gt;This is the smallest step. An analyst types a request, the helper drafts a query, and the analyst reads it, fixes it and runs it. It speeds up people who already know SQL. It does not help the colleague who cannot read the query, so it rarely changes who gets answers.&lt;/p&gt;

&lt;h3&gt;
  
  
  External text-to-SQL service
&lt;/h3&gt;

&lt;p&gt;Here you build the full path yourself: profiling, prompts, checks, an interface and permissions. It gives you control over every step, including which AI model you call. It also makes you the owner of every fix, and each new model release or Superset upgrade is yours to test.&lt;/p&gt;

&lt;h3&gt;
  
  
  A canvas on top of Superset
&lt;/h3&gt;

&lt;p&gt;Here the layer is a product. Answers land as cards you can move, group and link to the question they came from, and a follow-up knows which chart you mean. You give up some control over the internals. In return you skip the build and get the whole line of thought on one page.&lt;/p&gt;

&lt;p&gt;A few questions help you choose:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Who will ask the questions: analysts, or people who do not write SQL?&lt;/li&gt;
&lt;li&gt;Do answers need to be kept, moved around and built on, or is each question a one-off?&lt;/li&gt;
&lt;li&gt;Do you have engineers who can own prompts, query checks and permissions over the long run?&lt;/li&gt;
&lt;li&gt;Must the data and the AI calls stay inside your own network?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;DashboardGPT takes the third route. If you want the first two, the guide to &lt;a href="https://www.dashboardgpt.org/learn/superset-natural-language-questions" rel="noopener noreferrer"&gt;building an LLM chat interface for Superset&lt;/a&gt; walks through the code.&lt;/p&gt;

&lt;h2&gt;
  
  
  Architecture: from question to chart
&lt;/h2&gt;

&lt;p&gt;Whichever route you choose, a question takes the same five steps to become a Superset chart. The AI layer handles the first three. Superset runs the query and draws the result.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ffpieljl8uzfyvzmxlsqa.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ffpieljl8uzfyvzmxlsqa.png" alt="Diagram of five steps from a plain-English question to a chart. The AI layer builds the schema context, builds the prompt and checks the SQL. Then Apache Superset runs the query and the chart is chosen." width="800" height="1534"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Schema context, prompt and checks come from the AI layer. Superset runs the query.&lt;/p&gt;

&lt;h3&gt;
  
  
  1. Schema context
&lt;/h3&gt;

&lt;p&gt;A schema is the list of tables and columns in your data. Before the AI can write a query, it needs to know what each column means, and names alone rarely help. Column names like &lt;code&gt;amt&lt;/code&gt;, &lt;code&gt;dt&lt;/code&gt; and &lt;code&gt;status_cd&lt;/code&gt; tell a model very little.&lt;/p&gt;

&lt;p&gt;Semantic profiling fills the gap. It is a scan that labels each column before anyone asks a question: its type, its role (a date, an amount, a category or an ID), its units and its links to other tables. &lt;a href="https://www.dashboardgpt.org/learn/semantic-column-profiling" rel="noopener noreferrer"&gt;Semantic column profiling&lt;/a&gt; explains it in more detail. DashboardGPT does this for you when you upload a file or connect a source.&lt;/p&gt;

&lt;h3&gt;
  
  
  2. Prompt
&lt;/h3&gt;

&lt;p&gt;The prompt joins the question, the column labels and a short set of rules, such as which date column to use and what to do when a question is unclear. Good tools work in small steps. First they find the number you want, how to split it and any filters. Then they match each part to a real column, and only then do they write the query.&lt;/p&gt;

&lt;p&gt;When the question is genuinely ambiguous, the best answer is a short question back to the user, not a guess.&lt;/p&gt;

&lt;h3&gt;
  
  
  3. SQL validation
&lt;/h3&gt;

&lt;p&gt;The SQL is checked before it runs. It must only read data, never change it, and it can only use tables and columns that exist. It must also stay under set limits on rows and run time. A query that fails a check is repaired or rejected, and never sent to the database.&lt;/p&gt;

&lt;h3&gt;
  
  
  4. Execution through the Superset API
&lt;/h3&gt;

&lt;p&gt;Once a query passes, the layer sends it to Superset, so it runs over the same connection and access rules Superset already uses. Superset has a &lt;a href="https://superset.apache.org/docs/api" rel="noopener noreferrer"&gt;REST API&lt;/a&gt; for this. A minimal call looks like this:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;

&lt;span class="no"&gt;BASE&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="s2"&gt;"https://superset.example.com"&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;run_query&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;session&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;requests&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;Session&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;database_id&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kt"&gt;int&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;sql&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kt"&gt;str&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;-&amp;gt;&lt;/span&gt; &lt;span class="kt"&gt;dict&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="c1"&gt;# session is already logged in to Superset with a read-only account&lt;/span&gt;
    &lt;span class="n"&gt;r&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;session&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;post&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;
        &lt;span class="n"&gt;f&lt;/span&gt;&lt;span class="s2"&gt;"{BASE}/api/v1/sqllab/execute/"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
        &lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"database_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;database_id&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"sql"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;sql&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
              &lt;span class="s2"&gt;"runAsync"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kc"&gt;False&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"queryLimit"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="mi"&gt;5000&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;raise_for_status&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;json&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The guide to &lt;a href="https://www.dashboardgpt.org/learn/superset-natural-language-questions" rel="noopener noreferrer"&gt;building an LLM chat interface for Superset&lt;/a&gt; has the full version, including the login.&lt;/p&gt;

&lt;h3&gt;
  
  
  5. Chart choice
&lt;/h3&gt;

&lt;p&gt;The shape of the result picks the chart. A single number becomes a metric card, a trend over time becomes a line chart, and a comparison of groups becomes a bar chart. Superset draws the chart, and a short written note explains what it shows and quotes the numbers.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;Try it on the demo data:&lt;/strong&gt; “Show weekly active users by plan for the last 12 weeks” &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;Run it on the demo dataset&lt;/a&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Where text-to-SQL breaks, and the fixes
&lt;/h2&gt;

&lt;p&gt;Most wrong answers come from the data, not the model. Here are the common problems and how to fix each one.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Problem&lt;/th&gt;
&lt;th&gt;Example&lt;/th&gt;
&lt;th&gt;Fix&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Unclear columns&lt;/td&gt;
&lt;td&gt;Three date columns: &lt;code&gt;date&lt;/code&gt;, &lt;code&gt;created&lt;/code&gt; and &lt;code&gt;updated&lt;/code&gt;.&lt;/td&gt;
&lt;td&gt;Mark the main date column. Ask the user when it is not clear.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Wrong join&lt;/td&gt;
&lt;td&gt;Revenue counted twice after orders are joined to order lines.&lt;/td&gt;
&lt;td&gt;Set the join keys in the profile. Use tables that are already summed when you can.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Date grain&lt;/td&gt;
&lt;td&gt;A monthly average worked out as an average of daily averages.&lt;/td&gt;
&lt;td&gt;Sum to months first. Then take the average.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Business terms&lt;/td&gt;
&lt;td&gt;Product and sales mean different things by "active user".&lt;/td&gt;
&lt;td&gt;Agree on one meaning. Store it once and reuse it.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Status codes&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;status = 3&lt;/code&gt; means "cancelled".&lt;/td&gt;
&lt;td&gt;Turn codes into plain labels during profiling.&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Time zones&lt;/td&gt;
&lt;td&gt;Daily counts shift at midnight UTC compared with local time.&lt;/td&gt;
&lt;td&gt;Set one time zone for the workspace and always use it.&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;A join links two tables, such as orders and customers. Date grain is the time unit you count by, such as day, week or month.&lt;/p&gt;

&lt;p&gt;The pattern is the same each time. The more meaning you give the AI up front, the less it has to guess. For a deeper look at each problem, read &lt;a href="https://www.dashboardgpt.org/learn/superset-text-to-sql" rel="noopener noreferrer"&gt;text-to-SQL failure patterns&lt;/a&gt;, which covers seven patterns that break and a fix for each.&lt;/p&gt;

&lt;h2&gt;
  
  
  Test it before you trust it
&lt;/h2&gt;

&lt;p&gt;A plain-English layer that answers confidently and wrongly is worse than no layer. Before you let anyone rely on it, test it on questions where you already know the answer.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Pick a table you already chart in Superset and know well.&lt;/li&gt;
&lt;li&gt;Write ten to twenty questions, from simple ("total revenue last month") to hard ("revenue per customer by plan, excluding refunds").&lt;/li&gt;
&lt;li&gt;Compare each answer with the number you already trust, and note which of the common problems above caused every miss.&lt;/li&gt;
&lt;li&gt;Fix the cause once, in the column labels or the shared definitions, and ask the failed questions again.&lt;/li&gt;
&lt;li&gt;Repeat after every change to the data, the prompts or the AI model.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Our &lt;a href="https://www.dashboardgpt.org/learn/50-questions-ai-accuracy" rel="noopener noreferrer"&gt;50-question accuracy test kit&lt;/a&gt; gives you a ready-made set in five levels of difficulty, plus a way to score the results. It works on any tool, not only ours.&lt;/p&gt;

&lt;h2&gt;
  
  
  Build or buy: guardrails, row-level security and tenant isolation
&lt;/h2&gt;

&lt;p&gt;You can build a plain-English layer on Superset yourself. You will need column profiling, prompts for the model, SQL checks and chart rules, plus an interface, permissions and a plan for model updates. That can make sense for a team with platform engineers who want to own every part.&lt;/p&gt;

&lt;p&gt;Whichever way you go, set these guardrails before the first live question. Guardrails are rules that stop a query from doing harm.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Read-only access.&lt;/strong&gt; The AI's database login should never be able to write or delete.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Row and time limits.&lt;/strong&gt; Cap how many rows come back and how long a query can run, so one broad question cannot slow the database.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Show the SQL.&lt;/strong&gt; Every answer should let the user open the query behind it.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Log questions and queries.&lt;/strong&gt; The log shows which terms confuse people and where the profile needs work.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Keep AI keys under your control.&lt;/strong&gt; With &lt;a href="https://www.dashboardgpt.org/learn/bring-your-own-key" rel="noopener noreferrer"&gt;bring your own key&lt;/a&gt;, the AI calls run on your own account. You choose the provider, the model and the spending limit.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Row-level security
&lt;/h3&gt;

&lt;p&gt;People should only see data they are allowed to see. Superset supports &lt;a href="https://superset.apache.org/docs/security/" rel="noopener noreferrer"&gt;row-level security and roles&lt;/a&gt; for its own users. If your AI layer connects with one shared account, those rules do not follow the person asking. You then need to apply the same rules in the layer, or run each query as the person who asked.&lt;/p&gt;

&lt;h3&gt;
  
  
  Tenant isolation
&lt;/h3&gt;

&lt;p&gt;If several teams or customers share the layer, keep their data, questions and answers apart. A mistake here shows one team's numbers to another, so test it as carefully as you test the answers.&lt;/p&gt;

&lt;h3&gt;
  
  
  What DashboardGPT ships
&lt;/h3&gt;

&lt;p&gt;DashboardGPT builds these parts on top of Superset, so you do not have to:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Automatic profiling of uploaded files and connected sources.&lt;/li&gt;
&lt;li&gt;Questions turned into SQL, with checks before anything runs.&lt;/li&gt;
&lt;li&gt;Charts drawn by Superset, with written notes that quote their numbers.&lt;/li&gt;
&lt;li&gt;An infinite canvas where follow-up questions keep their context.&lt;/li&gt;
&lt;li&gt;Bring your own AI key on every plan.&lt;/li&gt;
&lt;li&gt;Each workspace kept apart from every other, with roles for who sees what. Private or &lt;a href="https://www.dashboardgpt.org/on-premise" rel="noopener noreferrer"&gt;self-hosted&lt;/a&gt; setup is on Enterprise.&lt;/li&gt;
&lt;/ul&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;Try it on the demo data:&lt;/strong&gt; “Which plan has the highest churn rate this quarter?” &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;See the Superset-powered answer&lt;/a&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Getting answers back into Superset dashboards
&lt;/h2&gt;

&lt;p&gt;Superset dashboards are built for watching known numbers. They show a fixed set of charts that refresh on a schedule, and they do that job well, so keep them. Exploring is a different job. When you want to know &lt;em&gt;why&lt;/em&gt; a number moved, you ask a question, look at the answer and ask a narrower one. A fixed grid makes that slow. Our look at &lt;a href="https://www.dashboardgpt.org/learn/superset-dashboards-to-canvas" rel="noopener noreferrer"&gt;moving from dashboards to a canvas&lt;/a&gt; explains why.&lt;/p&gt;

&lt;p&gt;Most teams split the work like this: Superset dashboards for the weekly numbers everyone watches, and a conversational canvas for the questions those numbers raise. The two connect in both directions:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://www.dashboardgpt.org/learn/publish-canvas-to-superset" rel="noopener noreferrer"&gt;Publish a canvas to Superset&lt;/a&gt;. Turn a canvas of answers into a Superset dashboard laid out the same way.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.dashboardgpt.org/learn/embed-superset-dashboards" rel="noopener noreferrer"&gt;Embed Superset dashboards&lt;/a&gt;. Show Superset dashboards inside your workspace, with no Superset accounts to manage.&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.dashboardgpt.org/learn/canvas-and-superset-charts-match" rel="noopener noreferrer"&gt;Check that the charts match&lt;/a&gt;. One question, one query, so the two views of a chart never disagree.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Getting started
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Try the playground.&lt;/strong&gt; See plain-English questions answered by Superset charts on a demo dataset, with no signup.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Upload a CSV or Excel export.&lt;/strong&gt; Pick a table you already chart in Superset, and ask the same questions in plain English.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Compare the results&lt;/strong&gt; with your Superset chart to check that the numbers match.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Plan for live data.&lt;/strong&gt; Warehouse connections are coming soon on the Team plan.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Ready to try it? &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;Open the playground&lt;/a&gt;, &lt;a href="https://www.dashboardgpt.org/signup" rel="noopener noreferrer"&gt;sign up&lt;/a&gt;, look at &lt;a href="https://www.dashboardgpt.org/pricing" rel="noopener noreferrer"&gt;pricing&lt;/a&gt; or &lt;a href="https://www.dashboardgpt.org/contact" rel="noopener noreferrer"&gt;contact us&lt;/a&gt; if you want a private setup.&lt;/p&gt;

&lt;h2&gt;
  
  
  Frequently asked questions
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Does Apache Superset have built-in AI?
&lt;/h3&gt;

&lt;p&gt;Superset runs queries and draws charts. Plain-English questions are usually added as a layer on top, and Superset adds features with each release, so check the notes for the version you run. DashboardGPT is one such layer. It uses Superset to run queries and draw charts, and adds chat and an infinite canvas.&lt;/p&gt;

&lt;h3&gt;
  
  
  Can I ask Superset questions in plain English?
&lt;/h3&gt;

&lt;p&gt;Yes, with a plain-English layer on top. Your question is turned into SQL and checked, then Superset runs it on your database. You get back a chart with a short written explanation.&lt;/p&gt;

&lt;h3&gt;
  
  
  Is text-to-SQL accurate enough for business use?
&lt;/h3&gt;

&lt;p&gt;It is accurate for most everyday questions when the columns are well described. It gets worse with unclear column names, complex joins and business terms people disagree on. That is why column profiling and visible SQL matter.&lt;/p&gt;

&lt;h3&gt;
  
  
  Does this replace my Superset dashboards?
&lt;/h3&gt;

&lt;p&gt;No. Dashboards are best for watching known numbers. A conversational canvas is best for exploring the questions those dashboards raise. Most teams use both.&lt;/p&gt;

&lt;h3&gt;
  
  
  How do I stop AI queries from changing my data?
&lt;/h3&gt;

&lt;p&gt;Give the AI layer a read-only database login, check every query before it runs, and cap rows and run time. Showing the SQL behind each answer lets people spot a problem early.&lt;/p&gt;

&lt;h3&gt;
  
  
  Which databases work?
&lt;/h3&gt;

&lt;p&gt;Superset supports most SQL databases. In DashboardGPT, CSV and Excel uploads work on every plan. Warehouse connections are coming soon on the Team plan.&lt;/p&gt;




&lt;p&gt;&lt;em&gt;Originally published on &lt;a href="https://www.dashboardgpt.org/learn/apache-superset-ai" rel="noopener noreferrer"&gt;DashboardGPT Learn&lt;/a&gt;. DashboardGPT lets you ask questions of your data in plain English and get charts back. You can &lt;a href="https://www.dashboardgpt.org/playground" rel="noopener noreferrer"&gt;try it in the playground&lt;/a&gt; without an account.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>ai</category>
      <category>sql</category>
      <category>opensource</category>
      <category>analytics</category>
    </item>
  </channel>
</rss>
