February 7, 2017
Tableau Tip Tuesday: How to Create an Aggregated Extract
Aggregated extracts are an undervalued and underused feature in Tableau.Week 6 of #MakeoverMonday allowed us to work with 105M Chicago taxi trips from an Exasol data source. This is fantastic, until you need to publish the viz to Tableau Public which has a 15M record limit. The way to work around the 15M limit is by creating an aggregated extract, for which Tableau has created a great quick start guide here. In the video below, I show you how I created an aggregated extract with the Chicago taxi data.
Keep in mind, though, that your data has to be aggregatable. For example, if you do cohort analysis, you likely won't be able to aggregate the data and maintain the cohorts.
Why aggregated extracts?
- Smaller extracts
- Better performance
- Only contains the necessary dimensions
- Makes extract refreshes faster
- Reduces resource burden on your Tableau Server
Steps for Creating an Aggregated Extract
- Hide unused dimensions
- Add extract filters (optional)
- Aggregate the data for the visible dimensions
- Create the extract