Tableau dashboard design transforms worksheets into compelling visual stories. Master layout, interactivity, drill-down navigation, filters, and parameters for professional dashboards.
Dashboard Layout & Design Principles
Container Types: Vertical/Horizontal containers: stack worksheets (responsive sizing). Tiled (default): tiles fixed size, responsive. Floating: manual positioning (overlap allowed). Size: fixed (pixels), automatic (responsive), range (min-max pixels). Mobile layout: separate design for phones. Dashboard should fit screen (no scrolling ideally).
Visual Hierarchy: Lead with key metric (top-left, large). Supporting details below/right. Use white space. Color sparingly (highlight key). Consistency: same colors for same category. Font sizes: title > headers > data. Alignment: grid-based positioning. Whitespace: 20-30px margins. Professional appearance.
Dashboard Filters & Cascading: Filters: drag worksheet filter to dashboard (applies to all connected worksheets). Cascading: region filter → available products (worksheet filter on [Product] IN related products). Single-select vs multi-select (usability). Apply/cancel options. Quick filters vs action filters.
Drill-Down Navigation: Dashboard action: click chart → navigate to detail dashboard. Drill actions: click dimension → filter related charts. Hierarchy: dimension > category > product. Pass context: selected region flows to detail sheet. Navigation buttons: next/previous record. Breadcrumb: show navigation path.
Parameters & Dynamic Filtering: Parameters: user-selectable values (date range, threshold, metric). String/number/date types. Linked to calculated fields (dynamic visualization). Use case: “show top N products” (N = parameter). Slider: continuous range. List: discrete options. All option: remove filter constraint. Parameters enable flexibility without redesign.
Performance & Optimization: Dashboard efficiency: minimize worksheets on dashboard (lazy loading). Publish dashboard to server (optimization features). Monitor: Performance Recording (Extensions > Performance). Target < 2 sec dashboard load. Cache strategy: extract overnight, dashboard queries cache. Avoid: excessive marks (limit to 100k), complex LOD in slow dashboards.
5 Complete Solved Interview Problems
Question 1: Design Executive Sales Dashboard
Visualize: YTD sales, growth %, regional breakdown, top products. Layout for exec review (2-min scan)?
Top row: KPI cards (YTD Sales, Growth %, Target %, Actual/Target gauge)
Middle: Regional sales bar chart (left 60%), Top products ranking (right 40%)
Bottom: Sales trend line chart (full width)
Filters: Year, Quarter, Region (top)
Mobile: stack vertically, hide detail worksheets
Google – VP Analytics
Question 2: Create Cascading Filter Dashboard
Region filter → shows available states → shows available products. Prevent empty results?
Region → State worksheet filter: WHERE [Region] = @RegionParam
State → Product worksheet filter: WHERE [State] = @StateParam
Dashboard actions: click region → filter state list (filter action)
click state → filter product list. Prevent: default values for region/state
Meta – Senior BI Engineer
Question 3: Implement Drill-Down Navigation
Overview dashboard: regions. Click region → detail dashboard (state, city, stores)?
Detail dashboards: state breakdown, city ranking, store performance
Dashboard action: click region bar → navigate to detail dashboard
Pass region parameter: detail filters by selected region
Breadcrumb: “Home > Region Name > State Name” (navigation path)
Back button: return to overview
Amazon – Analytics Manager
Question 4: Create Dynamic Metric Dashboard
Parameter: user selects metric (Sales, Revenue, Profit). Dashboard shows same chart with selected metric?
Calculated field: Selected Metric
CASE [MetricSelect]
WHEN “Sales” THEN [Sales]
WHEN “Revenue” THEN [Revenue]
WHEN “Profit” THEN [Profit]
END
Dashboard: metric dropdown (parameter control). Chart uses [Selected Metric] measure
Apple – Analytics Engineer
Question 5: Optimize Slow Dashboard
5-worksheet dashboard loads in 12 sec. Target 2 sec. Optimization strategy?
Worksheet optimization: pre-filter data (WHERE clause), reduce marks (limit rows)
Extract optimization: use HYPER format, schedule refresh off-peak
Dashboard optimization: remove 1-2 worksheets (lazy load), hide detail tabs
Caching: server-side caching for repeated queries
Target achieved: 4 worksheets @ 500ms each = 2 sec dashboard
Microsoft – Senior Analytics Engineer
15 Practice Questions
Question 6: Compare tiled vs floating containers in dashboard design. What are use cases for each? When do you choose responsive vs manual positioning?
Question 7: Design mobile-friendly dashboard for phone viewport (375px width). How to restructure grid layout for mobile responsiveness?
Question 8: Choose color palette for 5-category breakdown chart. How to maintain accessibility (color-blind friendly)? Tableau palette options?
Question 9: Implement highlight action: click product bar → highlight all related marks in other worksheets. Wiring steps?
Question 10: Create parameter dropdown showing top 10 products vs all 100 options. Which UX design better for dashboard usability?
Question 11: Implement date range parameter with slider control vs calendar picker. Which gives better user experience?
Question 12: Write effective dashboard title and subtitle. How information architecture differs from worksheet titles?
Question 13: Show/hide worksheets dynamically via parameter. Create “detail level” parameter (summary vs detailed view).
Question 14: Customize tooltip to show all detail columns. When rich tooltips helpful vs cluttered?
Question 15: Implement URL action: click customer row → open CRM (Salesforce, HubSpot). Pass customer ID in URL parameter safely.
Question 16: Set filter default values. Should filters default to “all” or most common selection? Impact on first-time user experience?
Question 17: Configure dashboard permissions: read-only viewers vs editors. How role-based access control on Tableau Server?
Question 18: Export dashboard to PDF vs PNG. How branding/logo embedding differs? Which format for email sharing?
Question 19: Schedule dashboard data refresh: real-time vs daily. When to use each based on business requirements?
Question 20: Certify dashboard as trusted source on Tableau Server. Governance process. Which stakeholder controls certification?
Master Tableau Dashboard Design
Get our comprehensive Data Analytics: Ace All The Interview Concepts course.