Join Matt Francis for an in-depth discussion in this video Extract: Solution, part of Tableau 10 for Data Scientists.
- [Instructor] First thing we wanna do is…extract our data and then apply the filter to it.…We right click on our data source…and do Extract Data.…Here's when we're gonna apply the filter,…we can do that here at the Filter…and we wanna filter on Region.…And for our example, we just wanna have…the South and West filter selected.…Hit OK.…Extract.…Write somewhere where you wanna store it.…We'll call it our South West…Extract.…
Hit OK.…When I have our extracted data…only showing the South and West regions.…Next, we're gonna rename our data source…to make it clear that we've created an extract…and this is a subset of data,…so we'll call it South and West…Sales Extract.…And then we wanna add that information…to our title…and right click Title…and we'll say Regional Sales…using Data Source Name…last updated at Update Time.…
Click OK.…And now we an extract that only shows…two of our regions of interest…and we've renamed the data source…to make it clear that not only did we use an extract…and the last time that data was refreshed.…
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
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
- 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.