Data comes in many shapes and sizes, Tableau works best on tall narrow data, many rows, few columns. Often though data, particularly that found in crosstabs tends to be wide. Tableau Zen Master Matt Francis explains why the vizzes you create depends on the data’s shape and by using the pivot function, how to turn wide data into tall data and produce different vizzes with ease.
- [Narrator] In this example here,…we're gonna look at the global vehicle sales data…that you can find in your exercise folder.…Now, this is an example of a wide data source.…If we take a look at it, we can see that we have…regions in one column,…and then we have the sales for each of our years…in the other columns.…This is an example of cross tab.…Now, one advantage of this format of data is for data entry.…If we wanted to add another year,…it's just a case of adding another column…and adding the values in.…
That makes it real easy with data entry,…but in terms of reporting or visualizing the data,…it makes it quite tricky.…If we add regions to our sheet and then say the year 2005,…we can see here are the sales for 2005.…If we then want to add additional years,…we can add them in.…It's quite difficult to see any kind of trend…or any relationship between the two.…In order to create a nicer visualization,…we're gonna need to reshape the data,…and the way we do that is pivoting.…
To pivot the data, we're gonna go and 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.