What Are the 3 Types of Tableau?

Most people talk about Tableau as if it's a single piece of software, but it's really an ecosystem of products designed for different stages of the data analysis process. Understanding the key players in this ecosystem is the first step to figuring out how they fit into your own reporting goals. We'll walk through the three main types of Tableau you’ll encounter: Tableau Desktop, Tableau Prep, and the sharing platforms, Tableau Cloud and Server.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tableau Desktop: The Design Studio

Think of Tableau Desktop as the main workshop or design studio where all the creative work happens. It's a powerful application you install directly on your Mac or PC, and it's where you'll spend most of your time if you're the one building reports. This is where you connect to your raw data, explore it, and turn it into the interactive charts, maps, and dashboards that people associate with the Tableau name.

What It's For

The primary job of Tableau Desktop is authoring. It’s where analysts and developers roll up their sleeves to create compelling data visualizations from scratch. You take tables of raw numbers and transform them into something intuitive that tells a story and helps business leaders make decisions.

Who Uses It?

This tool is built for the "doers" - the data analysts, BI specialists, marketing analysts, and data-savvy business users who are responsible for building and maintaining reports. If your job involves answering complex business questions by designing a dashboard, Tableau Desktop is your primary tool.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Key Features

• Broad Data Connectivity: You can connect to a huge variety of data sources, from local Excel and CSV files to massive cloud databases like Redshift, Snowflake, and Google BigQuery.
• Drag-and-Drop Interface: The core of Tableau's appeal is its "VizQL" engine, which translates your drag-and-drop actions into data queries. You can build complex charts without writing a single line of SQL.
• Calculated Fields: You can create new data points from your existing data on the fly. For instance, you could create a "Profit Ratio" by writing a simple formula like SUM([Profit]) / SUM([Sales]).
• Interactive Dashboards and Stories: This is where it all comes together. You can combine multiple worksheets (individual charts and graphs) into a single interactive dashboard. You can also build "Stories," which are guided, sequential narratives that walk viewers through your data-driven findings, step by step.

Example in action:

A marketing manager uses Tableau Desktop to connect to a Google Analytics account and a Google Sheet containing ad spend data. She joins the two sources, drags "Campaign Name" to the columns shelf and "Revenue" to the rows shelf to create a bar chart. She then adds a filter for "Date" so the team can see performance for any given time period, and publishes the finished dashboard for her team to review.

Tableau Prep: The Data Cleaner

Analytics is often glamourously portrayed as all about building beautiful charts, but the reality is that 80% of the work is often data preparation. Data rarely arrives in a perfectly structured, clean format ready for analysis. This is where Tableau Prep comes in.

If Tableau Desktop is the design studio, think of Tableau Prep as the professional kitchen where you wash, chop, and combine all your ingredients before you start cooking. It consists of two interconnected products: Prep Builder for creating data cleaning "flows," and Prep Conductor for automating them.

What It's For

Tableau Prep is exclusively for data preparation - the process often called ETL (Extract, Transform, Load). Its job is to help you clean, combine, shape, and reshape messy data from multiple sources so it’s ready for analysis in Tableau Desktop. You aren't building charts here, you're building a repeatable, visual process for tidying up your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Who Uses It?

Anyone who works with messy data will find Tableau Prep useful. It’s primarily used by data analysts and BI developers, but it’s visual enough that marketers or operations managers who need to blend different files (like a weekly export from Salesforce and an ad platform) can also find their way around it.

Key Features

• Visual Data Flows: Instead of writing complex scripts, you build a "flow." Each step in your cleaning process - like filtering out null values, changing a data type from a number to a string, or pivoting columns into rows - is represented as a visual block in a flowchart.
• Smart Cleaning Suggestions: Prep is intelligent enough to analyze your data and offer one-click suggestions for common cleaning tasks, such as grouping values with slight misspellings (e.g., "California," "Calif.", "CA") into a single, consistent value.
• Joining and Unioning: It makes it incredibly simple to combine different data sets. You can visually perform a SQL-like join to merge a table of customer orders with a table of customer details, or union multiple monthly sales files into one master file.
• Clean Data Output: The end result of a Prep flow is a pristine, ready-for-analysis data source (often a Tableau .hyper file) that you can connect to directly from Tableau Desktop.

