Description
In this course, you will :
- Learn how to deal with illegible or badly formatted data, how to use Tableau to answer key data analytics questions, and how to visualise your findings with maps and dashboards.
- demonstrate how to use parameters to enhance visualisations, how to create cross-source filters, how to use data extracts to optimise slow connections, and much more.
- Discover how actions can connect sheets and increase interactivity and performance, as well as how formatting can make an ordinary dashboard stand out.
- Get some extra help with date and time calculations in Tableau.
- This course delves deeply into the practical, applicable, and essential skills required of anyone working in data visualisation and analytics in a professional setting.
Syllabus :
1. Green and Blue Pills
- Discrete versus continuous
- Rows and columns
- Filters
- Colors
- Dates
2. Connect and Extract Data
- Connect to data
- How to create a data extract
- Filter extract
3. Transform Data
- Clean and prep your data
- Split fields
- Pivoting the data
- Merge data using unions
- Cross database joins
- Join transformations
4. Analytics
- Colors to highlight data
- Visual highlighter
- The Analytics pane
- Cross-database filtering
5. Map Your Data
- When to map your data
- Create new maps using MapBox
- Create custom territories
6. Parameters
- Create calculations based on a parameter
- Create dynamic reference lines
- Dynamic dimension and measure selector
- Dynamic sheet selection using parameters
- Top N analysis
7. Dashboard Design
- Dashboard layout tips
- Layout containers
- Filter actions
- Highlight actions
- URL actions
- Formats
- Tooltips
- Device-specific dashboards
8. Useful Calculations
- Convert strings to dates
- Calculate time durations
- Create an initial filter from a surname
9. Tableau 10.2 Updates
- Incorporate custom geospatial data into your viz
- Convert string to dates with automatic dateparse
- Create custom joins through calculations
- Export transformed data to CSV
- Display different color legends per measure