Publishing to Tableau Public - Deep Dive

Overview - Publishing to Tableau Public

What is it?

Publishing to Tableau Public means sharing your interactive data visualizations and dashboards online for anyone to see. Tableau Public is a free platform where you can upload your work and make it accessible through a web browser. This allows you to showcase your data stories without needing special software or permissions.

Why it matters

Without publishing, your Tableau dashboards stay on your computer, limiting who can see or use them. Publishing to Tableau Public solves the problem of sharing insights easily and widely, helping people make data-driven decisions. It also builds your reputation by showing your skills and work to the world.

Where it fits

Before publishing, you should know how to create dashboards and use Tableau Desktop basics. After learning to publish, you can explore embedding dashboards in websites, collaborating with others, or using Tableau Server for private sharing.

Mental Model

Core Idea

Publishing to Tableau Public is like putting your data story in a public gallery where anyone can visit and interact with it anytime.

Think of it like...

Imagine you painted a picture and want to show it to friends and strangers. Instead of keeping it at home, you hang it in a public art gallery where everyone can admire and learn from it.

┌───────────────────────────────┐
│ Create Dashboard in Tableau    │
├──────────────┬────────────────┤
│ Save Locally │ Publish Online  │
│              │ to Tableau      │
│              │ Public Platform │
├──────────────┴────────────────┤
│ Anyone with Link Can View &    │
│ Interact with Your Dashboard  │
└───────────────────────────────┘

Build-Up - 7 Steps

1

Foundation

Understanding Tableau Public Platform

Concept: Introduce what Tableau Public is and its purpose.

Tableau Public is a free online service where you can upload and share your Tableau visualizations. It is designed for public sharing, meaning anyone can see your published work. You need a Tableau Public account to publish and manage your dashboards.

Result

You know where and why Tableau Public exists as a platform for sharing data stories publicly.

Understanding the platform's purpose helps you decide when public sharing fits your goals and when it doesn't.

2

Foundation

Preparing Your Dashboard for Publishing

Concept: Learn how to get your dashboard ready before publishing.

Before publishing, clean your data, finalize your visualizations, and remove any sensitive information. Make sure your dashboard is clear, interactive, and performs well. Save your workbook locally in Tableau Desktop.

Result

Your dashboard is polished and safe to share publicly.

Preparing your dashboard carefully prevents accidental sharing of private data and improves viewer experience.

3

Intermediate

Creating a Tableau Public Account

Concept: Set up the account needed to publish dashboards online.

Go to the Tableau Public website and sign up for a free account using your email. Verify your email and log in. This account will store your published dashboards and provide a profile page for your work.

Result

You have an active Tableau Public account ready to receive your dashboards.

Having your own account gives you control over what you share and how others find your work.

4

Intermediate

Publishing Dashboard from Tableau Desktop

🤔Before reading on: Do you think publishing requires exporting files manually or a direct upload from Tableau Desktop? Commit to your answer.

Concept: Learn the step-by-step process to publish directly from Tableau Desktop to Tableau Public.

In Tableau Desktop, open your dashboard. Click 'File' then 'Save to Tableau Public'. Log in with your Tableau Public account if prompted. Choose a name for your workbook and confirm. Tableau uploads your dashboard online and opens it in your browser.

Result

Your dashboard is live on Tableau Public and accessible via a unique URL.

Knowing the direct publishing workflow saves time and avoids manual file handling errors.

5

Intermediate

Managing Published Dashboards on Tableau Public

Concept: Understand how to organize, update, and control your published dashboards.

Log in to your Tableau Public profile online. Here you can see all your published dashboards, edit their titles and descriptions, and delete or update them by republishing from Tableau Desktop. You can also get embed codes to share dashboards on websites.

Result

You can keep your public portfolio organized and up-to-date.

Managing your published work ensures your audience always sees your best and latest insights.

6

Advanced

Optimizing Dashboards for Public Sharing

🤔Before reading on: Do you think dashboards published publicly need special performance or privacy considerations? Commit to your answer.

Concept: Learn how to improve dashboard performance and protect privacy when publishing publicly.

Optimize your dashboard by reducing data size, limiting filters, and simplifying calculations to load faster online. Remove any confidential data or replace it with aggregated or anonymized versions. Test your dashboard on different devices and browsers to ensure usability.

Result

Your published dashboards load quickly and respect privacy, improving user experience.

Optimizing for public use prevents slow loading and accidental data leaks that can harm your reputation.

7

Expert

Understanding Tableau Public Limitations and Workarounds

🤔Before reading on: Do you think Tableau Public supports all Tableau Desktop features and data sources? Commit to your answer.

Concept: Explore the limits of Tableau Public and how experts handle them.

Tableau Public does not support connecting to private databases or saving workbooks locally with live connections. It only supports extracts and public data sources. Experts use data extracts and prepare data beforehand. They also use Tableau Server or Tableau Online for private or advanced sharing needs.

Result

You understand when Tableau Public fits your project and when to choose other Tableau products.

Knowing these limits helps avoid frustration and guides you to the right tool for your sharing needs.

