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
- 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.