Show Me panel for recommendations in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants you to explore the sales data and find the best visualizations to understand sales performance by region and product category.

📊 Data: You have a dataset with columns: Order Date, Region, Product Category, Sales, and Quantity.

🎯 Deliverable: Create a Tableau worksheet using the Show Me panel to find recommended chart types that best represent sales by region and product category.

Sample Data

Order Date	Region	Product Category	Sales	Quantity
2024-01-05	East	Furniture	500	5
2024-01-10	West	Technology	1200	3
2024-01-15	South	Office Supplies	300	10
2024-02-01	East	Technology	700	2
2024-02-10	West	Furniture	400	4
2024-02-15	South	Technology	900	6
2024-03-01	East	Office Supplies	200	8
2024-03-10	West	Office Supplies	350	7
2024-03-15	South	Furniture	450	3

1

Step 1: Open Tableau and connect to the sales dataset.

Load the data with columns: Order Date, Region, Product Category, Sales, Quantity.

Expected Result

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

2

Step 2: Drag 'Region' to Rows shelf and 'Product Category' to Columns shelf.

Rows = Region, Columns = Product Category

Expected Result

Tableau shows a grid with regions as rows and product categories as columns.

3

Step 3: Drag 'Sales' to Text on the Marks card.

Marks card: Text = SUM(Sales)

Expected Result

Sales totals appear in the grid cells for each region and product category.

4

Step 4: Click on the Show Me panel on the right side of Tableau.

Show Me panel opens showing recommended chart types based on current fields.

Expected Result

Show Me highlights suitable charts like heat map, text tables, or bar charts.

5

Step 5: Select the 'Heat Map' chart type from the Show Me panel.

Choose Heat Map in Show Me

Expected Result

Tableau creates a heat map showing sales intensity by region and product category with color shading.

6

Step 6: Observe the color gradient representing sales values and adjust colors if needed for better contrast.

Edit Colors: Use a sequential color palette with good contrast.

Expected Result

Heat map clearly shows which region and product category combinations have higher sales.

Final Result

Sales by Region and Product Category Heat Map

Region/Product | Furniture | Technology | Office Supplies
-------------------------------------------------------
East           | ███       | ██████     | ██
West           | ██        | ████████   | ███
South          | ████      | █████      | ████

Color intensity shows sales volume.

✓Technology sales are highest in the West region.

✓Furniture sales are strong in the South and East regions.

✓Office Supplies have moderate sales across all regions.

Bonus Challenge

Use the Show Me panel to create a stacked bar chart showing sales by region with product categories stacked.

Show Hint

Drag 'Region' to Columns, 'Sales' to Rows, and 'Product Category' to Color, then select the stacked bar chart in Show Me.

Practice

1. What is the main purpose of the Show Me panel in Tableau?

easy

A. To export dashboards to PDF format

B. To write custom SQL queries for data extraction

C. To recommend suitable chart types based on selected data fields

D. To create calculated fields manually

Solution

1. Step 1: Understand the role of Show Me panel

   The Show Me panel suggests chart types automatically based on the data fields you select.

2. Step 2: Compare with other Tableau features

   Other options like writing SQL or exporting dashboards are not related to Show Me recommendations.

3. Final Answer:

   To recommend suitable chart types based on selected data fields -> Option C

4. Quick Check:

   Show Me = Chart recommendations [OK]

Hint: Show Me suggests charts after selecting data fields [OK]

Common Mistakes:

• Confusing Show Me with data export features
• Thinking Show Me writes SQL queries
• Assuming Show Me creates calculated fields

2. Which of the following is the correct way to use the Show Me panel in Tableau?

easy

A. Write a formula before opening Show Me

B. Click a chart type first, then select data fields

C. Export data before using Show Me

D. Select data fields first, then click a chart type in Show Me

Solution

1. Step 1: Identify the correct sequence to use Show Me

   You must select the data fields first so Tableau knows what data to visualize.

2. Step 2: Confirm the action in Show Me panel

   After selecting fields, clicking a chart type in Show Me applies the visualization.

3. Final Answer:

   Select data fields first, then click a chart type in Show Me -> Option D

4. Quick Check:

   Data first, then chart [OK]

Hint: Pick data fields before choosing chart in Show Me [OK]

Common Mistakes:

• Trying to pick chart before selecting data
• Confusing Show Me with formula editor
• Thinking export is needed before visualization

3. If you select a date field and a sales measure in Tableau and then open the Show Me panel, which chart type is most likely recommended?

medium

A. Scatter Plot

B. Line Chart

C. Pie Chart

D. Text Table

Solution

1. Step 1: Analyze selected data fields

   A date field and a sales measure suggest a time series relationship.

2. Step 2: Identify suitable chart type for time series

   Line charts are best for showing trends over time, so Show Me recommends this.

3. Final Answer:

   Line Chart -> Option B

4. Quick Check:

   Date + measure = Line Chart [OK]

Hint: Date + measure usually means line chart [OK]

Common Mistakes:

• Choosing scatter plot for time data
• Picking pie chart for continuous data
• Ignoring time dimension importance

4. You selected a dimension and a measure in Tableau but the Show Me panel does not enable the bar chart option. What is the most likely reason?

medium

A. The data fields are not compatible with a bar chart

B. You forgot to connect to a data source

C. Show Me panel is disabled by default

D. You need to write a calculated field first

Solution

1. Step 1: Understand Show Me chart availability rules

   Show Me enables chart types only if selected fields fit the chart requirements.

2. Step 2: Identify why bar chart is disabled

   If bar chart is disabled, it means the selected fields do not match bar chart needs (e.g., no categorical dimension).

3. Final Answer:

   The data fields are not compatible with a bar chart -> Option A

4. Quick Check:

   Incompatible fields disable chart options [OK]

Hint: Bar chart needs categorical dimension + measure [OK]

Common Mistakes:

• Assuming Show Me is off by default
• Thinking data source connection is missing
• Believing calculated fields are always required

5. You want to create a dashboard showing sales by region and product category. You select these two dimensions and the sales measure, then open the Show Me panel. Which chart type should you choose for the clearest comparison, and why?

hard

A. Stacked Bar Chart, because it compares categories within regions clearly

B. Line Chart, because it shows trends over time

C. Scatter Plot, because it shows correlation between sales and categories

D. Pie Chart, because it shows parts of a whole for each region

Solution

1. Step 1: Analyze data fields selected

   Two dimensions (region, product category) and one measure (sales) suggest grouped comparison.

2. Step 2: Choose chart type for grouped comparison

   Stacked bar charts show sales distribution by category within each region clearly.

3. Step 3: Eliminate other options

   Line charts need time data, scatter plots show correlation not groups, pie charts are less effective for multiple groups.

4. Final Answer:

   Stacked Bar Chart, because it compares categories within regions clearly -> Option A

5. Quick Check:

   Dimensions + measure = stacked bar for grouped comparison [OK]

Hint: Use stacked bar for comparing categories within groups [OK]

Common Mistakes:

• Choosing line chart without time dimension
• Using scatter plot for categorical data
• Picking pie chart for multiple groups