TECHGENX

Leading to the Future Digital World

Apply Online
Download:Course Content

Tableau Basics + Advance

 

Please Note: All below course content will be covered in practical scenarios and regular assignments will be shared. All sessions will be recorded and shared with student for future reference (free of cost). Along with below course.

Tableau Basics

Welcome! What is Tableau & Course Overview

Installtation

Bar Chart

  1. The Business Challenge: Who gets the Annual Bonus?
  2. Connecting Tableau to a Data file – CSV File
  3. Navigating Tableau
  4. Creating Calculated fields
  5. Adding colors
  6. Adding labels and formatting
  7. Exploring Worksheet

Time Series , Aggregation and Filters

  1. Introduction
  2. Working with data extracts in Tableau
  3. Working with Time series
  4. Understanding aggregation, Granularity, Level of Detail
  5. Creating an area Chart and Learning about highlighting
  6. Adding a filter and Quick Filter
  7. TimeSeries, Aggregation and Filters

Maps , Scatterplots and Dashboard

  1. Introduction
  2. Joining data in Tableau
  3. Creating a Map, Working with Hierarchies
  4. Creating a scatter plot, applying filters to multiple worksheets
  5. Dashboard
  6. Adding an interactive action –Filter
  7. Adding an interactive action –Highlighting

Joining and Blending data, Plus: Dual Axis Chart

  1. Introduction
  2. Inner/Outer/Left/Right Join
  3. Join with Duplicate values
  4. Joining on Multiple fields
  5. Joining data vs Blending data in Tableau
  6. Data binding in Tableau
  7. Dual Axis Chart
  8. Calculated fields in a Blend

Table calculations, Advanced Dashboards and Story-Telling

  1. Introduction
  2. Download dataset and connecting with Tableau
  3. Mapping geographical rules
  4. Creating table calculation for gender
  5. Creating bins and distribution for age
  6. Leveraging the power of Parameters
  7. Tree Map chart
  8. Customer Segmentation Dashboard
  9. Advanced Dashboard Interactivity
  10. Analyzing the Customer Segmentation Dashboard
  11. Creating a storyline

Advance Data Parameters

  1. Introduction
  2. Data Format
  3. Data Interpreter
  4. Pivot
  5. Splitting columns
  6. MetaData Grid
  7. Geographical errors in Tableau
  8. Advance Data Integration

Clusters, Custom Territories, Design Features

  1. Introduction
  2. Startup Expansion Analytics
  3. Custom Territories vs Groups
  4. Custom Territories vs Geographical Roles
  5. Adding Highlighter
  6. Clustering in Tableau
  7. Cross Database Joins
  8. Modeling with Clusters
  9. Saving your clusters
  10. New Design features
  11. New Mobile Features

Advance Tableau

Group and Sets

  1. Introduction
  2. Project Briefs:1000 startups
  3. Working with Groups
  4. Creating Static Set
  5. Creating Dynamic Set
  6. Combining Sets
  7. Controlling sets with Parameters
  8. Dashboard: the start up Quadrant
  9. Dashboard tricks

Tableau Calculations

  1. Project Brief: Coal Terminal Utilization Analysis
  2. Creating Multiple Joins in Tableau
  3. Calculated fields vs Table Calculations
  4. Creating Advanced Table Calculations
  5. Saving a Quick Table Calculations
  6. Adding a second layer moving average
  7. Quality Assurance for Table Calculations
  8. Trendlines for Power-Insights
  9. Creating a Storyline
  10. Report Ready

Advanced data prep- Analytics in Tableau

  1. Introduction
  2. Project Brief: Retail Sector Forecasts
  3. Building box plots in Tableau
  4. Analyzing Box plots
  5. Working with large data source
  6. Pivot and Split
  7. Real world data
  8. Primary Use case for Data Source Filters
  9. Trendlines
  10. Data Prep
  11. Advanced TimeSeries Blending
  12. Calculating Sales per Capita
  13. Forecasting in Tableau
  14. How to present a Storyline

Creating Animation in Tableau

  1. Introduction
  2. Project Brief: World Health Trends
  3. Editing Blending Relationships
  4. Building the visualization
  5. Adding Animation
  6. Manually sorting blended data
  7. Leaving a trail in animations
  8. Finalizing dashboard

LOD(Level of Detail Calculations)

  1. Introduction
  2. Project Brief: Regional Profile Analysis
  3. Preparing the Workbook
  4. Aggregation and Granularity
  5. LOD calculation Intuition
  6. LOD Type
  7. Multiple fields in LOD
  8. Finalizing the Visualization

Advanced Mapping Technique

  1. Getting into shape with Polygons
  2. Background maps
  3. Solving business logic
  4. Drawing tool for tableau
  5. Custom images on maps
  6. Distance calculations
  7. Customizing maps with mapbox
apply now

Students Testimonials

  • Seeing the demand of Python in programming, I decided to enroll for weekend classes of Python then after joining, Ankit sir took our class and from the beginning we attended all the classes..

    gaurav saini

  • Ankit sir is one of the best mentors I have ever had and he's supportive also . He's is the professional in every branch he know and....

    Anshul

  • Ankit sir is the best trainer and have best knowledge in coding he is the best teacher and also supports the idea help to develop them

    rishabh jain
Read More.....