Creating a dashboard in Tableau - Business Scenario Walkthrough

Scenario Mode

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

📋 Request: Your manager wants a dashboard to monitor monthly sales performance by region and product category.

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

🎯 Deliverable: Create a Tableau dashboard showing monthly sales trends by region and product category with clear visualizations and filters.

Sample Data

Date	Region	Product Category	Sales Amount	Quantity Sold
2023-06-01	North	Electronics	12000	30
2023-06-01	South	Furniture	8000	20
2023-07-01	East	Electronics	15000	35
2023-07-01	West	Furniture	7000	18
2023-08-01	North	Clothing	5000	50
2023-08-01	South	Electronics	11000	25
2023-09-01	East	Clothing	6000	40
2023-09-01	West	Electronics	13000	28
2023-10-01	North	Furniture	9000	22
2023-10-01	South	Clothing	4000	45
2023-11-01	East	Furniture	8500	19
2023-11-01	West	Clothing	4500	38

1

Step 1: Connect Tableau to the sales data source containing Date, Region, Product Category, Sales Amount, and Quantity Sold.

Use 'Connect to Data' and select the data file or database with the sales data.

Expected Result

Tableau shows the data fields ready for analysis.

2

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

Drag 'Date' to Columns, right-click and select 'Month' as the date part. Drag 'Sales Amount' to Rows. Drag 'Region' to Color on Marks card.

Expected Result

A line chart showing monthly sales trends with lines colored by region.

3

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

Drag 'Product Category' to Rows. Drag 'Sales Amount' to Columns. Use Bar chart type.

Expected Result

A horizontal bar chart showing total sales amount by product category.

4

Step 4: Create a filter for 'Region' to allow dashboard users to select regions.

Drag 'Region' to Filters shelf. Show filter on worksheet.

Expected Result

A filter control for Region appears on the worksheet.

5

Step 5: Create a dashboard named 'Sales Performance Dashboard'.

Add the two worksheets 'Monthly Sales by Region' and 'Sales by Product Category' to the dashboard. Place the Region filter on the dashboard.

Expected Result

Dashboard shows both charts and the Region filter for interactive analysis.

6

Step 6: Configure dashboard layout for clarity and responsiveness.

Arrange charts side by side with clear titles. Set dashboard size to automatic for responsive design.

Expected Result

Dashboard is easy to read and adjusts well on different screen sizes.

Final Result

Sales Performance Dashboard

+----------------------------+  +----------------------------+
| Monthly Sales by Region    |  | Sales by Product Category   |
|                            |  |                            |
|  * Line chart with months  |  |  * Bar chart by category    |
|    on X-axis, sales on Y   |  |                            |
|  * Lines colored by region |  |                            |
|                            |  |                            |
+----------------------------+  +----------------------------+

[Region Filter: All | North | South | East | West ]

✓Sales vary by region each month, with East and North showing higher sales in some months.

✓Electronics is the top product category in sales amount.

✓The Region filter allows focusing on specific areas to analyze sales trends.

Bonus Challenge

Add a calculated field to show average sales per quantity sold and include it in the dashboard.

Show Hint

Create a calculated field: Average Sales = SUM([Sales Amount]) / SUM([Quantity Sold]). Add this as a new chart or tooltip.

Practice

1. What is the main purpose of creating a dashboard in Tableau?

easy

A. To write complex SQL queries

B. To export data to Excel

C. To create raw data tables

D. To combine multiple charts for easy data viewing

Solution

1. Step 1: Understand dashboard purpose

   A dashboard is designed to show multiple visualizations together for quick insights.

2. Step 2: Compare options to purpose

   Only combining charts for easy viewing matches the dashboard's goal.

3. Final Answer:

   To combine multiple charts for easy data viewing -> Option D

4. Quick Check:

   Dashboard = Combine charts [OK]

Hint: Dashboards show many charts together for quick insight [OK]

Common Mistakes:

