Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Tableau Publishing and Sharing

Learn how to publish Tableau workbooks and dashboards to Tableau Server and Tableau Cloud, manage permissions, share visualizations, and schedule data refreshes.

1. Introduction to Tableau Publishing and Sharing

Tableau Publishing and Sharing is the process of making Tableau workbooks, dashboards, and data sources available to other users through a centralized platform.

After developing a workbook in Tableau Desktop, developers can publish it to Tableau Server or Tableau Cloud. Authorized users can then access dashboards using a web browser or supported Tableau applications.

Key Concept: Publishing makes Tableau content available to other users, while sharing and permissions control who can access and interact with that content.

Why Is Publishing Important?

  • Allows users to access dashboards from different locations.
  • Provides centralized access to reports and workbooks.
  • Supports collaboration between teams.
  • Helps organizations distribute business insights.
  • Provides centralized permission management.
  • Supports scheduled data refreshes for published content.

2. Tableau Publishing Platforms

Tableau provides different platforms for publishing and sharing analytical content. Two commonly used platforms are Tableau Server and Tableau Cloud.

2.1 Tableau Server

Tableau Server is an enterprise platform that organizations can deploy and manage within their own infrastructure or supported hosting environment.

  • Provides centralized workbook and data source management.
  • Supports user authentication and permissions.
  • Allows teams to share dashboards securely.
  • Supports extract refresh schedules.
  • Provides administrative and monitoring capabilities.

2.2 Tableau Cloud

Tableau Cloud is a hosted analytics platform managed by Tableau. Organizations can publish content without maintaining their own Tableau Server infrastructure.

  • Provides hosted access to Tableau content.
  • Supports sharing dashboards with authorized users.
  • Provides content and permission management.
  • Supports supported data refresh and connectivity options.
  • Reduces the need to manage underlying server infrastructure.
Feature Tableau Server Tableau Cloud
Hosting Managed by the organization. Hosted and managed by Tableau.
Infrastructure Organization manages infrastructure. Tableau manages the cloud platform.
Administration Server administration is required. Platform infrastructure administration is handled by Tableau.
Content Sharing Supported through permissions and projects. Supported through permissions and projects.
Data Connectivity Depends on deployment and configuration. Depends on supported connectors and connectivity configuration.

3. Tableau Publishing Architecture

Tableau publishing involves transferring a workbook from the development environment to a centralized Tableau platform. Users access the published content according to their permissions.

Tableau Desktop Create Workbook Publish Content Upload Workbook Tableau Platform Server / Cloud Authorized Users Development Publishing Hosting and Sharing
Diagram 1: Tableau workbook publishing architecture.

Publishing Workflow

  1. Create a workbook in Tableau Desktop.
  2. Connect and prepare the required data.
  3. Build worksheets and dashboards.
  4. Save and validate the workbook.
  5. Connect to Tableau Server or Tableau Cloud.
  6. Select the destination project.
  7. Publish the workbook.
  8. Configure permissions and verify user access.

4. How to Publish a Tableau Workbook

Tableau Desktop provides options to publish workbooks to Tableau Server or Tableau Cloud. The publishing process makes the workbook available on the selected platform.

Step-by-Step Publishing Process

  1. Open Tableau Desktop.
  2. Open the workbook that you want to publish.
  3. Review worksheets, dashboards, and data connections.
  4. Open the Server menu.
  5. Select the appropriate publishing option.
  6. Sign in to the Tableau Server or Tableau Cloud site.
  7. Choose the destination project.
  8. Enter the workbook name.
  9. Configure the data source and extract options as required.
  10. Review permissions and publishing settings.
  11. Click Publish.
Note: The exact menu labels and available options may differ depending on your Tableau Desktop version and the publishing platform.

Important Publishing Options

Option Purpose
Workbook Name Defines the name of the published workbook.
Project Selects the destination project.
Data Source Controls how the workbook connects to its data.
Extract Allows extract-related publishing and refresh configuration.
Permissions Controls access for users and groups.

5. Understanding Tableau Projects

