Extracts

Connecting Data in Tableau

Lis Sulmont

Head of Curriculum Expansion, DataCamp

Tableau file types

  • Packaged Workbook, .twbx: workbook and supporting files including the data source
  • Workbook, .twb: just the workbook
  • Extract, .hyper or .tde: local copy of parts or all of the data
  • Data Source, .tds: connection information and modifications to data
Connecting Data in Tableau

Extracts

A local copy of the entire or a subset of data.

  • Performance improvements
    • Supports very large data
    • Faster because leverages the Hyper database engine
  • Retain work done to enrich and extend the original data set
  • Work offline
Connecting Data in Tableau

Live connections

live_con.png

Data source has a direct connection to underlying data

Connecting Data in Tableau

Comparison

Live connections

  • Real-time updates
  • Slower because connection to external databases and data files

Extracts

  • Need to refresh data to get updates
  • Generally faster performance with Tableau's Hyper
Connecting Data in Tableau

Let's practice!

Connecting Data in Tableau

Preparing Video For Download...