How and Why to Create Tableau Data Extracts (.hyper)

Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
If you want to create the best user experience in Tableau, odds are you want to convert your data connections into extracts. Tableau Data Extracts (.hyper) provide the most efficient way to query data in Tableau. Extracts are local snapshots of your data which have been optimized for usage in Tableau.
Extracts can be customized to filter data, aggregate data, and even hide unused fields. Server and cloud-based data sources can support automated extract refreshes on Tableau Server and Tableau Cloud.
If you're ready to take your Tableau development experience and end-user experience to the next level, check out this video on how to convert your data connections to Tableau Data Extracts!
Resources:
•Mariners 2023 Example Data: www.baseball-reference.com/te...
•Google Sheet IMPORT Functions: onenumber.biz/blog-1/2021/6/9...
•Tableau Prep Living Connections: onenumber.biz/blog-1/2021/5/1...
•How to Generate Tableau Extracts Faster: onenumber.biz/blog-1/2021/3/1....
Chapters:
0:00 What is a Tableau Extract?
1:18 How to Initiate an Extract
2:20 Logical vs. Physical Table
3:00 Example Data Exploration
4:38 Aggregation Option
5:13 Number of Rows
5:58 Hide all Unused Fields
7:00 Creating the Extract
7:28 Unhide Fields
8:42 Incremental Refresh
10:00 Refresh Extract in Tableau Desktop
10:35 Publish Extract
12:45 Automating Extract Refresh
14:23 Where is a local Extract saved?
15:14 Extract History