In order to get the best Tableau performance your data connection needs to be fast. Tableau Data Extracts (TDE) are a highly optimised local data source that enables the fastest user experience. Tableau Zen Master Matt Francis explains how to create a TDE from a live data source, how to optimise it, refresh the data in it and some tips on how to make the best of TDE’s
- [Instructor] When we connect to a data source in Tableau,…one of the options given to us is to…have a live connection or an extract.…Now, which one we choose depends on a couple of factors.…And we're gonna look at some of the differences now.…So first of all, let's connect to some data.…So for this example we're gonna connect to an Excel file…you can find in your exorcise folder.…We're gonna look at the Sample - Superstore.xls.…Then we connect to our data,…and we drag the sheet that we're interested in,…in this case, orders, onto the pane.…
Now at the top right it shows the connection type,…so we've got a live connection to the database.…Now this means that we are…directly connected to the Excel sheet…that's held on the file system.…Any change that are made to that file…are gonna be updated straight away…in our Tableau visualization.…So if somebody changes one of the values…we're gonna set that reflected…when we refresh the data and reload it.…The change will be carried over into the viz.…This is great, because it means that…
The training starts with one of the most important features in Tableau: the difference between the green and blue pills (discrete and continuous data) and how this affects every single action Tableau performs. Then find out how to add new maps and create more effective dashboards that maximize screen real estate. Discover how actions can link together sheets and provide greater levels of interactivity and performance, and how formatting can make an ordinary dashboard demand attention. Plus, get some bonus tips on performing date and time calculations in Tableau. This course deep-dives into the practical, applicable, and essential skills that anyone doing data visualization and analytics in a professional setting needs to have.
- Green vs. blue pills
- Using filters, colors, and dates
- Connecting to data
- Extracting data
- Cleaning and prepping data
- Pivoting data
- Merging and joining data
- Highlighting data
- Using the Analytics pane
- Creating new maps
- Creating calculations based on parameters
- Designing dashboards
Skill Level Intermediate
Q. Thise course was updated 04/21/2017. What changed?
A. Videos were added to cover features in Tableau 10.2.
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
9. Tableau 10.2 Updates
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.