Example in action:

A sales analyst has three different spreadsheets, one for each region (North America, EMEA, APAC). In Tableau Prep, she unions them into a single table, cleans up a column where country names are inconsistent, and creates a calculated field for commission. She then outputs the clean, consolidated file as a single data source.

Tableau Cloud & Tableau Server: The Sharing Platform

Once you’ve built a masterpiece dashboard in Tableau Desktop, it’s not very useful if it only lives on your laptop. You need a way to share it securely with decision-makers, stakeholders, and colleagues. This is the role of Tableau Cloud and Tableau Server.

These two products serve the exact same function: they are centralized hubs for managing, sharing, and collaborating on Tableau content. The only real difference between them is who manages the hardware.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What's the Difference?

• Tableau Cloud (formerly Tableau Online): This is the SaaS (Software-as-a-Service) version. It's fully hosted and managed by Tableau (now Salesforce). You don’t have to worry about servers, maintenance, or upgrades - you just log in through your web browser and start publishing.
• Tableau Server: This is the self-hosted version. Your company is responsible for installing and maintaining Tableau on your own servers, whether they're on-premise in your own data center or in a private cloud environment like AWS or Azure. This gives you more control over the hardware, data governance, and update schedules, but also requires dedicated IT resources.

Who Uses It?

Nearly everyone in a data-driven organization interacts with Tableau Cloud or Server.

• Publishers (Analysts, Developers): They use these platforms to upload their finished workbooks from Tableau Desktop.
• Viewers (Executives, Managers, Stakeholders): They are the primary consumers. They log in to view dashboards, apply filters to explore the data, and get the insights they need to do their jobs without needing Tableau Desktop at all.

Key Features

• Centralized Hub for Dashboards: All your organization's official reports and dashboards live in one place, organized into projects and folders.
• Security and Permissions: Administrators can set granular permissions, controlling exactly who can see which dashboards and what they're allowed to do (e.g., view, filter, download the data, etc.).
• Scheduled Data Refreshes: A dashboard's data isn't static. You can schedule it to automatically refresh its connection to the underlying data source - every hour, every day, or every week - so the insights are always current.
• Subscriptions and Alerts: Users can subscribe to dashboards and have a snapshot delivered to their inbox on a schedule. They can also set up data-driven alerts, like receiving an email if sales drop below a certain threshold.

How They Work Together: The Full Tableau Workflow

These three products are designed to work together as part of a seamless data pipeline.

1. Step 1 - Data Prep (Tableau Prep): You start by connecting to your raw, often messy data sources. You build a visual flow to clean, combine, and structure the data into an analysis-ready format.
2. Step 2 - Visualization (Tableau Desktop): You open Tableau Desktop and connect to the clean data source created by Prep. Here, you explore the data, create your charts and tables, and assemble them into a user-friendly, interactive dashboard.
3. Step 3 - Sharing (Tableau Cloud/Server): Once your dashboard is complete, you publish it from Tableau Desktop to your organization's Tableau Cloud site or Tableau Server.
4. Step 4 - Consumption: Your colleagues can then log into Tableau Cloud/Server via their web browser to view your dashboard, drill down into an interesting data point, and make informed business decisions based on always-current data.

Final Thoughts

Tableau isn't one software but a comprehensive suite designed to handle the entire analytics workflow. Tableau Prep organizes your raw data, Tableau Desktop is where you build visualizations, and Tableau Cloud or Server is where you share those insights with the rest of your organization.

While this is an incredibly powerful system, learning the full Tableau stack requires a significant investment in time and training. If that whole workflow sounds more complex than what your team needs, you're not alone. Many teams waste half the week manually exporting CSVs and fighting with BI tools just to get straightforward answers. At Graphed , we automate all of that by connecting directly to your marketing and sales platforms. You can create real-time dashboards and get answers instantly just by asking questions in plain English, allowing you to skip the reporting grind and focus on what the data actually means.