Take your Tableau skills to the next level. Learn how to format and filter messy data, use Tableau for data analysis, and visualize data with maps and dashboards.
Overview
Syllabus
Introduction
- The power of Tableau for data scientists
- What you should know
- Understand the difference between green and blue fields
- How do green and blue fields affect rows and columns?
- How do green and blue fields affect colors?
- How do green and blue fields affect filters?
- How do green and blue fields affect dates?
- Challenge: Green and blue
- Solution: Green and blue
- How to connect to Excel sheets
- How to clean Excel data with the data interpreter
- How to connect to PDF files and extract tables of data
- How to connect to a local database
- Challenge: Connecting to data
- Solution: Connecting to data
- Combining data using relationships
- What are the different ways of joining data?
- How to join tables in the same data connection
- How to join tables using a cross-database join
- How to append one data source to another using unions
- Challenge: Combining data
- Solution: Combining data
- What are the pros and cons of using a data extract?
- How to create a data extract
- How to limit the data in a data extract
- How to edit a data extract to include more data
- Challenge: Working with extracts
- Solution: Working with extracts
- What are measure names and measure values?
- Creating a combined axis chart
- Creating a dual axis chart
- Creating a bar in bar chart
- Creating a multiple measure crosstab
- Enhance a crosstab using colors to create a highlight table
- Comparing two measures using a scatter plot
- Enhance scatter plots using trend lines and animation
- Challenge: Comparing measures
- Solution: Comparing measures
- How do calculations work in Tableau?
- Using calculations in a join
- How do table calculations work?
- Direction in table calculations
- What are level of detail (LOD) calculations?
- Calculate time durations
- Using IF calculations
- Challenge: Calculations
- Solution: Calculations
- Just because you can, should you create a map?
- How to create an area map
- How to create a symbol map
- Customizing the look of your maps
- Create locations from coordinates
- Create lines to connect locations on a map
- Analyzing distances using buffer calculations
- Challenge: Mapping
- Solution: Mapping
- Using colors to highlight data
- How to create reference lines
- How to create reference bands
- How to use motion to show changes over time
- Challenge: Analytics
- Solution: Analytics
- How are parameters different from filters?
- How to use parameters in calculations
- Create dynamic reference lines using parameters
- Use a parameter to select dimensions and measures
- Use a parameter to search free text fields
- Top N analysis
- Challenge: Parameters
- Solution: Parameters
- How to use containers in a dashboard
- How to create a tiled dashboard
- How to create a floating dashboard
- How to create device-specific dashboards
- How to use filter actions
- How to use highlight actions
- How to use URL actions
- How to use set actions
- Challenge: Dashboards
- Solution: Dashboards
- How can I grow my data science and Tableau skills?
Taught by
Matt Francis
