Leave a Reply

Your email address will not be published. Required fields are marked *

How to Make Your First Tableau Dashboard

Updated on: Sep 4th, 2023
Dashboards
,

Want to get started with Tableau?

Here’s a step-by-step guide to making your very first Tableau dashboard.

In less than an hour, you’ll be able to install the free version of Tableau, add your dataset, create a few charts, and then combine then into a dashboard. You’ll still have time left for formatting, too.

Step 1: Figure Out Which Version of Tableau You Need

There are a few options:

  • Public: Free BUT your datasets and graphs will be publicly available.
  • Desktop: Paid; about USD $1,000/year per user.
  • Server: Paid.

This article compares the versions in more detail.

Step 2: Download Tableau Public

If this is your very first dashboard, I’d recommend starting with the free version, Tableau Public.

Here’s how you’ll install it:

Step 3: Import or Connect Your Dataset

Now, you’ll need to connect your dataset to Tableau.

You can add datasets from Excel, Sheets, QuickBooks, etc.

In this example, let’s pretend we’re visualizing demographic data from an Excel spreadsheet, like this:

Here’s how you’ll add your dataset to Tableau:

  • Open Tableau Public.
  • Connect to a File: Microsoft Excel. Open your file.
  • You’ll see the names of the Excel Sheets on the left.
  • Drag in the sheet(s) you want to use for your Tableau dashboard.
  • Pre-filter if needed.
  • Connect multiple tables if needed. Joins combine the columns of two datasets, and unions combine the rows of two datasets. Joins are most similar to lookup functions in Excel. Unions are most often used when more data is coming in, and you need to add more rows to the bottom of the dataset.

The preview of your spreadsheet will look like this inside Tableau:

Step 4: Drag and Drop Variables to Create One Visual at a Time

We’ll build one chart at a time. Then, in a moment, we’ll combine them into a dashboard.

First, let’s visualize the Work Setting data in Sheet 1. We would drag Work Setting into Rows and Demographics (Count) into Columns. Congrats! You’ve got your first bar chart.

Next, we’ll drag and drop variables to create a Years of Experience histogram.

Finally, we’ll create a color-coded (“choropleth”) map by State.

We’ll create a bar or column chart first, and then simply change it into a map with the Show Me menu.

Step 5: Combine the Sheets into a Dashboard

Now, let’s combine our three individual graphs into a single dashboard.

Here’s how:

  • Along the bottom, click on the icon to create a New Dashboard.
  • Then, in the Dashboard tab on the left:
    • Choose the device (Desktop, Tablet, phone, etc.).
    • Adjust the size as needed.
    • Drag the Sheets into the main dashboard area.
    • Add Objects as needed (e.g., Blank to add some white space between visuals).
    • The individual graphs can be tiled or floating. I prefer tiled.
    • Check the box to Show dashboard title.

Step 6: Format, Format, Format!

It’s easy to create graphs in Tableau.

Like many software programs, it’s not so easy to format them to be Accessible (508/ADA compliant) and accessible (intuitive).

Here are some bare-minimum edits to get you started.

Apply brand fonts. Go to Format –> Workbook to change all the fonts in your file at the same time (rather than changing one visual at a time). Here’s an article with more info.

Apply brand colors. I personally just go to Marks –> Colors –> More Colors and enter the RGB or HEX codes. Or, here’s an article with a coding option.

I love color-coding by category (i.e., one brand color per graph). This is an easy way to make a dense dashboard feel not-so-dense.

Apply a text hierarchy. Make sure the dashboard title is largest, boldest, and darkest. You’ll also need Heading 1s, and you might need Heading 2s.

As usual, left-aligned text is faster to read then centered or justified text.

As usual, horizontal text is faster to read than diagonal or vertical text.

Don’t forget to turn bulleted tooltips into complete sentences for an extra boost of accessibility.

Your formatted dashboard might look something like this:

Step 7: Share the Dashboard

That’s it! Let’s share it with colleagues.

In the upper left corner, click on File. Choose Save to Tableau Public. Log in. Or, create a username.

Once the dashboard is saved to Tableau Public, you can save the dashboard as an image file, a PDF, a PowerPoint slide, etc.

Learn More

If you’d like to learn more about getting started with Tableau, check out Dashboard Design. This 4-course bundle includes a half-day course on Tableau.

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Leave a Reply

Your email address will not be published. Required fields are marked *

You Might Like

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

Want to wow your boss with a dynamic dashboard? Or, how about a one-pager of key findings? Our 4-course bundle provides all the how-to’s.

Enroll

Subscribe

Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.