Tableau Cloud basics - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a simple interactive dashboard on Tableau Cloud to monitor monthly sales performance by region and product category.

📊 Data: You have sales data including Date, Region, Product Category, and Sales Amount for the last 12 months.

🎯 Deliverable: Create a Tableau Cloud dashboard with filters for Region and Product Category, showing monthly sales trends and total sales.

Sample Data

Date	Region	Product Category	Sales Amount
2023-06-01	North	Electronics	12000
2023-06-01	South	Furniture	8000
2023-07-01	East	Electronics	15000
2023-07-01	West	Furniture	7000
2023-08-01	North	Furniture	9000
2023-08-01	South	Electronics	11000
2023-09-01	East	Furniture	6000
2023-09-01	West	Electronics	13000
2023-10-01	North	Electronics	14000
2023-10-01	South	Furniture	7500
2023-11-01	East	Electronics	16000
2023-11-01	West	Furniture	8500

1

Step 1: Connect to the sales data source in Tableau Desktop by importing the provided data table.

Use 'Connect' > 'Text File' or 'Excel' depending on your data format, then load the data.

Expected Result

Sales data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a new worksheet named 'Monthly Sales Trend'.

Drag 'Date' to Columns, right-click and select 'Month' as date level; drag 'Sales Amount' to Rows; drag 'Region' to Color.

Expected Result

A line chart showing monthly sales by region appears.

3

Step 3: Create a second worksheet named 'Sales by Product Category'.

Drag 'Product Category' to Rows; drag 'Sales Amount' to Columns; set mark type to Bar.

Expected Result

A bar chart showing total sales by product category appears.

4

Step 4: Create filters for 'Region' and 'Product Category' on both worksheets.

Drag 'Region' and 'Product Category' to Filters shelf; show filter controls on the dashboard.

Expected Result

Interactive filters for Region and Product Category are available to users.

5

Step 5: Create a new dashboard named 'Sales Dashboard' and add both worksheets.

Drag 'Monthly Sales Trend' and 'Sales by Product Category' worksheets onto the dashboard canvas; arrange side by side.

Expected Result

Dashboard shows both charts with filters visible.

6

Step 6: Publish the dashboard to Tableau Cloud with appropriate project and permissions.

Use 'Server' > 'Publish Workbook'; select Tableau Cloud destination; set permissions for your team.

Expected Result

Dashboard is accessible on Tableau Cloud with interactive filters working.

Final Result

┌───────────────────────────────┐  ┌───────────────────────────────┐
│ Monthly Sales Trend            │  │ Sales by Product Category      │
│                               │  │                               │
│  ┌───────────────┐            │  │  ┌───────────────┐            │
│  │ Line Chart    │            │  │  │ Bar Chart     │            │
│  │ (Sales by     │            │  │  │ (Sales by     │            │
│  │ Month & Region)│           │  │  │ Product Cat.) │            │
│  └───────────────┘            │  │  └───────────────┘            │
│ Filters: [Region ▼] [Product ▼]│  │ Filters: [Region ▼] [Product ▼]│
└───────────────────────────────┘  └───────────────────────────────┘

✓Sales vary by region and product category each month.

✓Electronics generally have higher sales than Furniture.

✓Interactive filters allow quick focus on specific regions or categories.

Bonus Challenge

Add a calculated field to show Year-to-Date (YTD) sales and include it in the dashboard.

Show Hint

Create a calculated field using Tableau's DATE functions and WINDOW_SUM to accumulate sales from the start of the year.

Practice

1. What is the main purpose of Tableau Cloud?

easy

A. To create dashboards only on a local computer

B. To share dashboards online easily without extra software

C. To replace Tableau Desktop for data analysis

D. To store raw data files without visualization

Solution

1. Step 1: Understand Tableau Cloud's role and compare options

   Tableau Cloud allows users to publish and share dashboards online easily. Only To share dashboards online easily without extra software describes sharing dashboards online without extra software, which matches Tableau Cloud's purpose.

2. Final Answer:

   To share dashboards online easily without extra software -> Option B

