Extract optimization in Tableau - Step-by-Step Guide

Introduction

Extract optimization helps your Tableau dashboards load faster by making the data extract smaller and more efficient. It solves the problem of slow performance when working with large data sets by reducing unnecessary data and improving query speed.

When your Tableau workbook takes too long to open or refresh due to large data extracts

When you want to reduce the size of your data extract to save storage space

When you need faster dashboard interactions for better user experience

When your extract contains data you do not need for your analysis

When you want to improve refresh times for scheduled extract updates

Steps

Step 1: Open

- Tableau Desktop and load your workbook

Your workbook and data extract are visible in the Data pane

Step 2: Click

- Data menu > Extract > Edit

The Extract Data dialog box opens showing extract options

Step 3: Select

- Filters section in the Extract Data dialog

You can add filters to limit data included in the extract

💡 Use filters to exclude data you don't need, like old dates or irrelevant categories

Step 4: Click

- Aggregation checkbox in the Extract Data dialog

Data will be aggregated to a higher level, reducing extract size

💡 Aggregate data to the level needed for your analysis to improve speed

Step 5: Click

- Extract button in the Extract Data dialog

Tableau creates a new optimized extract with your settings applied

Step 6: Save

- Extract file location dialog

Your optimized extract is saved and used in your workbook

Before vs After

Before

Extract contains 1 million rows including all dates and categories, workbook loads slowly taking over 2 minutes

After

Extract filtered to last 2 years and aggregated by month, size reduced by 70%, workbook loads in under 30 seconds

Settings Reference

Filters

📍 Extract Data dialog > Filters section

Limit data included in the extract to reduce size and improve performance

Default: No filters applied

Aggregation

📍 Extract Data dialog > Aggregation checkbox

Aggregate data to a higher level to reduce extract size and speed up queries

Default: Unchecked

Incremental refresh

📍 Extract Data dialog > Refresh options

Update only new or changed data to speed up extract refreshes

Default: Full refresh

Common Mistakes

Not applying filters to exclude unnecessary data

Including all data makes the extract large and slow to load

Use filters in the Extract Data dialog to include only relevant data

Not aggregating data when detailed level is not needed

Detailed data increases extract size and slows queries

Enable aggregation to summarize data at the needed level

Forgetting to save the optimized extract

Changes to extract settings are not applied until saved

Always save the extract after editing to apply optimization

Summary

Extract optimization reduces data size and improves Tableau dashboard speed

Use filters and aggregation to include only necessary data at the right detail level

Remember to save the extract after applying optimization settings