top of page

Welcome
to NumpyNinja Blogs

NumpyNinja: Blogs. Demystifying Tech,

One Blog at a Time.
Millions of views. 

Tableau Dashboard Design Mastery

Nov 5
3 min read

Essential Steps for Creating Professional and Interactive Dashboards

A practical blog guide to layouts, KPIs, color palettes, chart selection, filters, and data storytelling in Tableau and Power BI.


Step1 — Choose the Right Dashboard Size

For a desktop-focused Tableau dashboard, a width of approximately 1399–1400 pixels is a useful starting point. Adjust height to fit the analysis and test the layout on the audience’s actual screens. This is a guideline, not a universal size.

·        In Tableau, create a dashboard and open the Size setting.

·        Choose a fixed or custom size and set the width to about 1400 pixels.

·        Choose a height based on chart density; preview and adjust for readability.


Step2 — Balance KPIs, Charts, and Filters

Start with four to five important KPI cards, a focused set of charts, and approximately three to five relevant filters. For a retail dashboard, useful KPIs include Total Sales, Total Profit, Total Orders, Quantity, and Profit Margin. Place the most important indicators at the top and format units consistently.


Step3 — Choosing the Right Chart

A good chart begins with an analytical question. Use this quick guide to match the question with a suitable visual.

Question

Recommended chart

How much?

KPI card

Compare categories

Bar chart

Trend over time

Line chart

Distribution

Histogram or box plot

Relationship

Scatter plot

Part-to-whole

100% stacked bar, donut, treemap

Geographic pattern

Map

Flow or connections

Sankey diagram

Rankings over time

Bump chart

Cumulative contribution

Pareto chart

Before vs after

Dumbbell chart

Correlation

Correlation heatmap


For example, a sorted bar chart makes regional comparisons clear; a line chart is more appropriate for monthly trends. A complex chart is not inherently better than a simple one.




Step4 — Use Color With Purpose

Use gray for neutral information, an accent color for selections, a primary color for important values, red for negative results, and green for positive results. Keep category colors consistent and never rely on color alone to communicate meaning.

The supplied materials offer ten palettes: Corporate Blue, Modern Purple, Emerald, Navy + Orange, Ocean, Burgundy + Rose, Dark Executive, Blue + Gold, Tableau-Friendly Soft, and Minimalist. Navy + Orange is particularly suitable for sales, profit, and discount comparisons.


Step5 — Write Meaningful Captions

Use the What + Where + Why framework below important charts. Describe the observation, identify the relevant segment or time period, and explain why it matters or what to investigate next.

Example using illustrative data: “West recorded the highest sales at 125K, while Central recorded 54K. The gap suggests examining customer mix and regional profitability.” Do not imply a cause without evidence.


Step6 — Add Simple, Consistent Icons

Transparent PNG or SVG icons can help readers identify Sales, Profit, Orders, Quantity, or Customer KPIs. In Tableau on Windows, place custom PNG shapes in Documents → My Tableau Repository → Shapes → Dashboard Icons. Then use Marks → Shape → More Shapes to select them. Keep icons small and consistent.


Step7— Build Layouts With Containers

In Tableau, use tiled vertical and horizontal containers to build the structure: Title → KPI Row → Main Chart → Supporting Charts → Insights. Floating objects can be useful for annotations and decorative elements, but excessive floating objects complicate maintenance and resizing.

·        Create a new Tableau dashboard and choose Tiled.

·        Add a Vertical Container for the overall structure.

·        Add a Horizontal Container for KPI cards and another for supporting charts.

·        Adjust padding and alignment; use Floating only where needed.


Step8 — Apply Filters Consistently

Filters such as Region, Category, Segment, Year, and Ship Mode help users explore the data. In Tableau, add a field to Filters, choose Show Filter, then use Apply to Worksheets → All Using This Data Source or Selected Worksheets. Test every intended interaction; some overview charts may deliberately remain unfiltered.


Step9 — Manage Data Sources and Portability

Live connections query a source, whereas extracts store a snapshot that requires refreshing. Tableau packaged workbooks (.twbx) can make local resources easier to share. Before replacing data, check field names, types, calculations, and relationships. Creating an extract alone does not migrate data to a different source.


Recommended Dashboard Layout

Section

Contents

Header

Dashboard title and purpose

KPI row

4–5 high-value metrics

Main area

Primary analytical chart and relevant filters

Supporting area

2–3 complementary views

Bottom

Key insights, context, and next steps

Final Quality Checklist

·        Dashboard size matches the viewing environment.

·        Each KPI and chart answers a clear question.

·        Colors, labels, and units are consistent.

·        Captions explain important findings.

·        Spacing, containers, and icons support readability.

·        Filters and cross-sheet interactions work as intended.

·        Data connections, totals, and calculations are validated.

 
 

+1 (302) 200-8320

NumPy_Ninja_Logo (1).png

Numpy Ninja Inc. 8 The Grn Ste A Dover, DE 19901

© Copyright 2025 by Numpy Ninja Inc.

  • Twitter
  • LinkedIn
bottom of page