Extract optimization in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Tableau extract with incremental refresh.

Tableau

CREATE EXTRACT [1] FROM datasource

Drag options to blanks, or click blank then click option'

AFULL

BINCREMENTAL

CLIVE

DPARTIAL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing FULL extracts which refresh all data every time.

Selecting LIVE which does not create an extract.

Incremental extracts only add new data since the last extract, improving refresh speed.

2fill in blank

medium

Complete the code to set the extract refresh schedule to daily at midnight.

Tableau

SET EXTRACT REFRESH SCHEDULE TO [1] AT midnight

Drag options to blanks, or click blank then click option'

Aweekly

Bmonthly

Chourly

Ddaily

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing weekly or monthly which refresh less often.

Selecting hourly which refreshes too frequently.

Daily refresh at midnight ensures data is updated every day at 12 AM.

3fill in blank

hard

Fix the error in the extract filter to only include data from the last 30 days.

Tableau

FILTER EXTRACT WHERE Date >= [1]

Drag options to blanks, or click blank then click option'

ADATEADD('day', -30, TODAY())

BNOW() - 30

CTODAY() - 30

DDATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)

Attempts:

3 left

💡 Hint

Common Mistakes

Using arithmetic subtraction directly on dates which is invalid.

Using SQL syntax like DATE_SUB which Tableau does not support.

DATEADD with negative 30 days subtracts 30 days from today correctly in Tableau.

4fill in blank

hard

Fill both blanks to optimize extract size by excluding unused columns and filtering recent data.

Tableau

CREATE EXTRACT FROM datasource EXCLUDE COLUMNS [1] WHERE Date >= [2]

Drag options to blanks, or click blank then click option'

A['Comments', 'Attachments']

BDATEADD('day', -60, TODAY())

CDATEADD('month', -1, TODAY())

D['UserNotes', 'Logs']

Attempts:

3 left

💡 Hint

Common Mistakes

Excluding columns that are actually needed.

Using incorrect date functions or intervals.

Excluding unused columns like 'UserNotes' and 'Logs' reduces extract size. Filtering data from last 60 days keeps extract recent.

5fill in blank

hard

Fill all three blanks to create an optimized extract with incremental refresh, filter, and schedule.

Tableau

CREATE EXTRACT [1] FROM datasource WHERE Date >= [2] SET REFRESH SCHEDULE TO [3]

Drag options to blanks, or click blank then click option'

AINCREMENTAL

BDATEADD('day', -30, TODAY())

CDAILY

DFULL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing full extract which refreshes all data every time.

Setting refresh schedule to something other than daily.

Incremental extract updates only new data. Filtering last 30 days reduces extract size. Daily refresh keeps data fresh.

Practice

1. What is the main benefit of optimizing extracts in Tableau?

easy

A. Automatic data cleaning

B. More colorful visualizations

C. Faster dashboard performance and reduced storage use

D. Increased number of data sources

Solution

1. Step 1: Understand extract optimization purpose

   Extract optimization aims to make Tableau faster and lighter by reducing data size and improving query speed.

2. Step 2: Identify the main benefit

   Smaller extracts lead to quicker dashboards and less storage use, improving performance.

3. Final Answer:

   Faster dashboard performance and reduced storage use -> Option C

4. Quick Check:

   Extract optimization = Faster dashboards and less storage [OK]

Hint: Think speed and size reduction for extracts [OK]

Common Mistakes:

• Confusing extract optimization with visualization design
• Assuming it cleans data automatically
• Believing it increases data sources

2. Which of the following is the correct way to apply a filter when creating a Tableau extract?

easy

A. Create extract first, then add filter in data source

B. Apply filter after publishing the workbook only

C. Filters cannot be applied to extracts

D. Select the filter option before creating the extract

Solution

1. Step 1: Review extract creation steps

   Filters should be applied during extract creation to reduce data size effectively.

2. Step 2: Identify correct timing for filter application

   Applying filters before extract creation ensures only needed data is included.

3. Final Answer:

   Select the filter option before creating the extract -> Option D

4. Quick Check:

   Filter before extract creation = Correct [OK]

Hint: Apply filters before extract to reduce data [OK]

Common Mistakes:

• Trying to filter only after publishing
• Thinking filters can't be used with extracts
• Adding filters after extract creation

3. Given a Tableau extract with 1 million rows, which action will most reduce extract size?

medium

A. Add a filter to include only last 3 months of data

B. Change the dashboard colors to grayscale

C. Increase the number of worksheets in the workbook

D. Add more calculated fields without aggregation

Solution

1. Step 1: Analyze impact of filtering data

   Filtering to last 3 months reduces rows drastically, shrinking extract size.

2. Step 2: Evaluate other options

   Changing colors or adding worksheets does not affect extract size; calculated fields without aggregation may increase size.

3. Final Answer:

   Add a filter to include only last 3 months of data -> Option A

4. Quick Check:

   Filtering data reduces extract size best [OK]

Hint: Filter data to reduce extract size, not visuals [OK]

Common Mistakes:

• Thinking dashboard colors affect extract size
• Assuming more worksheets reduce extract size
• Adding calculated fields without aggregation increases size

4. You created an extract but notice it is still very large. Which fix will help optimize it?

medium

A. Remove unused fields and apply filters during extract creation

B. Add more calculated fields to the extract

C. Increase extract refresh frequency

D. Disable incremental refresh

Solution

1. Step 1: Identify causes of large extract size

   Unused fields and lack of filters keep extract size large.

2. Step 2: Apply best practices to reduce size

   Removing unused fields and applying filters during extract creation reduces data volume effectively.

3. Final Answer:

   Remove unused fields and apply filters during extract creation -> Option A

4. Quick Check:

   Remove unused fields + filter = Smaller extract [OK]

Hint: Drop unused fields and filter early [OK]

Common Mistakes:

• Adding calculated fields increases size
• Increasing refresh frequency doesn't reduce size
• Disabling incremental refresh can increase load

5. You have a large dataset updating daily. To optimize extract refresh time and size, what is the best approach?

hard

A. Add all fields and refresh extract manually weekly

B. Use incremental refresh with filters and aggregate data in extract

C. Disable extract and use live connection only

D. Create a full extract every day without filters

Solution

1. Step 1: Understand incremental refresh benefits

   Incremental refresh updates only new data, saving time and resources.

2. Step 2: Combine with filters and aggregation

   Filtering reduces data volume; aggregation summarizes data, both reducing extract size and improving speed.

3. Step 3: Evaluate other options

   Full daily extracts are slow; live connections may be slower; manual weekly refresh misses daily updates.

4. Final Answer:

   Use incremental refresh with filters and aggregate data in extract -> Option B

5. Quick Check:

   Incremental + filter + aggregation = Best optimization [OK]

Hint: Combine incremental refresh with filters and aggregation [OK]

Common Mistakes:

• Doing full daily extracts wastes time
• Ignoring aggregation increases extract size
• Relying only on live connections may slow dashboards