• Confusing dashboards with data export
• Thinking dashboards are for raw data only
• Mixing dashboards with query writing

2. Which of the following is the correct way to add a sheet to a Tableau dashboard?

easy

A. Drag the sheet from the Sheets pane onto the dashboard area

B. Right-click the sheet and select 'Export to Dashboard'

C. Double-click the sheet to automatically add it to the dashboard

D. Use the Data menu to import the sheet into the dashboard

Solution

1. Step 1: Identify how to add sheets

   In Tableau, sheets are added by dragging them onto the dashboard workspace.

2. Step 2: Evaluate options

   Only dragging from the Sheets pane is the correct method; others are incorrect or do not exist.

3. Final Answer:

   Drag the sheet from the Sheets pane onto the dashboard area -> Option A

4. Quick Check:

   Drag sheet to dashboard [OK]

Hint: Drag sheets from pane to dashboard to add [OK]

Common Mistakes:

• Trying to export sheets instead of dragging
• Double-clicking sheets expecting auto-add
• Using Data menu incorrectly

3. Consider a dashboard with three sheets: Sales, Profit, and Region Map. If you add a filter on Region in the dashboard, what happens when you select a region in the filter?

medium

A. Only the Sales sheet updates to show data for the selected region

B. All sheets update to show data for the selected region

C. The filter does not affect any sheet unless applied individually

D. Only the Region Map updates, others stay the same

Solution

1. Step 1: Understand dashboard filters

   Dashboard filters can be set to apply to all relevant sheets, syncing their data views.

2. Step 2: Apply filter effect

   Selecting a region filter updates all sheets connected to that filter to show data for that region.

3. Final Answer:

   All sheets update to show data for the selected region -> Option B

4. Quick Check:

   Dashboard filter affects all sheets [OK]

Hint: Dashboard filters update all connected sheets [OK]

Common Mistakes:

• Thinking filters affect only one sheet by default
• Assuming filters need manual application per sheet
• Believing filters do not update visualizations

4. You created a dashboard but the filter you added does not update any sheets. What is the most likely reason?

medium

A. The filter is not set to apply to all relevant sheets

B. The dashboard has too many sheets

C. The data source is disconnected

D. The sheets are not visible on the dashboard

Solution

1. Step 1: Check filter application settings

   Filters must be configured to apply to all or specific sheets to update them.

2. Step 2: Identify why sheets don't update

   If the filter is not set to apply to sheets, they won't respond to filter changes.

3. Final Answer:

   The filter is not set to apply to all relevant sheets -> Option A

4. Quick Check:

   Filter scope controls sheet updates [OK]

Hint: Set filter to apply to all sheets to update [OK]

Common Mistakes:

• Blaming number of sheets for filter failure
• Ignoring filter application scope
• Assuming disconnected data source without checking

5. You want to create a dashboard that shows sales trends and allows users to filter by year and product category. Which steps should you follow to build this interactive dashboard?

hard

A. Create sheets for sales trends, add filters on sheets but do not add filters to dashboard

B. Create one sheet with all data, add it to dashboard, then add filters only for year

C. Create sheets for sales trends, add them to dashboard, then add filters for year and category applying to all sheets

D. Create sheets, add to dashboard, export data, then add filters in Excel

Solution

1. Step 1: Build individual sheets for sales trends

   Create separate sheets showing sales trends by year and category for clarity.

2. Step 2: Add sheets to dashboard and add filters

   Drag sheets onto dashboard, then add filters for year and product category, setting them to apply to all sheets for interactivity.

3. Final Answer:

   Create sheets for sales trends, add them to dashboard, then add filters for year and category applying to all sheets -> Option C

4. Quick Check:

   Sheets + dashboard + filters for all sheets = interactive dashboard [OK]

Hint: Add filters on dashboard applying to all sheets for interactivity [OK]

Common Mistakes:

• Adding filters only on sheets, not dashboard
• Using one sheet for all data losing clarity
• Exporting data instead of using dashboard filters