How to Create Dashboards with Tableau in 2026

Introduction

Tableau is the go-to tool for enterprise data visualization. In 2026, it enables quick connections to diverse data sources and the creation of interactive dashboards without writing code. This tutorial teaches the fundamentals: connecting to data, creating visualizations, and publishing. You will discover how to go from a raw Excel file to a professional dashboard in just a few steps. Each concept is illustrated with a concrete sales tracking example.

Prerequisites

Tableau Desktop 2025.4 or higher (trial version available)
An example sales Excel file
Free Tableau Public account
Basic Excel knowledge

Download and Installation

terminal

# Download Tableau Desktop from the official website
# Run the .exe or .pkg file depending on your OS
# Activate the 14-day trial license

Installation takes 5 minutes. Choose the Public Desktop version if you are starting without a budget. Avoid Server versions at this stage.

Step 1: Connecting to Data

Open Tableau and select 'Microsoft Excel'. Choose your sales.xlsx file. Tableau automatically detects sheets and field types.

SQL Query to Filter Data

requete_initiale.sql

SELECT date, region, SUM(ventes) as total_ventes
FROM ventes
WHERE annee = 2025
GROUP BY date, region;

This query limits the volume of imported data. Use it in Tableau via 'New Custom Query' to optimize performance.

Step 2: Creating Your First Visualization

Drag 'Date' to columns and 'Total Sales' to rows. Choose the 'Line' chart type. Add 'Region' to Color to compare performance.

Calculated Field for Margin

champ_calcule

// In Tableau, create a calculated field named 'Margin %'
// Formula:
SUM([Profit]) / SUM([Ventes])

Calculated fields apply dynamically. Avoid overly complex calculations at the start to maintain good performance.

Step 3: Building the Dashboard

Create a new Dashboard sheet. Add your visualizations by drag and drop. Use global filters to synchronize all views.

Interactive Filter Configuration

filtre_dashboard.json

{
  "filter": {
    "field": "Region",
    "type": "quick-filter",
    "applyToAll": true
  }
}

This configuration file simulates Tableau filter settings. Enable 'Apply to all sheets' for smooth navigation.

Step 4: Publishing and Sharing

Click 'Share' then 'Tableau Public'. Your dashboard becomes accessible via a web link. Enable comments to gather feedback.

Automatic Update Script

refresh_data.py

import tableauserverclient as TSC

server = TSC.Server('https://online.tableau.com')
server.auth.sign_in('user@exemple.com', 'token')
server.datasources.refresh('datasource-id')

This Python script updates the data daily. Run it via a task scheduler to keep dashboards always up to date.

Best Practices

Limit the number of colors to 5 maximum per dashboard
Always name your fields and sheets explicitly
Test your dashboards on mobile before publishing
Use sets for cohort analysis
Regularly save your .twbx files

Common Mistakes to Avoid

Forgetting to define relationships between tables (missing joins)
Using too many context filters that slow down rendering
Ignoring field aliases that make dashboards unreadable
Publishing without testing interactions on different browsers

Going Further

Discover our complete Tableau training to move to the intermediate level with LOD calculations and JavaScript extensions.