Skip to main content

Module 5: Analysis

Data Analysis and Exploration

Objective:​

  • Teach participants how to apply statistical functions and calculations in Tableau
  • Guide participants in building and interpreting data visualizations for exploratory analysis
  • Help participants utilize Tableau's data blending and data modeling capabilities
  • Provide hands-on experience in implementing forecasting and trend analysis

5.1 Statistical Functions and Calculations​

  • Overview of statistical functions available in Tableau
  • Performing aggregations, averages, and percentiles
  • Applying statistical calculations to derive insights from data

Exercise 5.1: Applying Statistical Functions​

  • Participants are given a dataset suitable for statistical analysis.
  • Participants use Tableau to apply various statistical functions and calculations to gain insights from the data.

5.2 Building Exploratory Data Visualizations​

  • Using Tableau's visual analytics features for exploratory analysis
  • Creating dynamic visualizations with filters and parameters
  • Identifying patterns, trends, and outliers in data

Exercise 5.2: Exploratory Data Visualization​

  • Participants explore a given dataset using Tableau's visual analytics capabilities.
  • Participants build multiple visualizations to analyze data patterns, trends, and outliers.

5.3 Data Blending and Modeling​

  • Introduction to data blending and data modeling in Tableau
  • Combining data from multiple sources for comprehensive analysis
  • Implementing data hierarchies, data groups, and calculated fields

Exercise 5.3: Data Blending and Modeling​

  • Participants are provided with multiple datasets that need to be blended and modeled in Tableau.
  • Participants use Tableau's data blending and modeling techniques to combine and structure the data for analysis.

5.4 Forecasting and Trend Analysis​

  • Utilizing Tableau's forecasting capabilities
  • Identifying and visualizing trends in time-series data
  • Implementing trend lines and trend analysis techniques

Exercise 5.4: Forecasting and Trend Analysis​

  • Participants are given a time-series dataset.
  • Participants use Tableau to create visualizations that showcase trends and apply forecasting techniques.

5.5 Data Drill-Down and Hierarchical Analysis​

  • Performing data drill-down and drill-up operations in Tableau
  • Creating hierarchical visualizations for deeper analysis
  • Exploring data at different levels of detail

Exercise 5.5: Data Drill-Down and Hierarchical Analysis​

  • Participants practice data drill-down and hierarchical analysis using a provided dataset.
  • Participants create visualizations that enable users to explore data at different levels of detail.