Skip to main content

Module 9: Advanced Topics

Objective:

  • Introduce participants to advanced topics and features in Tableau
  • Explore specialized techniques for specific data analysis scenarios
  • Provide hands-on experience with advanced calculations and customizations
  • Encourage participants to explore and experiment with advanced functionalities

9.1 Advanced Calculations and Expressions

  • Working with advanced calculations using Tableau's calculation language
  • Utilizing advanced functions and operators for complex data manipulations
  • Exploring level of detail (LOD) expressions for advanced aggregations

Exercise 9.1: Implementing Advanced Calculations

  • Participants are given a dataset and a set of specific analysis requirements.
  • Participants use Tableau's advanced calculation features and LOD expressions to create calculated fields and perform complex data manipulations.

9.2 Advanced Visualizations

  • Creating advanced visualizations such as treemaps, heat maps, and scatter plots
  • Customizing visualizations using dual axes, reference lines, and bands
  • Exploring advanced chart types and their applications

Exercise 9.2: Building Advanced Visualizations

  • Participants are provided with a dataset and asked to create specific advanced visualizations using Tableau.
  • Participants experiment with different chart types, customizations, and techniques to create visually compelling and informative visualizations.

9.3 Mapping and Spatial Analysis

  • Utilizing Tableau's mapping capabilities for spatial analysis
  • Working with geospatial data and creating map-based visualizations
  • Implementing advanced mapping features such as polygons, background images, and custom territories

Exercise 9.3: Performing Spatial Analysis and Mapping

  • Participants work with a dataset that includes geospatial information
  • Participants use Tableau's mapping features to perform spatial analysis, create map-based visualizations, and implement advanced mapping techniques.

9.4 Advanced Data Blending and Data Preparation

  • Applying advanced data blending techniques for complex data integration
  • Working with data reshaping and pivoting
  • Exploring data preparation and cleansing using Tableau Prep

Exercise 9.4: Advanced Data Blending and Preparation

  • Participants are given multiple datasets with complex data integration requirements.
  • Participants use Tableau's advanced data blending techniques and Tableau Prep to integrate, reshape, and cleanse the data for analysis.

9.5 Advanced Dashboard Interactivity

  • Enhancing interactivity in dashboards using actions and parameters
  • Implementing advanced filtering techniques and dynamic dashboard elements
  • Creating interactive dashboards for drill-down and storytelling

Exercise 9.5: Designing Interactive Dashboards

  • Participants enhance their previously created dashboard with advanced interactivity features.
  • Participants implement actions, parameters, dynamic elements, and drill-down functionality to create an engaging and interactive dashboard.