Tableau Fundamentals
Tableau is a visual analytics platform that turns connected data into interactive worksheets and dashboards. Authors arrange fields to ask questions, while Tableau translates those choices into queries and visual marks.
itData engineering and analytics | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Don't Panic
Don't Panic: Tableau Fundamentals
Tableau is the bit of the data stack that turns a question into something people can see, poke, filter, and occasionally misread with great confidence. It begins with a file, database, or published data source. You arrange fields, Tableau turns that arrangement into a query, and the returned groups become marks in a worksheet. A dashboard is what happens when several worksheets agree to share a canvas.
The load-bearing idea is grain, meaning what one row represents. An order line and an order are not interchangeable, even if both have a column called Sales. Tableau is keen to help by aggregating measures, drawing axes, and making the result look finished. It cannot know whether SUM, AVG, COUNT, or COUNTD answers the question you meant. The picture is therefore the last step of the reasoning, not a decorative reward for dragging enough pills around.
The other hinge is the data source. It carries connections, tables, relationships, field roles, calculations, and names. A live connection asks the source for results as a view needs them. An extract asks a Hyper snapshot instead, which can be faster but requires refresh. Neither choice is a magic button. Freshness, credentials, query time, and source availability are all still somewhere in the machinery, quietly waiting for a Monday morning.
Then come the marks. Rows and Columns establish structure. The Marks card decides color, size, label, detail, tooltip, and other encodings. Add a dimension to Detail and one mark can become many without a new header announcing the fact. This is not Tableau being mysterious. It is Tableau taking the question literally while the author has stopped reading the view.
A published workbook is an operated artifact, not a file released into the wild to forage. Projects, permissions, data credentials, refresh schedules, and viewer identity decide whether it works and for whom. Hidden sheets are layout, not security. Tableau Public is public. The word is doing all the work there.
For the full map, read the intro when the query path needs names and boundaries. Use the slides when the relationships between data source, worksheet, dashboard, and publication need to stay in one frame. Keep the cheatsheet nearby while building a view. Then use the exercise to make a small question survive contact with real field placements, filters, and marks.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://help.tableau.com/current/tableau/en-us/tableau_product_overview.htm
Supports
- Roles of Tableau Desktop, Cloud, Server, Prep, Public, and related services
- Tableau visual analytics product path
- https://www.tableau.com/why-tableau/what-is-tableau
Supports
- Tableau as a visual analytics platform
- Founding in 2003, Stanford research roots, VizQL, and Salesforce acquisition
- https://help.tableau.com/current/pro/desktop/en-us/basicconnectoverview.htm
Supports
- Tableau connectors, files, databases, published sources, and connection workflow
- https://help.tableau.com/current/pro/desktop/en-us/datasource_plan.htm
Supports
- Data source as connection, data, tables, and semantic metadata
- Live, extract, reuse, grain, and planning considerations
- https://help.tableau.com/current/pro/desktop/en-us/datasource_multitable_normalized.htm
Supports
- Relationships as the recommended first approach to multi-table analysis
- Logical and physical layers, preserved table detail, joins, and unions
- https://help.tableau.com/current/pro/desktop/en-us/datasource_multitable_analysis_overview.htm
Supports
- Context-sensitive queries across related logical tables
- Original table detail and relevant-table query behavior
- https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm
Supports
- Dimension and measure roles
- Discrete blue headers and continuous green axes
- Measure aggregation and field-role conversion
- https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
Supports
- Rows, Columns, Filters, Pages, and Marks card behavior
- Marks, level of detail, encodings, and Show Me
- https://help.tableau.com/current/pro/desktop/en-us/refreshing_data.htm
Supports
- Live, extract, and published data-source connection behavior
- Refresh behavior and source-schema change failures
- https://help.tableau.com/current/pro/desktop/en-us/perf_extracts.htm
Supports
- Extracts as compressed snapshots and query acceleration caches
- Live-versus-extract performance tradeoffs and extract filtering
- https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm
Supports
- Calculated fields saved as data-source fields
- Tableau calculation documentation path
- https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_understand_types.htm
Supports
- Basic, level-of-detail, and table calculation types
- Row-level and aggregate calculation distinction
- https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm
Supports
- FIXED, INCLUDE, and EXCLUDE behavior
- View grain, filter order, aggregation, and LOD limitations
- https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
Supports
- Extract, data source, context, dimension, and measure filter order
- Discrete, continuous, and interactive filtering behavior
- https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm
Supports
- Filter actions sending selected values between worksheets
- Source, target, trigger, field mapping, and cleared-selection controls
- https://help.tableau.com/current/pro/desktop/en-us/actions_sets.htm
Supports
- Set actions changing set membership through hover, selection, or menus
- https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_howto.htm
Supports
- Project, permissions, data-source, credential, sheet, and refresh publication choices
- Hidden sheets not being a security measure
- https://help.tableau.com/current/pro/desktop/en-us/accessibility_create_view.htm
Supports
- Accessible view authoring, mark limits, keyboard access, and underlying data
- Relationship between mark density, client rendering, and accessibility
- https://help.tableau.com/current/pro/desktop/en-us/public_faq.htm
Supports
- Tableau Public data and connector limits
- Tableau Public extract-only publication behavior
- https://github.com/sindresorhus/awesome
Supports
- Required Awesome discovery starting point
- Discovery of data, visualization, and charting lists
- https://github.com/hal9ai/awesome-dataviz
Supports
- Discovery of Vega-Lite, Observable-related tools, RAWGraphs, D3, and wider visualization resources
- Curated open-source data-visualization ecosystem categories
- https://vega.github.io/vega-lite/
Supports
- Vega-Lite declarative specifications for data, transforms, marks, encodings, scales, and interactions
- https://observablehq.github.io/plot/
Supports
- Observable Plot marks, scales, transforms, facets, projections, and exploratory visualization role
- https://rawgraphs.github.io/
Supports
- RAWGraphs mapping of data dimensions to visual variables
- Browser processing and vector or raster export
- https://www.datawrapper.de/academy
Supports
- Datawrapper learning paths for charts, tables, maps, annotation, accessibility, and export
- https://d3js.org/getting-started
Supports
- D3 data transformation, scales, axes, shapes, and browser visualization learning path
- https://www.tableau.com/blog/5-1-release
Supports
- February 2010 Tableau 5.1 release and Tableau Public web publishing launch
- https://www.tableau.com/blog/what-is-tableau-public
Supports
- Tableau Public 2010 launch and public visual analytics purpose
- https://www.tableau.com/blog/announcing-launch-tableau-public-90
Supports
- April 2015 Tableau 9 milestone and Data Interpreter, analytics, map, and performance changes
- https://www.tableau.com/blog/hello-world-its-tableau-10-55481
Supports
- August 2016 Tableau 10 release and cross-database joins, filters, clustering, and authoring changes
- https://www.tableau.com/blog/introducing-tableau-public-105
Supports
- January 2018 Tableau 10.5 milestone and Hyper extract engine introduction
- https://www.tableau.com/blog/tableau-prep-project-maestro-here-redefining-your-data-prep-experience-84620
Supports
- April 2018 Tableau Prep launch and flow, profile, and data-grid design
- https://www.salesforce.com/news/?p=21759
Supports
- August 2019 completion of Salesforce acquisition of Tableau
- https://www.tableau.com/blog/relationships-tableau-data-model
Supports
- May 2020 Tableau 2020.2 relationships milestone and logical multi-table model
- https://www.salesforce.com/news/stories/tableau-pulse-general-availability-news/
Supports
- February 2024 Tableau Pulse general availability and metrics-centered insight experience
- https://www.tableau.com/
Supports
- Tableau Landscape placement and official homepage
- https://www.microsoft.com/en-us/power-platform/products/power-bi
Supports
- Power BI visual analytics, governed metrics, reports, and Fabric placement
- https://www.qlik.com/us/products/qlik-cloud-analytics
Supports
- Qlik associative exploration, interactive dashboards, preparation, reporting, and alerting
- https://cloud.google.com/looker
Supports
- Looker semantic modeling, governed queries, dashboards, APIs, and embedding
- https://www.sigmacomputing.com/product/architecture
Supports
- Sigma spreadsheet interface, live warehouse queries, SQL compilation, and governed warehouse boundary
- https://www.thoughtspot.com/product/analytics
Supports
- ThoughtSpot natural-language search, Liveboards, live queries, and assisted analytics
- https://www.domo.com/platform
Supports
- Domo connectors, transformations, dashboards, embedding, alerts, and workflow automation
- https://www.metabase.com/
Supports
- Metabase graphical questions, SQL, dashboards, models, self-hosting, and embedding
- https://superset.apache.org/docs/intro/
Supports
- Apache Superset datasets, SQL exploration, charts, dashboards, and semantic features
- https://help.tableau.com/current/guides/get-started-tutorial/en-us/get-started-tutorial-connect.htm
Supports
- Sample - Superstore as an official practice data source
- Connecting the sample data source for a first Tableau view
- https://help.tableau.com/current/pro/desktop/en-gb/publish_workbooks_tableaupublic.htm
Supports
- Publishing a workbook to Tableau Public
- Tableau Public workbooks and data being publicly accessible
