Creating a dashboard in Tableau - Practice Exercises

Challenge - 5 Problems

❓ visualization

intermediate

Choosing the Right Chart Type for Sales Data

You have monthly sales data for different product categories. You want to create a dashboard that clearly shows sales trends over time and compares categories. Which chart type should you use?

A A line chart to show sales trends over time for each category.

B A pie chart to show the proportion of sales for each month.

C A scatter plot to show sales amounts against product prices.

D A bar chart showing total sales per product category without time.

💡 Hint

Think about how to show changes over time clearly.

A line chart is best to show trends over time for multiple categories because it connects data points in order and allows easy comparison.

❓ dax_lod_result

intermediate

Calculating Total Sales per Region with Filters

In Tableau, you want to calculate total sales per region but only for the current year. Which calculated field expression will give the correct total sales filtered by the current year?

A SUM(IF YEAR([Order Date]) = YEAR(TODAY()) THEN [Sales] END)

B SUM([Sales]) WHERE YEAR([Order Date]) = YEAR(TODAY())

C IF YEAR([Order Date]) = YEAR(TODAY()) THEN SUM([Sales]) END

D SUM(IF YEAR([Order Date]) = YEAR(TODAY()) THEN [Sales] ELSE 0 END)

💡 Hint

Remember how to use conditional aggregation in Tableau calculated fields.

Option A correctly sums sales only when the order year matches the current year. Option A includes an unnecessary ELSE 0, C tries to sum inside an IF which is incorrect, and D uses invalid WHERE syntax.

❓ data_modeling

advanced

Optimizing Data Source for Dashboard Performance

You have a large dataset with sales, customers, and products tables. Your dashboard is slow to load. What is the best data modeling approach to improve performance in Tableau?

A Import only the sales table and filter data in Tableau dashboard filters.

B Use a star schema with fact and dimension tables and create relationships in Tableau.

C Join all tables into one flat table with all columns before importing.

D Use multiple data sources without any joins or relationships.

💡 Hint

Think about how databases organize data for fast queries.

A star schema separates facts and dimensions, allowing Tableau to query efficiently. Flattening tables (B) can cause redundancy and slow performance. Multiple sources without joins (C) won't combine data properly. Importing only sales (A) loses context.

🎯 Scenario

advanced

Designing a Dashboard for Mobile and Desktop

You need to create a dashboard that works well on both desktop and mobile devices. What is the best design practice to ensure usability on both?

A Design only for desktop and let users zoom or scroll on mobile devices.

B Design a single dashboard with many small charts to fit all data on one screen.

C Create two separate dashboards optimized for desktop and mobile and switch based on device.

D Use large fonts and simple layouts that adapt to screen size with Tableau device designer.

💡 Hint

Think about responsive design and user experience.

Option D uses Tableau's device designer to create adaptable layouts with readable fonts and simple visuals, improving usability on all devices. Option D is possible but doubles work. B causes clutter. D hurts mobile experience.

🔧 Formula Fix

expert

Troubleshooting a Filter Not Applying Correctly

You added a filter on 'Region' to your dashboard, but selecting a region does not update the charts. What is the most likely cause?

A The dashboard has no charts connected to the 'Region' field.

B The data source is missing the 'Region' field in the tables.

C The filter is set to apply to only one worksheet, not the entire dashboard.

D The filter is set to 'Show All Values' instead of 'Only Relevant Values'.

💡 Hint

Check how filters are applied across worksheets in Tableau.

If a filter applies only to one worksheet, other charts won't update. The 'Region' field usually exists (B). Charts usually connect to 'Region' if filtered (A). 'Show All Values' affects dropdown options, not filter effect (D).

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