Dashboard design best practices in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear and effective sales performance dashboard to help the sales team quickly understand key metrics and trends.

📊 Data: You have monthly sales data by region, product category, and sales representative. The data includes sales amount, units sold, and sales targets.

🎯 Deliverable: Create a Tableau dashboard that shows total sales, sales by region, sales trends over time, and a comparison of actual sales vs targets. The dashboard should be easy to read and use best practices in design.

Sample Data

Month	Region	Product Category	Sales Rep	Sales Amount	Units Sold	Sales Target
2024-01	North	Electronics	Alice	12000	30	15000
2024-01	South	Furniture	Bob	8000	20	9000
2024-02	North	Electronics	Alice	14000	35	16000
2024-02	South	Furniture	Bob	8500	22	9500
2024-03	North	Electronics	Alice	13000	33	15500
2024-03	South	Furniture	Bob	9000	25	10000
2024-01	East	Clothing	Carol	7000	40	8000
2024-02	East	Clothing	Carol	7500	42	8500
2024-03	East	Clothing	Carol	7800	45	9000

1

Step 1: Connect Tableau to the sales data source and import the data.

Use Tableau's 'Connect' pane to select the data file or database containing the sales data.

Expected Result

Sales data is loaded into Tableau and visible in the Data pane.

2

Step 2: Create a calculated field for Sales Performance to compare Sales Amount to Sales Target.

IF [Sales Amount] >= [Sales Target] THEN 'Met Target' ELSE 'Below Target' END

Expected Result

A new field 'Sales Performance' categorizes each record as 'Met Target' or 'Below Target'.

3

Step 3: Build a bar chart showing total Sales Amount by Region.

Rows: Region; Columns: SUM(Sales Amount); Mark type: Bar; Sort bars descending by Sales Amount.

Expected Result

Bar chart displays regions with their total sales, largest sales region on top.

4

Step 4: Create a line chart showing monthly sales trends over time.

Columns: Month (continuous date); Rows: SUM(Sales Amount); Mark type: Line.

Expected Result

Line chart shows how sales amount changes each month.

5

Step 5: Add a KPI indicator showing total sales vs total sales target with color coding.

Create a calculated field 'Sales vs Target %' = SUM([Sales Amount]) / SUM([Sales Target]) * 100; Use a text or gauge indicator with green if >=100%, red if below.

Expected Result

KPI clearly shows if total sales meet or miss the target with color feedback.

6

Step 6: Design the dashboard layout with clear sections: KPIs on top, charts below, filters on the side.

Use Tableau Dashboard pane to arrange components; add filters for Region and Product Category; ensure consistent fonts and colors.

Expected Result

Dashboard is visually balanced, easy to read, and interactive with filters.

7

Step 7: Apply best practices: use simple color palette, avoid clutter, add clear titles and labels, and ensure accessibility.

Use colorblind-friendly palette; add descriptive titles; use tooltips for details; check contrast ratios; enable keyboard navigation.

Expected Result

Dashboard is user-friendly, accessible, and communicates insights clearly.

Final Result

---------------------------------------------
| SALES PERFORMANCE DASHBOARD                |
|-------------------------------------------|
| Total Sales: $86,800   | Target: $100,500  |
| Performance: Below Target (Red Indicator) |
|-------------------------------------------|
| Sales by Region (Bar Chart)                |
|  North  |█████████████  $39,000            |
|  South  |███████        $25,500            |
|  East   |█████████      $22,300            |
|-------------------------------------------|
| Monthly Sales Trend (Line Chart)           |
|  Jan |----*----| Feb |----*----| Mar |----*----|
|       $27k     $30k      $29k               |
|-------------------------------------------|
| Filters: [Region ▼] [Product Category ▼]   |
---------------------------------------------

✓North region has the highest sales but still below target.

✓Sales trend shows steady growth from January to March.

✓Overall sales are slightly below the combined target.

✓Dashboard layout helps users quickly find key metrics and filter data.

Bonus Challenge

Add a drill-down feature to the dashboard that allows users to click on a region bar and see sales details by sales representative.

Show Hint

Use Tableau's dashboard actions to create a filter action that updates a detailed table or chart based on the selected region.

Practice

1. Which of the following is a key principle of good dashboard design in Tableau?

easy

