Building a viz in Tableau is simply a matter of dragging and dropping fields into the canvas and building the viz. Using the analytics pane analysing the data is also a simple drag and drop action. Tableau Zen Master Matt Francis demonstrates how to create reference lines, box plots, forecasting and trend lines with out having to write any code and basic statistics knowledge
- View Offline
- Exercise Files
- [Instructor] This bar chart shows…our sales per product category.…And subdivided by subcategory.…We might be interested in wanting to know,…what's the average sales for our categories…across each of our subcategories?…So for that we want an average line.…We simply drag it into the canvas.…We then have the option to say,…do we want it applied to the entire table,…the pane, or the cell?…In this case we want to do it across each of the panes.…Because we're interested in the average…across each category.…Now we've got our average line across each one.…
To make it a bit clearer,…we're gonna edit the reference line…and change the label to be the value.…This way, we can see the value of our reference line…and the value is the average.…The reference line now displays…the value of the average for each of our panes.…This reference line is dynamic.…If we select a subset of our values…the reference line changes to show the average…of those selected values.…Reference lines are a great way for looking for…above average or below average data.…
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
Creating Interactive Dashboards in Tableauwith Nate Makdad1h 38m Intermediate
Data Visualization for Data Analystswith Bill Shander1h 31m Beginner
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.