Tableau

8 Weeks
On Request
Topics Covered

Module 1: Introduction to Data Visualization and The Power of Tableau

  • What is data visualization?
  • Comparison and benefits against reading raw numbers.
  • Real use cases from various business domains.
  • Some quick and powerful examples using Tableau without going into the technical details of Tableau
  • Installing Tableau.
  • Tableau interface.

Module 2: Architecture of Tableau 

  • Architecture of Tableau
  • Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
  • Tableau field types
  • Saving and publishing a data source
  • Live vs extract connection
  • Various file types
  • The ways to share and export the work done in Tableau

Module 3: Charts and Graphs 

  • Basic Charts.
  • Dual axes graphs.

Module 4: Working with Meta data and Data Blending 

  • Connecting to Data Source
  • Tableau data types
  • Connection to Excel
  • Cubes and PDFs
  • Management of metadata and extracts
  • Data preparation
  • Joins (Left, Right, Inner, and Outer) and Union
  • Dealing with NULL values
  • Cross database joining, data extraction, data 
  • Blending, refresh extraction, incremental
  • Extraction, how to build extract, etc.
  • Advanced joins

Module 5: Advanced Data Manipulations 

  • Mark and highlight
  • Groups
  • Sets (creating and editing sets, IN/OUT)
  • Bins
  • Hierarchies
  • Folders
  • Sorting and Types
  • Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
  • Editing axes and annotations

Module 6: Working with Filters 

  • Filters (addition and removal)
  • Filtering continuous dates, dimensions, and measures
  • Filtering in Tableau
  • Types of filters
  • Filtering the order of operations

Module 7: Organizing Data and Visual Analytics 

  • K-means cluster analysis
    Trend and reference lines
    Visual analytics in Tableau
    Forecasting, confidence interval, reference lines, and bands

Module 8: Working with Mappings 

  • Working on coordinate points
  • Plotting longitude and latitude
  • Editing unrecognized locations
  • Customizing geocoding, polygon maps, WMS: web mapping services
  • Working on the background image, including add image
  • Plotting points on images and generating coordinates from them
  • Map visualization, custom territories
  • How to create map projects in Tableau
  • Creating dual axes maps, and editing locations

Module 9: Working with Calculations and Expressions 

  • Calculation syntax and functions in Tableau
  • Various types of calculations, including Table, String, Date, Aggregate, Logic, and Number
  • Levels of details: fixed level, lower level, and higher level
  • Quick table calculations
  • The creation of calculated fields
  • Quick LODs

Module 10: Working with Parameters 

  • Creating parameters
    Parameters in calculations
    Using parameters with filters
    Column selection parameters
    Chart selection parameters
    How to use parameters in the filter session
    How to use parameters in the reference line

Module 11: Dashboards and Stories 

  • What is a dashboard?
  • Building and formatting a dashboard using size, objects, views, filters, and legends
  • Best practices for making creative as well as interactive dashboards using the actions
  • Creating stories
  • Adding annotations with descriptions; dashboards and stories
  • Highlight actions, URL actions, and filter actions
  • Selecting and clearing values
  • Dashboard examples using Tableau workspace and Tableau interface

Module 12: Tableau Prep 

  • Introduction to Tableau Prep
  • How Tableau Prep helps quickly combine join, shape, and clean data for analysis
  • Creation of smart examples with Tableau Prep
  • Getting deeper insights into the data with great visual experience
  • Making data preparation simpler and accessible
  • Integrating Tableau Prep with Tableau analytical workflow

 


Project

  1. Capstone Project
    • Capstone Project 1 on Super store Data
    • Capstone Project 2 on Financial Data


Features

    Figma Master Class
    • What is Figma?
    • How to make best use of it ?
  1. SQL Master Class
  2. Tableau Public Profile, LinkedIn and Resume makeover
    1. How to build Tableau public profile?
    2. How to participate in Community Projects?
    3. How to stand out with LinkedIn Profile?
    4. Resume Makeover is must!!