Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create a Simple Dashboard in Tableau with AI

Cody Schneider••8 min read

Creating a dashboard in Tableau doesn't need to be a multi-day project spent wrestling with complex menus and calculations. By using its built-in AI features, you can go from a raw data set to an insightful, shareable dashboard much faster than you think. This article will walk you through exactly how to create a simple dashboard using Tableau's AI to do most of the heavy lifting for you.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Bother with AI in Tableau?

Tableau is an incredibly powerful business intelligence tool, but that power often comes with a steep learning curve. For marketers, founders, and sales leaders, carving out dozens of hours to become a Tableau expert simply isn’t an option. You just need clear answers from your data, now.

This is where AI changes the game. Instead of manually dragging and dropping dimensions and measures, creating calculated fields, and figuring out which chart type works best, you can use natural language to tell Tableau what you want to see. This approach drastically speeds up the entire reporting process, moving you from raw data to actionable insight in a fraction of the time.

Think of it as having a junior data analyst by your side. You describe the report you need, and it builds a solid first draft for you to refine. This makes data analysis more accessible to everyone on your team, not just those with "analyst" in their job title.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step-by-Step: Creating a Tableau Dashboard with AI Features

For this tutorial, we'll use the "Sample - Superstore" dataset that comes included with Tableau, so you can easily follow along. Our goal is to create a simple sales performance dashboard that answers a few key questions:

  • Which states are our biggest markets?
  • What are our sales and profit trends over time?
  • Which product categories are the most profitable?

Let's get started.

Step 1: Connect to Your Data

Before you can ask questions, Tableau needs something to analyze. Connecting your data is always the first step. If you're building a dashboard for your own business, this is where you'd connect to Google Analytics, your Salesforce account, a SQL database, or even a simple Google Sheet or Excel file.

Since we're using the sample data:

  1. Open the Tableau Desktop application.
  2. In the "Connect" pane on the left, under "Saved Data Sources," select Sample - Superstore.
  3. Tableau automatically loads the data and takes you to the "Data Source" screen. You can see your columns and rows here. Click on the Sheet 1 tab at the bottom to move to the worksheet where the magic happens.
GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Step 2: Use "Ask Data" to Create Your First Visualizations

"Ask Data" is Tableau's natural language processing (NLP) feature. It allows you to type a question in plain English, and Tableau will automatically generate a chart or visualization to answer it. This is our primary AI-powered tool for building the dashboard components quickly.

Creating a Sales Map by State

Let's tackle our first question: "Which states are our biggest markets?"

  1. On the left-hand pane (where you see "Tables" and your data fields), you should see an "Ask Data" input box. If you don't, you may need to open a new worksheet.
  2. In the input box, simply type: "sales by state"
  3. As you type, Tableau suggests possible fields and interpretations. Once you hit enter, it will instantly generate a map of the United States, with states colored based on the sum of sales. Darker colors indicate higher sales.

Just like that, you have your first visualization. It understood "sales" as the metric and "state" as the geographical dimension and correctly chose a map as the best visual. Double-click on the "Sheet 1" tab and rename it "Sales Map."

Creating a Sales & Profit Trend Line Chart

Next, let's look at performance over time. Create a new worksheet by clicking the "New Worksheet" icon at the bottom.

  1. In the "Ask Data" box for this new sheet, type: "Sales and profit over time by month"
  2. Tableau will generate two line charts - one for Sales and another for Profit - plotted against the "Order Date" on a monthly basis. This lets you spot trends, seasonality, and the relationship between revenue and profitability at a glance.

Again, you didn't have to touch a single menu. The AI understood you wanted to see two different metrics ("Sales" and "Profit") along a time series dimension ("Order Date," broken down by month). Rename this sheet to "Monthly Trends."

Creating a Profitability Bar Chart

Finally, let's find out which product categories drive the most profit. Create one more worksheet.

  1. In the "Ask Data" box, type: "top categories by profit as bar chart"
  2. Tableau will create a horizontal bar chart that lists your product categories ("Technology," "Furniture," "Office Supplies") sorted by the sum of their profit.

This immediately answers our question - Technology is the most profitable category. You can even experiment with your questions, like asking "worst performing sub-categories by sales" to uncover different insights. For now, rename this sheet to "Profit by Category."

Step 3: Assemble Your Views into a Dashboard

Now that you have your three AI-generated charts, it's time to bring them together into a single dashboard.

  1. Click the "New Dashboard" icon at the bottom of the window (it looks like a grid).
  2. A blank canvas will appear. On the left side, under "Sheets," you will see the three worksheets you just created: "Sales Map," "Monthly Trends," and "Profit by Category."
  3. Simply drag and drop each sheet onto the canvas. By default, Tableau will try to arrange them in a tiled layout.
  4. Drag the corners and edges of each view to resize and arrange them in a way that makes sense. For instance, you might want your "Monthly Trends" line chart to be wider at the top, with the map and bar chart positioned side-by-side underneath.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 4: Add AI-Driven Explanations with Einstein

Building the visuals is only half the battle. The next step is interpreting them. Tableau's Einstein features can help explain why something happened in your data. Let's say you notice a big spike in sales in your "Monthly Trends" chart. You want to know what caused it.

  1. Go to your dashboard and click on that specific data point on the line chart.
  2. A tooltip will pop up. In that tooltip, you'll see a lightbulb icon for "Explain Data." Click on it.
  3. Tableau will analyze the underlying data for that specific month and generate several AI-powered explanations. It might tell you the sales spike was driven by a single large order, unusually high sales of a particular product category, or strong performance in a specific region.

This takes you from "what happened?" to "why did it happen?" without requiring you to manually slice and dice the data yourself.

Tips for Getting the Most Out of Tableau's AI

AI tools are powerful, but they work best when you guide them properly. Here are a few tips:

  • Keep Your Data Clean: AI can't fix messy data. Ensure your column headers are clear and descriptive (e.g., "Customer Name" instead of "C_Name"). This helps the natural language model understand what it's looking at.
  • Start with Simple Questions: Begin with straightforward requests like "Sales by Region" before moving to more complex queries like "year over year sales growth for technology category in the west region."
  • Learn the Lingo: While you can use plain English, the AI works best when you use the names of your metrics and dimensions directly. For example, "Show me Profit and Sales for each Category" is a very clear and effective prompt.
  • Iterate and Refine: Use "Ask Data" to get your initial chart, then use the standard Tableau interface ("Show Me," colors, filters) to fine-tune it. The AI doesn't have to do 100% of the work - it's there to save you time on the initial heavy lifting.

Final Thoughts

Integrating AI features like "Ask Data" and "Explain Data" into your Tableau workflow can dramatically cut down the time it takes to build insightful dashboards. By translating plain English questions into polished visualizations, Tableau empowers more team members to explore data and find answers without needing to be analytics experts.

While Tableau’s AI is a big step forward, we believe getting insights shouldn’t require learning a complex new tool at all. At Graphed , we're focused on making data analysis as simple as having a conversation. We allow you to connect all your marketing and sales data sources in one click and then build entire dashboards using prompts like "show me a report comparing ad spend vs. revenue by campaign." Instead of manually building charts and drilling down, you can simply chat with your data to get answers in seconds, not hours.

Related Articles