A. Keep the layout simple and focus on important information

B. Use as many colors as possible to make it vibrant

C. Add all available data fields to show everything

D. Avoid using filters to keep the dashboard static

Solution

1. Step 1: Understand dashboard clarity

   Good dashboards highlight key info clearly without clutter.

2. Step 2: Evaluate options

   Using simple layouts and focusing on important info helps users understand data quickly.

3. Final Answer:

   Keep the layout simple and focus on important information -> Option A

4. Quick Check:

   Simple layout = A [OK]

Hint: Focus on simplicity and key info for dashboards [OK]

Common Mistakes:

• Using too many colors causing confusion
• Adding all data fields making dashboard cluttered
• Avoiding filters reduces interactivity

2. Which Tableau feature helps maintain consistent colors across multiple charts in a dashboard?

easy

A. Applying a uniform color legend to all charts

B. Disabling color legends to reduce clutter

C. Manually coloring each mark individually

D. Using different color palettes for each chart

Solution

1. Step 1: Identify color consistency method

   Consistent colors help users compare data easily across charts.

2. Step 2: Understand Tableau color legends

   Applying a uniform color legend ensures all charts use the same color scheme.

3. Final Answer:

   Applying a uniform color legend to all charts -> Option A

4. Quick Check:

   Uniform color legend = D [OK]

Hint: Use uniform color legends for consistent colors [OK]

Common Mistakes:

• Using different palettes causing confusion
• Manually coloring marks wastes time
• Disabling legends hides important info

3. Consider a Tableau dashboard with three charts and a filter. If the filter is set to 'Region = East', what happens to the charts?

medium

A. Charts show data for all regions regardless of filter

B. Only the first chart updates; others remain unchanged

C. The filter disables and no data is shown

D. All three charts update to show data only for the East region

Solution

1. Step 1: Understand filter behavior in Tableau dashboards

   Filters apply to all connected charts to focus data on selected criteria.

2. Step 2: Apply filter 'Region = East'

   All charts connected to this filter update to show only East region data.

3. Final Answer:

   All three charts update to show data only for the East region -> Option D

4. Quick Check:

   Filter applies to all charts = C [OK]

Hint: Filters update all connected charts simultaneously [OK]

Common Mistakes:

• Assuming only one chart updates
• Thinking filters don't affect charts
• Believing filter disables data display

4. You created a Tableau dashboard but users say it is hard to read because charts overlap and filters are confusing. What is the best way to fix this?

medium

A. Add more charts to provide extra details

B. Rearrange charts with clear spacing and group related filters logically

C. Remove all filters to simplify the dashboard

D. Use random colors for each chart to make them distinct

Solution

1. Step 1: Identify layout and filter issues

   Overlapping charts and confusing filters reduce readability and usability.

2. Step 2: Improve dashboard design

   Rearranging charts with space and grouping filters logically makes dashboard clearer and easier to use.

3. Final Answer:

   Rearrange charts with clear spacing and group related filters logically -> Option B

4. Quick Check:

   Clear layout and logical filters = B [OK]

Hint: Organize layout and filters for clarity [OK]

Common Mistakes:

• Adding more charts increases clutter
• Removing filters reduces interactivity
• Using random colors confuses users

5. You want to design a Tableau dashboard for sales managers that shows monthly sales trends, top products, and regional performance. Which approach best follows dashboard design best practices?

hard

A. Use many bright colors and animations to attract attention to all charts equally

B. Create separate dashboards for each topic to avoid clutter and use filters to connect them

C. Combine all charts on one dashboard with clear sections, consistent colors, and interactive filters

D. Show all raw data tables instead of charts for detailed analysis

Solution

1. Step 1: Understand user needs and dashboard goals

   Sales managers need clear, interactive views of trends, products, and regions in one place.

2. Step 2: Apply best practices for dashboard design

   Combining charts with clear sections, consistent colors, and filters improves usability and insight.

3. Final Answer:

   Combine all charts on one dashboard with clear sections, consistent colors, and interactive filters -> Option C

4. Quick Check:

   Clear, consistent, interactive dashboard = A [OK]

Hint: Use clear sections and filters on one dashboard [OK]

Common Mistakes:

• Splitting topics causes extra navigation
• Using too many colors distracts users
• Showing raw data tables overwhelms users