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 Product Suite

Explore the Tableau product ecosystem and understand how Tableau Desktop, Tableau Public, Tableau Server, Tableau Cloud, and Tableau Prep support data analysis, visualization, preparation, publishing, and collaboration.

1. Introduction to Tableau Product Suite

Tableau provides different products and platforms that support the complete data analytics workflow. These products help users connect to data, prepare information, create visualizations, publish dashboards, and share analytical results.

Each Tableau product has a different purpose. For example, Tableau Desktop is primarily used to create visualizations, Tableau Prep helps prepare data, and Tableau Server or Tableau Cloud can be used to distribute analytical content.

Business Example

Imagine a company that receives sales information from multiple branches. Its data analyst needs to clean the information, create sales dashboards, and share the final reports with management.

The analyst can use Tableau Prep for data preparation, Tableau Desktop for report development, and Tableau Server or Tableau Cloud for publishing and sharing.

Remember: Tableau products work together to support different stages of the analytics process. You do not need to use every product for every project.

2. Overview of the Tableau Product Ecosystem

The Tableau ecosystem contains products for data preparation, visual analytics, public sharing, and organizational deployment.

Tableau Product Suite Complete Analytics Ecosystem Prep Prepare Data Desktop Create Visuals Public Public Sharing Server Managed Deployment Cloud Hosted Analytics Prepare • Create • Publish • Share

Visual 1: Overview of the main Tableau products.

Product Main Responsibility
Tableau Desktop Creating worksheets, visualizations, and dashboards.
Tableau Public Creating and sharing publicly accessible visualizations.
Tableau Server Organization-managed publishing and content management.
Tableau Cloud Hosted online analytics and collaboration.
Tableau Prep Cleaning, combining, and preparing data.

3. Tableau Desktop

Tableau Desktop is an authoring application used by analysts and business users to connect to data and develop interactive visualizations.

It provides a visual workspace where users can drag and drop fields, create charts, apply filters, perform calculations, and design dashboards.

Important Capabilities

  • Connect to supported files, databases, and other data sources.
  • Create worksheets and visualizations.
  • Build interactive dashboards.
  • Create calculated fields and analytical views.
  • Apply filters, sorting, and grouping.
  • Work with maps and geographic information.
  • Save workbooks for later use or publishing.

Example: Sales Analysis

A data analyst receives an Excel file containing product sales. Using Tableau Desktop, the analyst can create a bar chart to compare sales by product, a line chart to examine monthly trends, and a dashboard to combine the results.

Professional Tip: Tableau Desktop is generally the starting point for learning Tableau report development because it provides the main worksheet and dashboard authoring environment.

4. Tableau Desktop Workspace

Tableau Desktop provides several areas that help users build visualizations. The workspace includes data fields, shelves, cards, and the main visualization canvas.

Tableau Desktop Workspace Data Pane Dimensions Product Region Category Measures Sales Profit Columns Shelf Rows Shelf Marks Card Color Size Label Detail Visualization Canvas A B C D

Visual 2: Simplified conceptual view of the Tableau Desktop workspace.

Workspace Area Purpose
Data Pane Displays available dimensions and measures.
Columns Shelf Controls fields placed along the horizontal direction.
Rows Shelf Controls fields placed along the vertical direction.
Marks Card Controls visual properties such as color, size, label, and detail.
Visualization Canvas Displays the chart or visualization being created.

You will explore the Tableau interface and its individual components in detail in the Tableau Interface lesson.

5. Tableau Public

Tableau Public is a free platform for creating and publicly sharing data visualizations. It is commonly used by students, data analysts, educators, and visualization enthusiasts.

Users can create visualizations and publish them to their public profile so that other people can view and explore the work.

Important Features

  • Create and publish data visualizations.
  • Build a public portfolio of analytical work.
  • Explore visualizations created by other users.
  • Share public visualization links.
  • Practice Tableau skills using non-confidential datasets.

Example: Student Portfolio

A student learning Tableau can create a project using sample retail sales data. The student can publish the visualization to Tableau Public and share the public portfolio link when applying for data analyst jobs.

Privacy Warning: Tableau Public is designed for public content. Do not publish confidential business information, private customer records, or sensitive organizational data. Verify the current publishing and data-access behavior before using it for any real project.

6. Tableau Server

Tableau Server is a platform that organizations can deploy and manage within their own infrastructure. It supports publishing, organizing, governing, and sharing Tableau content with authorized users.

Organizations can use Tableau Server to provide controlled access to reports and dashboards. Administrators can manage users, groups, permissions, projects, and content according to organizational policies.

Important Capabilities

  • Publish and manage Tableau workbooks.
  • Organize content using projects.
  • Manage users and groups.
  • Configure permissions and access.
  • Support scheduled extract refreshes where configured.
  • Share dashboards with authorized organizational users.

Business Example

A company has separate sales teams in Pune, Mumbai, and Bengaluru. The management team publishes sales dashboards to Tableau Server and configures access according to each employee's role and permissions.

Remember: Tableau Server is suitable for organizations that need to manage their own deployment environment and control access to analytical content.

7. Tableau Cloud

Tableau Cloud is a hosted analytics platform that allows organizations to publish, manage, access, and share Tableau content online.

Unlike a self-managed Tableau Server deployment, Tableau Cloud is hosted and operated as a cloud service. Organizations can use it to collaborate on dashboards without maintaining their own Tableau Server infrastructure.

