Data needs to be organized to optimize Tableau's functionality.
- [Instructor] So starting in Tableau 10,…we now have the ability to create…cross data to joins.…So for this dashboard, we're going to…import our data from two data sources,…the World Bank and UN,…and then merge them together into a single data file.…Cross database joins our powerful tool in linking your data.…The join adds the data right into a single file,…meaning it's easier to do calculations,…table calcs, filters, action, et cetera.…And so we're going to add the data from…the UN and the World Bank…together into a single file.…
Because one of the first steps we need to take…in building our dashboard is connecting…to and importing our data.…So let's go ahead and bring in our two data sources.…To do this, I'm going to go to Connect,…and then click on Excel file.…And now I'm going to import my Data Extract…on World Development Indicators.…And now you'll see I've got my list of sheets…over here on the left-hand column.…Now we're going to want to use our data revise sheets.…So that's where we've reworked our data.…
Author
Nate Makdad
Released
12/2/2016- Sketching your designs
- Formatting data
- Creating cross-data joins
- Creating visuals
- Grouping data
- Using stories vs. tabs
- Changing chart measures and types with interactive parameters
- Making iterations and improvements on your Tableau dashboard design
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome36s
-
-
1. Tableau Dashboards
-
Why Tableau?3m 38s
-
Sketching the design2m 34s
-
-
2. Worksheet Design
-
Tableau data format4m 26s
-
Cross-data joins4m 40s
-
Data quality check6m 41s
-
Creating visuals4m 8s
-
Applying design requirements1m 17s
-
Using calculated fields2m 59s
-
Creating sets3m 19s
-
Reference lines4m 54s
-
-
3. Dashboard Design
-
Dashboard hierarchy6m 20s
-
Story vs. tabs3m 25s
-
Dashboard objects5m 39s
-
Visual grouping4m 24s
-
-
4. Designing Interactivity
-
Dashboard actions3m 45s
-
Mobile device management4m 6s
-
5. Keeping Your Dashboard Up to Date
-
Viz of the week2m 21s
-
Iterations and improvements3m 44s
-
-
Conclusion
-
Next steps41s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Cross-data joins