Free to read · Three levels

Tableau: analytical grain, calculation scope and governed delivery

Eighteen developed lessons connect data roles, relationships, aggregation, filters, LOD, table calculations, dates, interactions, extracts, performance, security, publishing and Prep through synthetic cafe data.

18 lessonsEnglish + ArabicContent reviewed
Start learning

In this course

Define what each row, mark and result means before designing a workbook. The three levels develop concrete source, view, calculation and consumer contracts. Every lesson includes five developed sections, two explained examples, three diagnostic mistakes, two worked exercises, takeaways and specific official references. Arabic explanations preserve the full questions, qualifications and worked reasoning in the same structure.

Use small independent oracles to challenge duplicated totals, unexpected denominators, running calculations and stale copies. All Tableau expressions, model diagrams, GUI and hosted plans remain unexecuted runnable:false illustrations. Only complete standard-library Python programs run in isolated temporary storage using public synthetic data. No workbook engine, account, server, cloud site, database, source or administrative service is accessed.

What you will learn

  • Preserve source identity and grain through relationships, joins, unions and preparation.
  • Explain aggregate, LOD and table-calculation results through explicit populations and stages.
  • Design understandable interactions, calendar comparisons and accessible reader journeys.
  • Review extracts, hosted access, permissions, licensing boundaries and delivery evidence accurately.

Your learning path

Three levels

Basic: fields, models and views

Build precise artifact, grain, role, aggregation, filter and chart foundations.

  1. Workbooks, worksheets and analytical contracts
  2. Types, roles and discrete/continuous fields
  3. Relationships, joins, unions and grain
  4. Marks, granularity and aggregation
  5. Filters, context and order of operations
  6. Charts, sorting and missing data
Explore this level

Intermediate: calculation and interaction scope

Develop row/aggregate, LOD, table-calculation, calendar, input and dashboard contracts.

  1. Row/aggregate calculations and null policy
  2. LOD, FIXED, INCLUDE, EXCLUDE and scope
  3. Table calculations, addressing and partitioning
  4. Dates, period grain and calendar policy
  5. Parameters, sets and controlled scenarios
  6. Dashboard actions, navigation and accessibility
Explore this level

Advanced: quality and governed delivery

Review freshness, performance, security, publishing, Prep and complete release evidence.

  1. Extracts, live connections and freshness
  2. Performance evidence and model reduction
  3. Permissions, user filters and row security
  4. Publishing, site roles and governed delivery
  5. Prep flows, quality and output contracts
  6. Capstone: validation and delivery evidence
Explore this level

Who this is for

  • Analysts and workbook authors seeking precise data and calculation foundations.
  • Reviewers responsible for visual meaning, data quality, refresh and governed consumption.

Before you start

  • Basic tables, arithmetic and filtering familiarity; Tableau expressions and modeling concepts are introduced in context.
  • No Tableau installation, license purchase, account, server or real data source is required to study the material.

Related technical solutions

Inflated sales after data combinationTrace physical duplication, native grain and matching assumptions before using a calculation to conceal an unexpected total.Unexpected LOD and running-total resultsTrace calculation grain, filter stages and virtual-table traversal when a denominator or cumulative value changes after interaction.Hosted staleness and consumer accessSeparate source freshness, extract processing, hosted connectivity and access capabilities when local authoring differs from a consumer’s view.