Projects are containers used to organize Tableau content. They help administrators and teams manage workbooks, published data sources, and other content in a structured way.

Benefits of Projects

  • Organize workbooks by department or business function.
  • Group related dashboards together.
  • Apply permissions at the project level.
  • Make content easier to discover.
  • Support centralized content administration.

Example: Organization Project Structure

Organization
|
|-- Sales Project
|   |-- Sales Dashboard
|   |-- Revenue Analysis
|   |-- Regional Performance
|
|-- Finance Project
|   |-- Financial Summary
|   |-- Expense Analysis
|
|-- HR Project
    |-- Employee Dashboard
    |-- Recruitment Analysis

This structure separates dashboards according to business departments and makes content easier to manage.

6. Sharing Tableau Dashboards

After publishing a dashboard, authorized users can access it through Tableau Server or Tableau Cloud. Sharing methods depend on the platform configuration and organization policy.

Common Sharing Methods

  • Share a dashboard link with authorized users.
  • Share content through a Tableau project.
  • Grant access to specific users or groups.
  • Embed views in supported applications or web pages.
  • Export views to supported file formats when permitted.

Sharing Through a Link

  1. Open the published dashboard.
  2. Locate the Share option.
  3. Copy the dashboard link.
  4. Send the link to the intended users.
  5. Ensure that recipients have the required permissions.
Security Reminder: Sharing a dashboard URL does not automatically grant access. Users must have appropriate permissions and authentication to view protected content.

7. Tableau Permissions

Permissions control what users can do with Tableau content. Administrators and content owners can assign capabilities according to the responsibilities of different users.

Common Permission Capabilities

Capability Description
View Allows users to view published content.
Explore Allows permitted users to interact with content and explore data.
Download Image / PDF Allows supported image or PDF downloads.
Download Full Data Allows access to underlying data when permitted.
Download Workbook Allows downloading the workbook when permitted.
Web Edit Allows editing content through supported web authoring features.
Save Allows users to save changes or content where permitted.
Important: Available capabilities depend on the content type, user role, license, site settings, and permission rules. A permission capability does not necessarily mean that every user can perform the action in every situation.

8. Managing Users and Groups

Tableau administrators can manage users and organize them into groups. Groups simplify permission management when many users require similar access.

Users

A user represents an individual account that can access Tableau Server or Tableau Cloud according to assigned site role and permissions.

Groups

A group is a collection of users. Instead of assigning identical permissions to every user individually, administrators can assign permissions to a group.

Example: Department-Based Groups

Group Members Typical Access
Sales Team Sales employees Sales dashboards
Finance Team Finance employees Financial reports
HR Team HR employees Employee dashboards
Administrators Authorized administrators Administrative capabilities

9. Understanding Tableau Site Roles

Site roles determine the maximum level of access a user can have on a Tableau site. They help administrators control which activities users are allowed to perform.

Common Site Roles

Site Role General Purpose
Creator Can create and publish content, subject to permissions.
Explorer Can explore and interact with content according to permissions.
Viewer Can view and interact with permitted published content.
Site Administrator Creator Provides site administration capabilities along with Creator-level capabilities.
Site Administrator Explorer Provides site administration capabilities with Explorer-level capabilities.
Unlicensed Does not provide normal licensed access to the site.
Note: Site roles and their capabilities are subject to Tableau licensing and product changes. Always review the role definitions for the deployed Tableau version.

10. Permission Management Workflow

Effective permission management ensures that users can access the content they need without receiving unnecessary privileges.

Tableau Administrator Create Users and Groups Assign Site Roles Configure Permissions Authorized Access
Diagram 2: User, group, role, and permission management workflow.

Recommended Permission Practices

  • Assign permissions according to business requirements.
  • Use groups for users with similar access needs.
  • Provide only the required capabilities.
  • Review permissions regularly.
  • Avoid granting administrative access unnecessarily.
  • Test access using appropriate user accounts.

11. Scheduling Extract Refreshes

Published Tableau workbooks may use extracts instead of Live connections. Extract refresh schedules help keep published data updated according to business requirements.

What Is Extract Refresh?

