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.