Under the Hood

When you publish to Tableau Public, Tableau Desktop packages your dashboard and data extract into a workbook file. This file is uploaded to Tableau's cloud servers, where it is processed and made interactive through web technologies like JavaScript and HTML5. The server hosts your workbook and generates a unique URL and embed code. When users visit your dashboard online, their browsers load the interactive visualization without needing Tableau software.

Why designed this way?

Tableau Public was designed as a free, easy-to-use platform to encourage data sharing and community building. By using cloud hosting and web standards, Tableau avoids requiring viewers to install software. The limitation to extracts and public data ensures security and performance in a shared environment. Alternatives like Tableau Server exist for private, enterprise-grade sharing.

┌───────────────┐       ┌───────────────┐       ┌───────────────┐
│ Tableau      │       │ Tableau       │       │ Web Browser   │
│ Desktop      │──────▶│ Public Server │──────▶│ Loads &       │
│ (Create &    │ Upload│ (Stores &     │ Serve │ Interacts     │
│ Publish)     │       │ Hosts Workbooks)│     │ Dashboard     │
└───────────────┘       └───────────────┘       └───────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Do you think Tableau Public can connect to your private company database live? Commit to yes or no.

Common Belief: Tableau Public can connect live to any data source, including private databases.

Reality: Tableau Public only supports data extracts and public data sources; live connections to private databases are not allowed.

Why it matters: Believing this causes users to waste time trying to publish dashboards that rely on live private data, leading to errors and confusion.

Quick: Do you think dashboards published to Tableau Public are private by default? Commit to yes or no.

Common Belief: Dashboards on Tableau Public are private and only shared with people I choose.

Reality: Tableau Public dashboards are public and visible to anyone on the internet.

Why it matters: Misunderstanding this can lead to accidental exposure of sensitive or confidential data.

Quick: Do you think you can save Tableau Public workbooks locally with live data connections? Commit to yes or no.

Common Belief: You can save Tableau Public workbooks locally and keep live data connections intact.

Reality: Tableau Public workbooks are saved on the cloud and only support extracts, not live connections.

Why it matters: This misconception leads to workflow errors and loss of live data refresh capabilities.

Quick: Do you think Tableau Public dashboards load instantly regardless of size? Commit to yes or no.

Common Belief: Publishing to Tableau Public means dashboards always load instantly online.

Reality: Large or complex dashboards can load slowly on Tableau Public due to data size and web limitations.

Why it matters: Ignoring performance optimization can frustrate users and reduce dashboard effectiveness.

Expert Zone

1

Tableau Public strips out some advanced Tableau Desktop features like user filters and certain extensions to maintain security and performance.

2

Published dashboards on Tableau Public can be embedded in blogs or websites, but embedding requires understanding iframe and web security policies.

3

Tableau Public profiles act as portfolios; experts use them to showcase their best work and build professional visibility.

When NOT to use

Tableau Public is not suitable when you need to keep data private, use live database connections, or require enterprise-level governance. In these cases, use Tableau Server or Tableau Online instead.

Production Patterns

Professionals use Tableau Public to share public reports, educational dashboards, and portfolio work. They prepare data extracts carefully, optimize dashboards for web performance, and update published work regularly to keep insights fresh.

Connections

Cloud Storage Services

Similar pattern of uploading and sharing files online

Understanding how cloud storage works helps grasp how Tableau Public hosts and serves dashboards to users worldwide.

Web Hosting and Content Delivery Networks (CDNs)

Builds on the idea of delivering content efficiently over the internet

Knowing about CDNs explains why Tableau Public dashboards load quickly and reliably for users everywhere.

Open Data Movement

Shares the goal of making data accessible and transparent to the public

Recognizing Tableau Public as part of open data culture highlights its role in democratizing data insights.

Common Pitfalls

#1 Publishing dashboards with sensitive data accidentally included.

Wrong approach:

Publishing a dashboard directly without reviewing data privacy:
File > Save to Tableau Public > Upload without data check.

Correct approach:

Before publishing, remove or anonymize sensitive data:
Create data extracts with aggregated data > Review dashboard > Then publish.

Root cause:

Lack of awareness about Tableau Public's public visibility and data privacy risks.

#2 Trying to use live database connections with Tableau Public.

Wrong approach:

Connecting live to a private SQL database and publishing:
Data Source > Connect Live > Publish to Tableau Public.

Correct approach:

Use data extracts instead:
Extract data locally > Connect to extract > Publish workbook.

Root cause:

Misunderstanding Tableau Public's technical limitations on data connections.

#3 Ignoring dashboard performance optimization before publishing.

Wrong approach:

Publishing large dashboards with many filters and complex calculations without testing.

Correct approach:

Simplify calculations, limit filters, test loading speed > Then publish optimized dashboard.

Root cause:

Underestimating the impact of web performance on user experience.

Key Takeaways

Publishing to Tableau Public shares your dashboards openly on the web for anyone to access and interact with.

Tableau Public requires a free account and only supports data extracts, not live private connections.