An extract refresh updates the stored Tableau extract using data from its connected source. Depending on the configuration, the refresh may be full or incremental.

Full Refresh

A full refresh rebuilds the extract using the current source data included by the configured connection and filters.

Incremental Refresh

An incremental refresh adds new records based on a selected field and supported refresh configuration. It can reduce refresh workload when the source data is suitable.

Refresh Type Description Suitable Scenario
Full Refresh Rebuilds the extract from the source. When historical records may change.
Incremental Refresh Adds new records using a selected field. When data is primarily append-only.

12. Creating an Extract Refresh Schedule

Tableau Server and Tableau Cloud provide scheduling capabilities for supported extract refresh workflows. Administrators can configure refresh frequency and monitor refresh status.

General Steps

  1. Sign in to Tableau Server or Tableau Cloud.
  2. Open the required published workbook or data source.
  3. Locate the extract refresh or schedule settings.
  4. Select the required refresh type.
  5. Choose an available schedule.
  6. Configure credentials or connection requirements.
  7. Save the refresh configuration.
  8. Monitor refresh history and job status.

Example: Business Refresh Schedule

Dashboard Refresh Frequency Business Requirement
Daily Sales Daily Review updated daily sales.
Monthly Finance Monthly Review finalized monthly figures.
Inventory Several times per day Monitor stock changes.
Employee Summary Weekly Review periodic HR information.
Important: Refresh frequency should match business needs and available platform capacity. Avoid scheduling unnecessary refreshes. Cloud connectivity requirements may also require a supported Bridge configuration for certain private-network data sources.

13. Publishing Data Sources

Tableau allows developers to publish data sources separately from workbooks. A published data source can be reused by multiple workbooks, helping teams maintain a consistent data model.

Benefits of Published Data Sources

  • Allows multiple workbooks to reuse a common data source.
  • Reduces repeated data connection setup.
  • Supports centralized data source management.
  • Helps maintain consistent definitions and calculations.
  • Allows administrators to manage access centrally.

Publishing Data Source Steps

  1. Open the required data source in Tableau Desktop.
  2. Verify fields, data types, and relationships.
  3. Open the Server menu.
  4. Select the publishing option for the data source.
  5. Choose the destination project.
  6. Configure authentication and connection details.
  7. Publish the data source.
  8. Use the published data source in supported workbooks.

14. Embedding Tableau Dashboards

Embedding allows Tableau views to be displayed within supported external websites or applications. It helps organizations integrate analytics into their existing business workflows.

Common Embedding Scenarios

  • Displaying sales dashboards inside a business portal.
  • Showing financial analytics in an internal application.
  • Integrating reports into a company intranet.
  • Providing analytics within a supported web application.

Embedding Considerations

  • Configure appropriate authentication.
  • Ensure that users have permission to view the content.
  • Use supported embedding methods and APIs.
  • Follow the organization's security requirements.
  • Test the embedded view across supported browsers.
Security Reminder: Embedding a dashboard does not bypass Tableau permissions. Authentication and authorization must be configured appropriately for the intended users.

15. Exporting and Downloading Tableau Content

Tableau provides options for exporting or downloading supported views and workbook content. Available options depend on user permissions, content type, and platform settings.

Export Option Purpose
PDF Creates a document version of a supported view.
Image Exports a supported visualization as an image.
Crosstab Exports supported tabular data.
Data Provides data download options when permitted.
Workbook Allows workbook downloading when permitted.
Note: Export and download options may be restricted by permissions and administrative settings.

16. Complete Publishing and Sharing Workflow

A proper publishing workflow includes workbook development, validation, publishing, permission configuration, and ongoing maintenance.

Develop Workbook Validate Dashboard Publish Workbook Configure Permissions Share and Monitor
Diagram 3: End-to-end Tableau publishing and sharing workflow.

17. Security Best Practices for Tableau Sharing

Tableau dashboards may contain confidential business information. Proper security configuration is essential when publishing and sharing analytical content.

