Skip to content
Tableau
All coursesPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Data Connections and Modelling Interview Questions for Tableau

24 Data Connections and Modelling questions with answers for tableau roles — 6 easy, 13 medium, 5 hard.

About Data Connections and Modelling

Learn to connect Tableau to files, databases and cloud warehouses, choose between live and extract connections, and model data with relationships, joins, unions and blending. You will also use Tableau Prep for cleaning and understand extract refresh, data source filters and custom SQL trade-offs that affect accuracy and performance.

Sheet progressStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

What is the difference between a live connection and an extract?

Data Connections and ModellingEasy
Save to ▾
Show answer
A live connection sends queries directly to the source database each time the view changes, so data is always current but performance depends on the database. An extract is a compressed snapshot stored in the Hyper format, which is usually faster and works offline, but must be refreshed on a schedule. Teams choose live for real-time needs and extracts for speed or slow sources.
02

What types of data sources can Tableau connect to?

Data Connections and ModellingEasy
Save to ▾
Show answer
Tableau connects to files such as Excel, CSV, JSON, PDF and spatial files, relational databases such as MySQL, PostgreSQL, SQL Server and Oracle, cloud warehouses such as Snowflake, BigQuery, Redshift and Databricks, and applications through connectors or ODBC and JDBC. It also supports published data sources on Server or Cloud and web data connectors for custom APIs.
03

What are relationships in Tableau and how are they different from joins?

Data Connections and ModellingEasy
Save to ▾
Show answer
Relationships, shown as noodles in the logical layer, describe how tables relate without merging them in advance. Tableau builds the right join at query time based on fields in the view, keeping each table at its native level of detail, which avoids duplication. Joins, in the physical layer, merge tables into one flat table before analysis, which can duplicate measures when grains differ.
04

What join types are available in Tableau?

Data Connections and ModellingEasy
Save to ▾
Show answer
Tableau supports inner, left, right and full outer joins in the physical layer. Inner keeps matching rows only, left keeps all rows from the left table, right keeps all rows from the right, and full outer keeps everything with nulls where no match exists. You can also create join calculations when keys need transformation, such as trimming or changing case, before matching.
05

How do you connect Tableau to an Excel file with multiple sheets?

Data Connections and ModellingEasy
Save to ▾
Show answer
Open Tableau Desktop, choose Microsoft Excel under Connect, select the file, and the sheets appear on the left. Drag the main sheet to the canvas, then drag another sheet next to it to create a relationship and choose matching fields. Use Data Interpreter if the sheet has titles or merged cells. Go to a worksheet to start building views.
06

Your Excel source has merged header cells and title rows, and Tableau reads it incorrectly. What do you do?

Data Connections and ModellingEasy
Save to ▾
Show answer
Turn on Data Interpreter on the data source page, which detects headers, removes title rows and handles sub-tables. Review the interpreter results sheet it produces. If it still fails, clean the file in Excel or Tableau Prep by removing merged cells and keeping one header row. Ask the data owner for a clean, tabular format for future files.
07

What is data blending and when would you use it?

Data Connections and ModellingMedium
Save to ▾
Show answer
Data blending combines data from two separate data sources on a sheet using linking fields, with one primary and one or more secondary sources. Secondary data is aggregated to the linking level and then joined like a left join. Use it when data lives in different systems and cannot be joined, such as sales in a database and targets in Excel. Relationships have replaced many blending use cases.
08

What is the difference between joining, blending and relationships?

Data Connections and ModellingMedium
Save to ▾
Show answer
Joins merge tables at row level before analysis and can duplicate values. Blending queries each source separately, aggregates the secondary to the linking fields, and combines results per sheet, so it works across sources but has limitations such as no COUNTD from secondary in some cases. Relationships define flexible links and let Tableau choose joins per view while keeping each table's grain.
09

What is a union and when do you use it?

Data Connections and ModellingMedium
Save to ▾
Show answer
A union stacks tables with the same structure on top of each other, adding rows rather than columns. It is used for monthly or regional files such as Sales_Jan, Sales_Feb and Sales_Mar. Tableau supports manual unions and wildcard unions that pick up files or sheets matching a name pattern, and adds Table Name and Path fields to identify the source of each row.
10

What is the Hyper engine and what are its benefits?

Data Connections and ModellingMedium
Save to ▾
Show answer
Hyper is Tableau's in-memory data engine used for extracts since version 10.5. It is a columnar engine that loads and queries large datasets quickly, supports incremental refresh, and handles billions of rows on good hardware. Extracts in .hyper format improve dashboard speed, reduce load on source databases, and allow aggregation and filtering at extract time to keep the file small.
11

What is the difference between full and incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
A full refresh rebuilds the entire extract from the source, guaranteeing accuracy but taking longer. An incremental refresh adds only new rows based on a column such as an increasing ID or a date, which is fast but does not capture updates or deletes to old rows. Teams often schedule incremental refreshes daily and a full refresh weekly to keep data correct.
12

What is a data source filter and how is it different from an extract filter?

Data Connections and ModellingMedium
Save to ▾
Show answer
An extract filter limits which rows go into the extract file, reducing size permanently until the extract is redefined. A data source filter applies to every sheet using the source, live or extract, and is useful for security or removing test records. Both run before context filters. Extract filters improve storage and speed, while data source filters control the data visible to the workbook.
13

What is Tableau Prep Builder used for?