Important Capabilities

  • Publish Tableau workbooks and dashboards online.
  • Access analytical content through supported browsers.
  • Manage users and content permissions.
  • Support collaboration across distributed teams.
  • Use supported data connectivity and refresh options.
  • Manage content through a hosted platform.

Business Example

An organization has employees working from different cities. The data team publishes approved dashboards to Tableau Cloud. Authorized team members can access those dashboards online according to their permissions.

Important: Tableau Cloud is a hosted service. Data connectivity, refresh configuration, licensing, and access requirements should be checked before deployment.

8. Tableau Server vs Tableau Cloud

Tableau Server and Tableau Cloud both support publishing and sharing Tableau content. Their main difference is how the platform infrastructure is hosted and managed.

Tableau Server Organization Infrastructure Managed by the organization Tableau Cloud Hosted Cloud Platform Operated as a hosted service Both platforms support publishing and sharing analytical content

Visual 3: Conceptual comparison of Tableau Server and Tableau Cloud.

Comparison Tableau Server Tableau Cloud
Hosting Organization-managed infrastructure. Hosted cloud service.
Infrastructure Management Managed by the organization or its service provider. Platform infrastructure is operated by Tableau.
Administration Organization manages deployment and administration. Organization manages its site, users, content, and settings.
Access Through the configured server environment. Through the hosted online environment.
Maintenance Organization is responsible for its server environment. Hosted platform maintenance is handled by Tableau.
Interview Tip: If an interviewer asks about the difference between Tableau Server and Tableau Cloud, explain that Server is deployed and managed by the organization, whereas Cloud is a hosted analytics service.

9. Tableau Prep

Tableau Prep is a data preparation tool used to clean, combine, reshape, and organize data before it is analyzed in Tableau.

Real-world data may contain missing values, duplicate records, inconsistent field names, incorrect formats, and information stored across multiple files. Tableau Prep provides a visual workflow for handling many of these preparation tasks.

Important Capabilities

  • Connect to supported data sources.
  • Review data quality and field values.
  • Clean and rename fields.
  • Remove duplicate records when appropriate.
  • Filter unwanted rows.
  • Combine datasets using joins and unions.
  • Reshape and organize data.
  • Output prepared data for further analysis.

Business Example

A company receives sales information in three Excel files from different branches. Before creating a company-wide sales dashboard, the analyst needs to standardize the column names, remove invalid records, and combine the datasets.

Tableau Prep can help build a repeatable visual preparation workflow for this task.

Remember: Tableau Prep focuses on preparing data, while Tableau Desktop focuses on visual analysis and report development.

10. How Tableau Prep and Desktop Work Together

Tableau Prep and Tableau Desktop can be used together in a data analytics workflow. Data is prepared first and then used to develop visualizations and dashboards.

Raw Data Excel, CSV Database Tableau Prep Clean and Combine Data Tableau Desktop Analyze and Visualize Publish Server or Cloud Share Dashboards A typical data preparation and visualization workflow

Visual 4: Using Tableau Prep and Desktop together.

  1. Input: Connect to the original files or supported databases.
  2. Prepare: Clean, filter, combine, and organize the data.
  3. Analyze: Use the prepared data in Tableau Desktop.
  4. Visualize: Create worksheets and dashboards.
  5. Publish: Share the approved content through Tableau Server or Tableau Cloud when required.

11. Choosing the Right Tableau Product

The correct Tableau product depends on the task, organization, data privacy requirements, and publishing requirements.

Requirement Suitable Product Reason
Create interactive dashboards. Tableau Desktop Provides visualization authoring tools.
Clean and combine datasets. Tableau Prep Provides visual data preparation workflows.
Build a public visualization portfolio. Tableau Public Supports public publishing and sharing.
Deploy analytics on organization-managed infrastructure. Tableau Server Supports self-managed deployment.
Use a hosted online analytics platform. Tableau Cloud Provides hosted publishing and collaboration.
Licensing Note: Product access, publishing features, user roles, and available capabilities depend on the current Tableau licensing model and subscription.

12. Beginner Practice Questions

Q1. What is Tableau Desktop used for?

Answer: Tableau Desktop is used to connect to data, create worksheets, build dashboards, and develop visualizations.

Q2. What is Tableau Public?

Answer: Tableau Public is a platform for creating and publicly sharing data visualizations.

Q3. What is the main purpose of Tableau Prep?

Answer: Tableau Prep is used to clean, combine, reshape, and prepare data.

Q4. What is the difference between Tableau Server and Tableau Cloud?

Answer: Tableau Server is deployed and managed within an organization's infrastructure, whereas Tableau Cloud is a hosted online service.

Q5. Which Tableau product is useful for building a public portfolio?

Answer: Tableau Public, provided the data and content are appropriate for public sharing.

Q6. Can Tableau Prep and Tableau Desktop be used together?

Answer: Yes. Tableau Prep can prepare data, and Tableau Desktop can use that data to build visualizations and dashboards.

Q7. Which product is suitable for an organization that wants a hosted analytics platform?

Answer: Tableau Cloud.

Summary

In this lesson, you explored the Tableau Product Suite and understood the different roles of Tableau Desktop, Tableau Public, Tableau Server, Tableau Cloud, and Tableau Prep.

You learned that Tableau Desktop is used to develop visualizations, Tableau Prep supports data preparation, Tableau Public supports public sharing, and Tableau Server and Tableau Cloud support publishing and collaboration through different deployment models.

You also explored how Tableau Prep and Tableau Desktop can work together in a typical business analytics workflow. In the next lesson, you will learn how to download and install Tableau Desktop or Tableau Public.