You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
Tableau Desktop and Tableau Public; the interface and data pane; connecting Excel, CSV, database and supported cloud sources; reviewing data structure and field roles; dimensions and measures; discrete and continuous fields.
Learning outcomes
The lecture slides for this lesson are below.
By the end of this lesson you can:
Key idea: Connecting data is more than opening a file. You decide how Tableau reads the data (live or extract), how tables combine (relationship, join or union) and what role each field plays, and these choices determine whether your later numbers are right.
Installing Tableau means checking system requirements, downloading the right package, installing and activating (or signing in for Tableau Public). Afterwards, create a workbook and test a sample connection.
A workbook contains four kinds of sheet:
On a worksheet you work with the Data pane (fields) and Analytics pane (reference lines, trend lines, forecasts, clusters), the shelves and cards (Columns, Rows, Filters, Pages, Marks), the view itself, the sheet tabs and the status bar, which shows counts such as the number of marks.
Tableau connectors fall into three groups: files (Excel, text/CSV, JSON, PDF, spatial and statistical files), databases (for example Microsoft SQL Server, MySQL, PostgreSQL, Oracle) and cloud services.
Live versus extract:
| Live | Extract | |
|---|---|---|
| What happens | Tableau queries the source directly each time | Tableau stores a snapshot (a .hyper file) |
| Freshness | Always current | Current as of the last refresh |
| Performance | Depends on the source system | Usually fast |
| Use when | Data change often and the database is fast | Large files, slow sources, offline work, publishing to Tableau Public |
For Excel or CSV, check the sheet names, whether the first row holds headers, the field names, the sample rows in the data preview and the detected data types. For a database, check the server, database name, credentials and drivers.
These are three separate properties of a field:
Tableau guesses roles from data types, so numeric identifiers often land among the measures. You can change any of these properties in the Data pane by right-clicking a field.
A sales analyst connects to Sales_Data.xlsx and must decide how to set it up for a monthly dashboard that compares 2025 sales with the regional targets.
Flashcards · Connecting Data with Tableau
9 wordsA free platform that saves workbooks to a public online profile, visible to anyone.
Publishes, schedules and monitors Tableau Prep flows on Tableau Server or Tableau Cloud.
Tableau queries the data source directly, so views always show current data.
A stored snapshot of the data (.hyper file) that is fast and refreshed on demand or on a schedule.
A qualitative field used to group, slice and set the level of detail of a view.
A quantitative field that Tableau aggregates, for example with SUM or AVG.
Discrete fields show separate values as headers (blue); continuous fields form an axis (green).
A property that tells Tableau a field contains places so it can draw maps.
A logical link between tables on matching fields that keeps each table's own level of detail.
Both files are attached to the Course Overview lesson: Sales_Data.xlsx (clean) and Sales_Data_Raw.xlsx (raw, for Tableau Prep). data_dictionary.md explains every field. Use Tableau Public (free) or Tableau Desktop.
Sales_Data.xlsx. Drag Orders onto the canvas. Check: 12 fields and 4,770 rows (2,600 distinct orders; one row is one product line of an order).