Security Best Practices

  • Use authenticated access for protected dashboards.
  • Assign permissions based on job responsibilities.
  • Use groups to manage access efficiently.
  • Review workbook and data source permissions regularly.
  • Restrict downloads of sensitive data where required.
  • Use row-level security when users should see only specific records.
  • Follow organizational data governance policies.
  • Review embedded dashboard authentication settings.

Understanding Row-Level Security

Row-level security restricts which records a user can access. For example, a regional manager may be allowed to view only sales records belonging to their region.

Example: Regional Sales Access

User Assigned Region Expected Data Access
Manager A North North region records
Manager B South South region records
Manager C West West region records

18. Common Publishing and Sharing Problems

Problem Possible Cause Recommended Solution
Workbook publishing fails Connection, permission, or publishing issue. Verify server connection and publishing permissions.
User cannot access dashboard Missing permissions or authentication issue. Review user access and site membership.
Extract refresh fails Credential or data source connectivity issue. Verify credentials and source connectivity.
Dashboard displays outdated data Extract has not been refreshed. Review refresh schedule and job status.
Embedded view does not load Authentication or embedding configuration issue. Review authentication and embedding setup.
Download option is unavailable Download capability is restricted. Review permissions and site settings.
Published data source is unavailable Access or connection configuration issue. Verify project permissions and data source connection.

19. Practical Exercise: Publish and Share a Sales Dashboard

In this exercise, create a sales dashboard in Tableau Desktop and publish it to Tableau Server or Tableau Cloud.

Exercise Requirements

  • Create a sales dashboard using a sample sales dataset.
  • Add sales, profit, category, and regional visualizations.
  • Validate dashboard filters and interactions.
  • Connect to your Tableau publishing platform.
  • Create or select a suitable project.
  • Publish the workbook.
  • Configure permissions for the intended users.
  • Share the dashboard link with authorized users.
  • Configure an extract refresh schedule if required.
  • Verify dashboard access using an appropriate test account.

Expected Result

Practical Outcome: The sales dashboard should be available on the selected Tableau platform, accessible to authorized users, and configured with the required data connection and refresh settings.

20. Interview Questions and Answers

Q1. What is Tableau Publishing?

Tableau Publishing is the process of uploading workbooks, dashboards, or data sources to Tableau Server or Tableau Cloud so authorized users can access them.

Q2. What is Tableau Server?

Tableau Server is an enterprise platform used to host, manage, and share Tableau content within an organization's configured infrastructure.

Q3. What is Tableau Cloud?

Tableau Cloud is a hosted analytics platform that allows organizations to publish, manage, and share Tableau content without managing their own Tableau Server infrastructure.

Q4. What is a Tableau Project?

A project is a container used to organize Tableau content such as workbooks and published data sources.

Q5. What are Tableau Permissions?

Permissions define what actions users can perform on Tableau content, such as viewing, exploring, downloading, or editing, depending on the assigned capabilities.

Q6. What is a Tableau Site Role?

A site role defines the maximum level of access a user can have on a Tableau site.

Q7. What is an Extract Refresh Schedule?

An extract refresh schedule defines when a published Tableau extract should be updated from its data source.

Q8. What is the difference between Full and Incremental Refresh?

A full refresh rebuilds the extract, while an incremental refresh adds new records using a selected field and supported refresh configuration.

Q9. What is Row-Level Security?

Row-level security restricts data access so users can view only the records they are authorized to see.

Q10. Can a dashboard URL be shared with any user?

A URL can be shared, but users still need appropriate authentication and permissions to access protected content.

Summary

Tableau Publishing and Sharing allows organizations to distribute workbooks, dashboards, and published data sources through Tableau Server and Tableau Cloud. Developers can publish workbooks, organize content into projects, manage users and groups, configure site roles and permissions, and share dashboards with authorized users. Extract refresh schedules help maintain updated data, while embedding and export options support different business requirements. Security practices such as authenticated access, permission management, and row-level security help protect sensitive information. A complete publishing workflow includes workbook development, validation, publishing, access configuration, sharing, and ongoing monitoring.

← Previous: Performance Optimization Next: Course Completed ✓🧑‍🎓