Data Connections and ModellingMedium
Save to ▾
Show answer
Tableau Prep Builder is a visual tool for cleaning, combining and shaping data before analysis. A flow includes input, clean, aggregate, pivot, join, union and output steps, and shows data profiles to spot nulls and outliers. Output can be a hyper extract, CSV, or published data source. With Prep Conductor on Server or Cloud, flows can run on schedule as a repeatable pipeline.
14

How do you use pivot in Tableau to reshape monthly columns into rows?

Data Connections and ModellingMedium
Save to ▾
Show answer
On the data source page, select the month columns such as Jan, Feb and Mar using Ctrl, right-click and choose Pivot. Tableau creates two fields, Pivot Field Names and Pivot Field Values. Rename them to Month and Sales. This converts wide data into long format, which works better for time-series charts and filters. The same is possible in Tableau Prep.
15

How do you set up an incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
Create an extract from the Data menu, choose Extract Data, and tick Incremental refresh. Select a column whose values always increase, such as Order ID or Load Timestamp. Publish to Server or Cloud and create a schedule for incremental refresh, plus an occasional full refresh. Ensure the source does not update old records, or those changes will be missed.
16

How do you blend sales data with a targets file in Tableau?

Data Connections and ModellingMedium
Save to ▾
Show answer
Connect to both sources. Build the view with the primary source, for example Region and Month from sales. Switch to the targets source in the Data pane, check the link icon next to Region and Month so they are active linking fields, then drag Target onto the view. Tableau aggregates targets to those fields. Make sure the linking field names and values match exactly.
17

After joining Orders with Returns, total sales went up. What happened?

Data Connections and ModellingMedium
Save to ▾
Show answer
The join type or grain caused duplication. If Returns has multiple rows per order, an inner or left join repeats each order line, so SUM(Sales) inflates. Fix it by using a relationship instead of a join, aggregating Returns to order level before joining, or using an LOD to deduplicate. Always check row counts before and after a join to catch this problem early.
18

Monthly sales files arrive in a folder every month. How do you avoid manual work each time?

Data Connections and ModellingMedium
Save to ▾
Show answer
Use a wildcard union on the folder with a pattern such as Sales_*.xlsx so new files are included automatically on refresh. Alternatively, build a Tableau Prep flow with a wildcard input and schedule it with Prep Conductor. Ensure every file has the same column names and types. Use the Path or Table Name field to derive the month if it is not in the data.
19

Tell me about a time you found a data quality issue before stakeholders did.

Data Connections and ModellingMedium
Save to ▾
Show answer
Situation: while refreshing a weekly revenue dashboard I noticed one region had dropped 60 percent overnight. Task: confirm whether it was real. Action: I checked row counts in the source, found a failed ETL load for two days, informed the data engineering team and added a warning banner. Result: the leadership meeting used corrected figures, and we added an automatic row-count check to the pipeline.
20

How does Tableau decide join type when using relationships?

Data Connections and ModellingHard
Save to ▾
Show answer
With relationships, Tableau uses performance options such as cardinality (one or many) and referential integrity (some or all records match). At query time it includes only tables needed for the fields in the view and typically uses outer join semantics, so unmatched dimension values are kept. Setting correct cardinality and integrity lets Tableau generate efficient queries and avoid unnecessary distinct counts.
21

What is custom SQL in Tableau and what are its drawbacks?

Data Connections and ModellingHard
Save to ▾
Show answer
Custom SQL lets you write your own query as a data source, useful for complex logic or pre-aggregation. The drawback is performance: Tableau wraps it as a subquery, so the database may not optimise filters well, and it blocks some features such as join culling. It is also harder to maintain. Prefer database views or relationships and use custom SQL only when needed.
22

A live connection dashboard on a large database is very slow. What options would you evaluate?

Data Connections and ModellingHard
Save to ▾
Show answer
Check the performance recording to see slow queries. Options include switching to an extract with aggregation and extract filters, adding database indexes or materialised views, removing custom SQL, enabling referential integrity assumptions, reducing the number of marks and quick filters, and using context filters wisely. If real-time is not required, a scheduled extract usually gives the biggest improvement.
23

Two tables have different grains: daily sales and monthly targets. How do you model them?

Data Connections and ModellingHard
Save to ▾
Show answer
Use a relationship between the tables on Region and a month key, since relationships keep each table at its own grain and avoid duplicating targets across days. In the view, aggregate sales to month level and compare with targets. If using joins, first aggregate daily sales to month in Prep or SQL. Blending on Region and MONTH(date) is another option.
24

A Snowflake or BigQuery live connection is costing a lot due to many queries. How would you reduce it?

Data Connections and ModellingHard
Save to ▾
Show answer
Use extracts where real-time data is not needed, schedule refreshes outside peak hours, and aggregate extracts to required grain. Reduce quick filters with relevant values, limit dashboards that auto-refresh, and use published data sources so caching is shared. Work with data engineers on materialised or clustered tables. Monitor query history and cost per dashboard to target the worst offenders.

Frequently asked questions

How important is Data Connections and Modelling in Tableau interviews?

Learn to connect Tableau to files, databases and cloud warehouses, choose between live and extract connections, and model data with relationships, joins, unions and blending. You will also use Tableau Prep for cleaning and understand extract refresh, data source filters and custom SQL trade-offs that affect accuracy and performance.

How should I use the Data Connections and Modelling sheet?

Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.

More question sheets

Tableau Fundamentals questionsCalculated Fields questionsLOD Expressions questionsTable Calculations questionsCharts and Visual Design questionsFilters, Parameters and Actions questionsDashboards and Tableau Server questions