Preparing and optimizing your dashboard before publishing protects privacy and improves performance.

Managing your published dashboards online lets you update, organize, and share your work effectively.

Knowing Tableau Public’s limits helps you choose the right Tableau product for your data sharing needs.

Practice

1. What is the main purpose of publishing a dashboard to Tableau Public?

easy

A. To create backups of your dashboards on your local computer

B. To share your dashboards online for free and make them visible to everyone

C. To export dashboards as PDF files for offline use

D. To keep your dashboards private and only accessible to you

Solution

1. Step 1: Understand Tableau Public's sharing feature

   Tableau Public allows users to share dashboards online for free, making them accessible to anyone with internet access.

2. Step 2: Compare options with this feature

   Options A, B, and C describe private use, exporting, or backups, which are not the main purpose of Tableau Public.

3. Final Answer:

   To share your dashboards online for free and make them visible to everyone -> Option B

4. Quick Check:

   Publishing to Tableau Public = Free public sharing [OK]

Hint: Remember: Tableau Public dashboards are always visible to all [OK]

Common Mistakes:

• Thinking Tableau Public keeps dashboards private
• Confusing publishing with exporting files
• Assuming publishing creates local backups

2. Which of the following is the correct first step to publish a workbook to Tableau Public?

easy

A. Sign in to your Tableau Public account within Tableau Desktop

B. Export the workbook as a PDF file

C. Save the workbook on your local computer without signing in

D. Create a new Tableau Server project

Solution

1. Step 1: Identify the publishing process

   Publishing to Tableau Public requires signing in to your Tableau Public account inside Tableau Desktop.

2. Step 2: Eliminate incorrect options

   Exporting as PDF, saving locally without signing in, or creating Tableau Server projects are unrelated to publishing on Tableau Public.

3. Final Answer:

   Sign in to your Tableau Public account within Tableau Desktop -> Option A

4. Quick Check:

   Sign in first to publish [OK]

Hint: Always sign in to Tableau Public before publishing [OK]

Common Mistakes:

• Trying to publish without signing in
• Confusing Tableau Public with Tableau Server
• Exporting instead of publishing

3. After signing in and naming your workbook, what happens when you click Save to Tableau Public?

medium

A. Your workbook is saved locally but not shared online

B. Your workbook is saved privately and only you can access it

C. Your workbook is emailed to your Tableau Public contacts

D. Your workbook is uploaded and becomes publicly visible on Tableau Public

Solution

1. Step 1: Understand the save action in Tableau Public

   Clicking 'Save to Tableau Public' uploads your workbook to the Tableau Public website, making it publicly accessible.

2. Step 2: Review other options

   Options A, C, and D describe local saving, emailing, or private saving, which do not happen when publishing to Tableau Public.

3. Final Answer:

   Your workbook is uploaded and becomes publicly visible on Tableau Public -> Option D

4. Quick Check:

   Save to Tableau Public = Upload and public visibility [OK]

Hint: Save to Tableau Public means upload and share publicly [OK]

Common Mistakes:

• Assuming saving only stores locally
• Thinking the workbook is emailed automatically
• Believing the workbook remains private

4. You tried to publish your workbook to Tableau Public but received an error saying you are not signed in. What should you do to fix this?

medium

A. Export the workbook as an image instead

B. Restart your computer and try publishing without signing in

C. Sign in to your Tableau Public account inside Tableau Desktop and try publishing again

D. Delete the workbook and create a new one

Solution

1. Step 1: Identify the cause of the error

   The error indicates you are not signed in, which is required to publish to Tableau Public.

2. Step 2: Correct the issue by signing in

   Signing in inside Tableau Desktop allows you to authenticate and publish your workbook successfully.

3. Final Answer:

   Sign in to your Tableau Public account inside Tableau Desktop and try publishing again -> Option C

4. Quick Check:

   Sign in to fix publishing errors [OK]

Hint: Always sign in before publishing to avoid errors [OK]

Common Mistakes:

• Ignoring the sign-in requirement
• Restarting without signing in
• Trying unrelated export options

5. You want to publish a dashboard to Tableau Public but keep some data private. Which approach is best?

hard

A. Remove or anonymize sensitive data before publishing the workbook

B. Publish normally and trust Tableau Public to hide private data

C. Publish the workbook and then delete it immediately

D. Publish the workbook but set a password to restrict access

Solution

1. Step 1: Understand Tableau Public's privacy model

   Tableau Public makes all published content visible to everyone; it does not support private or password-protected workbooks.

2. Step 2: Choose a method to protect sensitive data

   Removing or anonymizing sensitive data before publishing ensures private information is not exposed.

3. Final Answer:

   Remove or anonymize sensitive data before publishing the workbook -> Option A

4. Quick Check:

   Protect privacy by cleaning data before publishing [OK]

Hint: Clean sensitive data before publishing to keep it private [OK]

Common Mistakes:

• Assuming Tableau Public hides private data automatically
• Trying to password-protect Tableau Public workbooks
• Publishing then deleting to hide data