Skip to content
Tutorials Center
My learning

Topics

Lesson 1 of 35 ยท Welcome to Tableau

What Is Tableau? Products, Installation and Core Ideas

Learn what Tableau is, how its products fit together (Desktop, Public, Cloud, Server, Prep), how to install it, and the terms you need before building your first view.

Tableau is a visual analytics tool. You connect it to data, drag fields onto a canvas, and it draws a chart and writes the query behind the scenes. You then combine charts into dashboards that people can filter and explore. It is popular because the loop from question to answer is fast: drag, look, adjust, repeat.

This course is practical. Tableau is a desktop and web application, so it cannot run inside this page. Instead, each lesson explains the clicks, shows the calculations as read-only code, and gives you small runnable stand-ins (SQL or Python) that reproduce what Tableau computes. When a block below is a stand-in, we say so. The stand-in is not Tableau; it is a way to see the numbers Tableau would show.

The Tableau product family

"Tableau" is a family of products. Knowing which is which saves confusion, because the names change over the years and your company may license only some of them.

Build it

Tableau Desktop Author workbooks on Windows or Mac
Tableau Prep Clean and reshape data in flows
Tableau Public Free, but everything is public

Authoring tools: you create content here.

1 / 3
  • Tableau Desktop is where most authors work. You connect to data, build worksheets, assemble dashboards, and save a workbook.
  • Tableau Public has a free desktop application, but it can only save to the public Tableau Public website. Never use it for private data. It is the right tool for learning and for a portfolio.
  • Tableau Prep Builder is a separate app for visual data cleaning flows. Chapter 2 covers the cleaning you can do inside Desktop.
  • Tableau Cloud (the hosted service, formerly Tableau Online) and Tableau Server (installed on your servers) publish workbooks so colleagues use them in a browser.
  • Creator, Explorer and Viewer are license roles. Creators author and prepare data, Explorers edit existing content on the web, Viewers consume it.

Product names and plans change. Check Tableau's current website for the exact bundle your organization has before you plan around a feature such as Prep or the web editor.

Installing Tableau

You have two common routes.

  1. Tableau Public Desktop (free). Download the installer from Tableau's site, run it and sign in with a free account. Good for this course, as long as your practice data is not confidential.
  2. Tableau Desktop (trial or licensed). Download the installer from your account page or from your IT department, run it, and enter the license key or sign in. The trial runs for a limited number of days.

After installing, the first time you connect to a database you may be asked for a driver. Tableau ships connectors for many sources, but the vendor's driver for some databases (for example Oracle or some JDBC sources) must be installed separately from Tableau's Driver Download page. Pick your database, your operating system and the Tableau version, install the driver, and restart Tableau. Chapter 2 covers connecting in detail.

Tableau versus other tools

Tool Where it shines
Tableau Fast exploratory visuals, rich chart types, strong calculations (LOD, table calcs), big user community
Power BI Tight Microsoft integration, DAX modeling, low cost for Microsoft shops
Looker Studio (formerly Google Data Studio) Free, web-based, easy sharing, best with Google sources; lighter calculation power
Excel Ad hoc analysis and small data; charts are manual and less interactive

None of them is "best". The honest advice: choose the one your data and your team already live in, and learn the concepts, because they transfer.

Core terms

You will see these words in every lesson.

  • Data source: the connection (a file, database or cloud service) plus any joins and calculations you define on it.
  • Workbook: the file you save. It contains data sources, worksheets (single charts), dashboards (layouts of worksheets) and stories (sequences of views).
  • Field: a column of your data. Fields are either dimensions (categories you slice by, like Region) or measures (numbers you aggregate, like Sales).
  • Mark: one visual item in a chart (a bar, a dot, a map shape). The Marks card controls how marks look.
  • Shelf: a drop zone such as Columns, Rows or Filters. Fields placed on a shelf become pills.
  • View: the chart you get from your pills and marks.
  • Aggregation: summarizing many rows into one number (sum, average, count).

How Tableau thinks: a view is a query

This is the idea that makes everything else click. When you put Region on Rows and SUM(Sales) on Columns, Tableau does the same job as a GROUP BY: it groups rows by the dimension and aggregates the measure. Every pill on a shelf changes either the grouping (dimensions) or the number being computed (measures).

flowchart LR
    A["Data source<br/>(rows and columns)"] --> B["Pills on shelves<br/>(dimensions + measures)"]
    B --> C["Query<br/>(GROUP BY + aggregates)"]
    C --> D["Marks drawn<br/>(bars, lines, maps)"]
    D --> E["Dashboard<br/>(combined, filterable)"]

From rows to a dashboard: you choose the pills, Tableau writes the query and draws the marks.

Try it: the query behind a bar chart (stand-in)

This is not Tableau; it is a SQL stand-in on a small orders table that we reuse throughout the course. The query is what Tableau effectively runs when you drag Region to Rows and Sales to Columns.

SQL Stand-in: Region on Rows, SUM(Sales) on Columns

Press Run (or Ctrl + Enter) to see the result here.

Now add a second dimension. In Tableau, dragging Category to Color adds it to the grouping, so every bar is split into segments. The SQL equivalent adds a column to GROUP BY.

SQL Stand-in: add Category to Color

Press Run (or Ctrl + Enter) to see the result here.

Each result row is one mark. Twelve orders became a handful of marks because Tableau shows the aggregated level, not the raw rows. You will meet exceptions (a dimension on Detail, or turning aggregation off) later in the course.

Common beginner mistakes

  • Treating Tableau as a spreadsheet. You do not type numbers into cells. You describe the view with pills.
  • Using Tableau Public for private data. Anything saved there is visible to the world.
  • Skipping the data-type check. A number stored as text will not aggregate. Lesson 3 covers it: Data types and roles.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which product is free but only saves workbooks to a public website?

    Tableau Public has a free desktop app, but its workbooks are saved to the public Tableau Public site, so it is unsuitable for private data.
  2. 2. What does a Tableau view do when you place a dimension and a measure on shelves?

    Dimensions set the grouping level and measures are aggregated, which is why each mark usually represents many rows.
  3. 3. Which license role is meant for people who only open and filter finished dashboards?

    Viewers consume content. Explorers can edit on the web and Creators can connect to data and build.
  4. 4. What is a mark?

    Marks are the bars, lines, dots and shapes drawn for each group; the Marks card controls their appearance.

Summary

  • Tableau turns pills on shelves into an aggregated query and draws marks for the result.
  • The family: Desktop and Prep to build, Public, Cloud and Server to share; Creator, Explorer and Viewer are license roles.
  • Dimensions group the data; measures are aggregated.
  • A workbook holds data sources, worksheets, dashboards and stories.
  • In this course, runnable blocks are SQL or Python stand-ins that show the numbers Tableau computes.

Next: Workspace, navigation and file types