Publishing to Tableau Server - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business intelligence analyst at a retail company.

📋 Request: Your manager wants you to share the monthly sales dashboard with the sales team through Tableau Server so they can access it anytime.

📊 Data: You have a Tableau workbook with a dashboard showing monthly sales trends by region and product category.

🎯 Deliverable: Publish the Tableau workbook to Tableau Server with proper permissions so the sales team can view the dashboard online.

Sample Data

Month	Region	Product Category	Sales
January	North	Electronics	12000
January	South	Furniture	8000
February	North	Electronics	15000
February	South	Furniture	7000
March	North	Electronics	13000
March	South	Furniture	9000
April	North	Electronics	14000
April	South	Furniture	8500

1

Step 1: Open your Tableau workbook containing the monthly sales dashboard.

No formula needed.

Expected Result

Your dashboard is ready to be published.

2

Step 2: Click on 'Server' in the Tableau menu and select 'Sign In'. Enter your Tableau Server credentials.

No formula needed.

Expected Result

You are signed in to Tableau Server.

3

Step 3: Click on 'Server' again and select 'Publish Workbook'.

No formula needed.

Expected Result

Publish Workbook dialog opens.

4

Step 4: In the Publish Workbook dialog, enter a name for the workbook, select the project folder on Tableau Server, and check 'Include External Files' if needed.

No formula needed.

Expected Result

Workbook details are set for publishing.

5

Step 5: Set permissions by clicking on the 'Permissions' button. Add the sales team group and give them 'Viewer' access.

No formula needed.

Expected Result

Sales team can view the dashboard on Tableau Server.

6

Step 6: Click 'Publish' to upload the workbook to Tableau Server.

No formula needed.

Expected Result

Workbook is published and accessible on Tableau Server.

7

Step 7: Share the Tableau Server URL of the published dashboard with the sales team.

No formula needed.

Expected Result

Sales team can open the dashboard in their browsers anytime.

Final Result

-----------------------------------------
|           Monthly Sales Dashboard      |
|---------------------------------------|
| Month | Region | Product Category | Sales ($)  |
|---------------------------------------|
| Jan   | North  | Electronics     | 12000     |
| Jan   | South  | Furniture       | 8000      |
| Feb   | North  | Electronics     | 15000     |
| Feb   | South  | Furniture       | 7000      |
| Mar   | North  | Electronics     | 13000     |
| Mar   | South  | Furniture       | 9000      |
| Apr   | North  | Electronics     | 14000     |
| Apr   | South  | Furniture       | 8500      |
-----------------------------------------
Dashboard is published on Tableau Server with viewer access for sales team.

✓The sales dashboard is now accessible online via Tableau Server.

✓The sales team can view monthly sales trends anytime without needing Tableau Desktop.

✓Permissions are set to ensure only authorized users can see the dashboard.

Bonus Challenge

Set up a scheduled refresh on Tableau Server so the dashboard data updates automatically every week.

Show Hint

Use Tableau Server's data source scheduling feature to refresh extracts on a set schedule.

Practice

1. What is the main purpose of publishing a workbook to Tableau Server?

easy

A. To share your dashboards with others securely and keep them updated

B. To delete your local workbook files automatically

C. To convert your workbook into a PDF file

D. To create a backup copy on your computer

Solution

1. Step 1: Understand publishing purpose

   Publishing to Tableau Server allows sharing dashboards with others easily.

2. Step 2: Identify key benefits

   It keeps dashboards updated and accessible anytime for authorized users.

3. Final Answer:

   To share your dashboards with others securely and keep them updated -> Option A

4. Quick Check:

   Publishing = Sharing + Updating [OK]

Hint: Publishing means sharing dashboards online for access [OK]

Common Mistakes:

• Thinking publishing deletes local files
• Confusing publishing with exporting to PDF
• Believing publishing only creates backups

2. Which of the following is the correct step to publish a workbook to Tableau Server from Tableau Desktop?

easy

A. Click 'Data' > 'Export to Server', then choose the server

B. Go to 'Edit' > 'Publish to Web', then enter server details

C. Right-click the dashboard and select 'Upload to Server'

D. Click 'File' > 'Publish Workbook', then select the server and project

Solution

1. Step 1: Locate publishing option in Tableau Desktop

   The correct menu path is 'File' then 'Publish Workbook'.

2. Step 2: Select server and project

   After clicking publish, you choose the Tableau Server and the project folder.

3. Final Answer:

   Click 'File' > 'Publish Workbook', then select the server and project -> Option D

4. Quick Check:

   Publish via File menu = Click 'File' > 'Publish Workbook', then select the server and project [OK]

Hint: Publishing is under File menu, not Data or Edit [OK]

Common Mistakes:

• Looking for publishing under Data or Edit menus
• Trying to upload by right-clicking dashboard
• Confusing 'Publish to Web' with Tableau Server publishing

3. After publishing a workbook to Tableau Server, which permission setting allows users only to view the dashboard but not edit it?

medium

A. Editor

B. Viewer

C. Publisher

D. Administrator

Solution

1. Step 1: Understand permission roles on Tableau Server

   Viewer role allows users to see dashboards but not make changes.

2. Step 2: Differentiate from other roles

   Editor can edit, Publisher can publish, Administrator manages server settings.

3. Final Answer:

   Viewer -> Option B

4. Quick Check:

   View-only permission = Viewer [OK]

Hint: View-only users have Viewer role, not Editor or Publisher [OK]

Common Mistakes:

• Choosing Editor which allows editing
• Confusing Publisher with Viewer
• Assuming Administrator is for viewing only

4. You tried to publish a workbook but received an error saying you lack permission. What is the most likely cause?

medium

A. Your Tableau Desktop version is outdated

B. Your workbook file is corrupted

C. You do not have publishing rights on the selected Tableau Server project

D. You forgot to save the workbook locally

Solution

1. Step 1: Analyze the permission error message

   The error about lacking permission usually means you cannot publish to that project.

2. Step 2: Rule out other causes

   File corruption or unsaved workbooks cause different errors; version issues usually warn differently.

3. Final Answer:

   You do not have publishing rights on the selected Tableau Server project -> Option C

4. Quick Check:

   Permission error = No publishing rights [OK]

Hint: Permission errors mean no publish rights on server project [OK]

Common Mistakes:

• Assuming file corruption causes permission errors
• Thinking unsaved workbooks cause permission errors
• Blaming Tableau Desktop version without checking permissions

5. You want to publish a dashboard that updates automatically every morning with new data. Which Tableau Server feature should you configure after publishing?

hard

A. Schedule a data extract refresh on Tableau Server

B. Manually republish the workbook daily

C. Set permissions to Editor for all users

D. Export the dashboard as a PDF every morning

Solution

1. Step 1: Identify the need for automatic data updates

   To keep data fresh, you need to refresh data extracts on Tableau Server automatically.

2. Step 2: Choose the correct Tableau Server feature

   Scheduling extract refreshes runs updates without manual republishing or exporting.

3. Final Answer:

   Schedule a data extract refresh on Tableau Server -> Option A

4. Quick Check:

   Auto update = Schedule extract refresh [OK]

Hint: Use scheduled extract refresh for automatic daily updates [OK]

Common Mistakes:

• Thinking manual republishing is automatic
• Confusing permissions with data refresh
• Exporting PDFs does not update data