3. Quick Check:

   Tableau Cloud = Easy online sharing [OK]

Hint: Remember: Tableau Cloud = online dashboard sharing [OK]

Common Mistakes:

• Confusing Tableau Cloud with Tableau Desktop
• Thinking Tableau Cloud stores raw data only
• Assuming Tableau Cloud replaces data analysis tools

2. Which step is required to make a dashboard available on Tableau Cloud?

easy

A. Publish the dashboard from Tableau Desktop to Tableau Cloud

B. Save the dashboard as a PDF file

C. Export the dashboard as an Excel file

D. Email the dashboard file to team members

Solution

1. Step 1: Identify how dashboards reach Tableau Cloud and eliminate other options

   Dashboards are uploaded by publishing from Tableau Desktop to Tableau Cloud. Saving as PDF, exporting as Excel, or emailing files do not upload dashboards to Tableau Cloud.

2. Final Answer:

   Publish the dashboard from Tableau Desktop to Tableau Cloud -> Option A

3. Quick Check:

   Publishing = Upload to Tableau Cloud [OK]

Hint: Publishing from Desktop uploads dashboards online [OK]

Common Mistakes:

• Confusing saving with publishing
• Thinking exporting files uploads dashboards
• Assuming emailing shares dashboards on Tableau Cloud

3. After publishing a dashboard to Tableau Cloud, which feature allows team members to interact with filters and see updated views?

medium

A. Data source refresh only

B. Static image export

C. Email notifications

D. Interactive dashboard controls

Solution

1. Step 1: Understand interactivity in Tableau Cloud and compare options for interactivity

   Tableau Cloud supports interactive dashboard controls like filters that update views dynamically. Static images and email notifications do not allow interaction; data refresh updates data but not interactivity.

2. Final Answer:

   Interactive dashboard controls -> Option D

3. Quick Check:

   Interactivity = Dashboard controls [OK]

Hint: Interactivity means using filters and controls live [OK]

Common Mistakes:

• Confusing static exports with interactive dashboards
• Thinking email notifications enable dashboard interaction
• Assuming data refresh equals interactivity

4. You published a dashboard to Tableau Cloud but team members cannot see it. What is the most likely cause?

medium

A. Team members need Tableau Desktop installed

B. Dashboard file was saved locally but not published

C. Dashboard permissions are not set to allow access

D. Tableau Cloud does not support dashboards

Solution

1. Step 1: Check access control on Tableau Cloud and eliminate other causes

   Permissions control who can view dashboards; if not set, team members cannot see the dashboard. Dashboard was published (not just saved locally), Tableau Cloud supports dashboards, and team members do not need Desktop to view online.

2. Final Answer:

   Dashboard permissions are not set to allow access -> Option C

3. Quick Check:

   Permissions control access [OK]

Hint: Check permissions if team can't see dashboards [OK]

Common Mistakes:

• Assuming saving locally publishes dashboard
• Thinking Tableau Cloud lacks dashboard support
• Believing Desktop is needed to view online dashboards

5. You want to share a sales dashboard with your team on Tableau Cloud but restrict editing rights. Which combination of features should you use?

hard

A. Publish dashboard and set viewer permissions to allow interaction but no editing

B. Export dashboard as PDF and email to team

C. Publish dashboard with full editing permissions for all team members

D. Save dashboard locally and share file via cloud storage

Solution

1. Step 1: Understand sharing with restricted editing and evaluate options for sharing and permissions

   Tableau Cloud allows setting permissions so users can interact with dashboards but not edit them. Exporting as PDF or sharing files locally does not allow interaction; full editing permissions do not restrict editing.

2. Final Answer:

   Publish dashboard and set viewer permissions to allow interaction but no editing -> Option A

3. Quick Check:

   Publish + viewer permissions = controlled sharing [OK]

Hint: Set viewer permissions to restrict editing [OK]

Common Mistakes:

• Sharing static files instead of publishing
• Giving full editing rights unintentionally
• Confusing file sharing with Tableau Cloud permissions