Data can be stored across two or more distinct databases or files, maybe a order table in one, a customer table in another and these need to be merged into one . Tableau Zen Master Matt Francis shows how cross database joins combine tables from separate data sources in a single unified data source. This can now be done within Tableau, no 3rd party code is needed to achieve this any more.
- [Instructor] One of the great new features in Tableau 10…is the ability to perform cross-database joins,…or data integration.…This allows us to create a unified data source…where our data might come from…two completely different files.…In this example, we're looking at the Superstore Sales data,…which you can find in your Exercise folder.…In this sheet here, we're looking at the sales…per state and region across three product categories.…In this sheet are shown the overall sales for the year 2015.…
We can see that, for example, New York has…very high sales figures for technology.…This isn't taking into account the size of the population,…so for that we want to bring in some census information…and do some calculations so we can look at sales per capita.…This information isn't present in our current data source,…so we're gonna need to pull the information…from somewhere else.…Data integration is gonna allow us to join to a second file…and produce a unified data source.…Let's go on ahead and do that.…First, we're gonna edit our data source.…
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.