Tableau for Data Analysts

Tableau is not the most common tool in Indian job listings — Power BI holds that position — but it remains the gold standard for visual analytics at global companies and data-heavy MNCs. A data analyst who knows both tools is immediately more hireable for international clients, US-facing teams, and companies that standardised on Salesforce or Tableau CRM.

More importantly, Tableau's philosophy of drag-and-drop exploration with a deeply expressive calculation language teaches you to think about data visualisation differently. Many analysts who learned Power BI first find that Tableau sharpens their instincts about visual grammar and what makes a chart genuinely useful rather than merely populated.

This chapter covers Tableau Desktop from first connection to advanced techniques — calculated fields, LOD expressions, parameters, dashboard actions, and publishing to Tableau Public. At the end we compare Tableau and Power BI honestly so you can decide how much time to invest in each.

Tableau Interface: The Mental Model

Tableau's interface is built around one fundamental concept: Dimensions (categorical fields — text, dates, IDs) go on Rows and Columns to define the structure of the view. Measures (numerical fields) go onto the Marks card to define what is being shown. Everything else — colour, size, tooltip, detail, label — lives on the Marks card as well.

Key Interaction Shortcuts

Calculated Fields

Calculated fields let you create new fields from existing data using Tableau's calculation language. There are three types — row-level calculations, aggregate calculations, and table calculations — and understanding the difference prevents the most common errors.

Row-Level Calculations (compute per row before aggregation)

// Profit Margin per row
[Profit] / [Sales]

// Classify order size
IF [Quantity] >= 10 THEN "Bulk"
ELSEIF [Quantity] >= 5 THEN "Medium"
ELSE "Small"
END

// Days to ship
DATEDIFF('day', [Order Date], [Ship Date])

// Clean a string field
UPPER(TRIM([Region]))

Aggregate Calculations (compute on the aggregated values)

// Average order value
SUM([Sales]) / COUNT([Order ID])

// % of total (needs table calc or LOD — see below)
SUM([Profit]) / TOTAL(SUM([Profit]))

// Running total (Quick Table Calc → Running Total)
// Applied as a table calculation on SUM([Sales])

String, Date and Logical Functions Reference

LOD Expressions — The Most Powerful Feature in Tableau

LOD (Level of Detail) expressions let you compute aggregations at a dimension granularity that is different from the granularity of the current view. This solves a class of problems that are genuinely difficult in Power BI without complex DAX.

FIXED — Customer's First Order Date

// First order date per customer (ignores any date filter in the view)
{ FIXED [Customer ID] : MIN([Order Date]) }

// Days since first order (row-level calc using the LOD above)
DATEDIFF('day',
  { FIXED [Customer ID] : MIN([Order Date]) },
  [Order Date]
)

FIXED — Revenue Contribution % (% of Total)

// Total revenue across ALL rows, regardless of what's in the view
{ FIXED : SUM([Sales]) }

// % share for the current dimension in the view
SUM([Sales]) / { FIXED : SUM([Sales]) }

INCLUDE — Average Order Value per Customer in a Regional View

// Average order value per customer, computed at order granularity,
// displayed in a region-level view
{ INCLUDE [Order ID] : SUM([Sales]) }
// → drag this onto Rows and aggregate with AVG()

EXCLUDE — Compare Each Region to the Overall Average

// Overall average sales (excludes Region from view's granularity)
{ EXCLUDE [Region] : AVG([Sales]) }

// In a bar chart of Sales by Region, add this as a reference line
// or subtract it to show above/below average

Parameters: Making Dashboards Interactive

Parameters are user-controlled variables you create in Tableau. Unlike filters (which filter data), parameters feed values into calculated fields, reference lines, and bin sizes — giving users dynamic control over what the view shows.

Creating and Using a Parameter

// Step 1: Create the parameter
// Right-click in Data pane → Create Parameter
// Name: "Select Metric"
// Data type: String
// Allowable values: List
// Add values: "Sales", "Profit", "Quantity"

// Step 2: Create a calculated field that uses the parameter
CASE [Select Metric]
  WHEN "Sales"    THEN [Sales]
  WHEN "Profit"   THEN [Profit]
  WHEN "Quantity" THEN [Quantity]
END

// Step 3: Use this calc field on Rows/Columns instead of the
// individual measures. Show the parameter control on the dashboard.
// Now the user can switch between metrics without changing the sheet.

Parameter for Dynamic Top-N Filter

// Create parameter: "Top N Products"
// Data type: Integer, Range: 1–20, Step: 1, Default: 10

// Create a calculated field:
RANK(SUM([Sales]))

// Add this rank field to Filters, show only rank <= [Top N Products]
// Add the parameter control to the dashboard — the Top N list updates live

Dashboard Actions: Cross-Filter, URL, and Highlight

Dashboard Actions wire sheets together so that interacting with one chart filters, highlights, or navigates within others. They are what separate a Tableau dashboard from a collection of charts on a slide.

Tableau Public: Your Free Portfolio Platform

Tableau Public is a free cloud hosting service for Tableau workbooks. Every dashboard you publish gets a public URL you can share on LinkedIn, add to your resume, and embed in your portfolio website. It is one of the best free tools in data analytics for portfolio building.

Publishing workflow:

1. Build your dashboard in Tableau Desktop (or Tableau Public Desktop app)
2. File → Save to Tableau Public → sign in with free account
3. Your workbook uploads and gets a URL:
   public.tableau.com/views/[your-workbook-name]

4. From the published view:
   → Share: copy the embed code for your portfolio site
   → Download: viewers can download your .twbx file
   → Subscribe: viewers can subscribe to email snapshots

Portfolio tip: publish 3–5 dashboards covering different chart types —
a map, a scatter plot, a KPI scorecard, a cohort table, and a bar/line combo.
Tableau Public profiles rank in Google — your name + "data analyst" becomes
findable without needing a personal website.

Power BI vs Tableau: An Honest Comparison

This question comes up in almost every analyst's learning journey. Here is an honest breakdown based on the Indian job market and the nature of each tool.

6 Tableau Best Practices for Data Analysts

Quick-Reference: Tableau Calculation Cheat Sheet