Course Outline
Introduction
Setting up Tableau
Overview of Tableau Features and Architecture
Navigating the Tableau User Interface
Connecting to Your Data
Organising, Filtering, Sorting & Grouping
- Organising your data
- Slicing your data by date
- Simplifying and sorting your data
- Advanced options for filtering and hiding
- Understanding the many options for ordering and grouping your data
- Sort, Groups, Bins, Sets
- Interrelation between all options
Working with Data in Tableau
- Using multiple measures in a view
- Showing the relationship between numerical values
- Viewing specific values
- Customising your data
- Dimension vs Measure
- Data types: discrete versus continuous for measures
- Joining database sources
- Inner, outer, left, and right joins
- Blending different data sources in a single worksheet
- Working with extracts instead of live connections
- Data quality issues
- Metadata and sharing a connection
Calculations on Data and Statistics
- Row-level calculations
- Aggregate calculations
- Arithmetic, string, and date calculations
- Custom aggregations and calculated fields
- Control-flow calculations
- What lies behind the scenes
- Advanced statistics
- Working with dates and times
Analysing Data with Table Calculations
- Quick table calculations
- Scope and direction
- Addressing and partitioning
- Advanced table calculations
Advanced Geo Techniques
- Building basic maps
- Geographic fields and map options
- Mapping data geographically
- Customising a geographic view
- Web Map Service (WMS)
- Visualising non-geographical data with background images
- Mapping tips
- Distance calculations
Parameters in Tableau
- Creating parameters
- Parameters in calculated fields
- Parameter control options
- Enhancing analysis and visualisations with parameters
Building Basic and Advanced Visualisations
- Cross tabs
- Geographic maps, heat maps, and tree maps
- Pie charts and bar charts
- Date and time visualisations and Gantt charts
- Stacked bars and area charts
- KPI charts and Pareto charts
- Dual axis and combined charts with different mark types
- Highlight tables
- Scatter plots
- Bar chart variations - bullet charts and bar-in-bar
Advanced Formatting
- Labels
- Legends
- Highlighting data with reference lines
- Annotations
Telling a Data Story with Dashboards
- Dashboard framework
- Filter actions
- Highlight actions
- URL actions
- Cascading filters
Trends and Forecasting
- Understanding and customising trend lines
- Distributions
- Forecasting
Integrating Tableau and R for Advanced Data Analytics
- Option to include different data analytics methods in R upon participants' request
Troubleshooting
Summary and Conclusion
Requirements
- Experience with business intelligence and data visualisation.
Audience
- Data analysts
- Data scientists
Testimonials (3)
The Practice, I created a dashboard is super easy, once time understand the subjects.
Luis Fernando - si
Course - Tableau Fundamentals to Advanced
Hand's on exercise under the control of trainer. All attendees were thus highly encouraged to participate.
Gerard Suissa - Brown-Forman France
Course - Tableau Fundamentals to Advanced
The trainer answered all of my questions and gives us a walkthrough.