In this module the candidate will learn about Data Visualization, Comparison benefits against reading raw numbers, Real use cases from various business domains, Examples of using Tableau, installing Tableau, Tableau interface, Connecting to Data source, Tableau data types and Data preparation

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
• Connecting to Data Source
• Tableau data types
• Data preparation

In this module the candidate will learn about Architecture of Tableau, which includes learning of the installation, Desktop Architecture and Interface of Tableau, how to start with Tableau and the ways to share and export the work done in Tableau. The candidate will also be provided with a few Hands-on exercises, which will enhance the understanding of the Tableau

Topics:

• Installation of Tableau
• Desktop Architecture of Tableau
• Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
• How to start with Tableau
• The ways to share and export the work done in Tableau

Hands-on Exercise:

• Play with Tableau desktop
• Learn about the interface
• Share and export existing works

In this module the candidate will learn working with Metadata and Data Blending, which includes understanding Connection to Excel, Cubes and PDFs, Management of the Metadata, preparation of Data, Joins and Unions , and how to deal with NULL Values, Cross- database joining, data extraction etc. The candidate will also be provided with Hands-on Exercises which will enhance the understanding of the candidate, of the topic and its working

Topics:

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

  Hands-on Exercise:

• Connect to Excel sheet to import data
• Use metadata and extracts
• Manage NULL values
• Clean up data before using
• Perform the join techniques
• Execute data blending from multiple sources

In this module the candidate will learn about Creation Sets, in which you will learn how to Mark, Highlight, Sort, Group, and use Sets, understand what are Constant Sets, Computed Sets, Bins etc. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned

Topics:

• Mark, highlight, sort, group, and use sets (creating and editing sets, IN/OUT, sets in hierarchies)
• Constant sets
• Computed sets, bins, etc.

  Hands-on Exercise:

• Use marks to create and edit sets
• Highlight the desired items
• Make groups
• Apply sorting on results
• Make hierarchies among the created sets

In this module the candidate will learn about Filters, how to work with Filters, Filtering Continuous Dates, Dimensions and Measures, create folders in Tableau, sorting in Tableau, Filtering in Tableau and the order of Operations, types of Sorting and Filters. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned

Topics:

• Filters (Addition and removal)
• Filtering continuous dates, dimensions, and measures
• Interactive Filters, marks card, and hierarchies
• How to create folders in Tableau
• Sorting in Tableau
• Types of sorting
• Filtering in Tableau
• Types of filters
• Filtering the order of operations

  Hands-on Exercise:

• Use the data set by date/dimensions/measures to add a filter
• Use interactive filter to view the data
• Customize/remove filters to view the result

In this module the candidate will learn about Visual Analytics and Organizing Data, in which the candidate will learn about usage of Formatting Pane and how to Format Data using Labels and Tooltips, Edit Axes and annotations, K-means cluster analysis, Trend and Reference lines, Visual Analytics and Forecasting, Confidence Interval, Reference lines and Bands. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working

Topics:

• Using Formatting Pane to work with menu, fonts, alignments, settings, and copy-paste
• Formatting data using labels and tooltips
• Edit axes and annotations
• K-means cluster analysis
• Trend and reference lines
• Visual analytics in Tableau
• Forecasting, confidence interval, reference lines, and bands

  Hands-on Exercise:

• Apply labels and tooltips to graphs, annotations, edit axes’ attributes
• Set the reference line
• Perform k-means cluster analysis on the given dataset

In this module the candidate will learn about Mapping Preview, which includes Working on Coordinate points and the background image, Plotting Longitude and Latitude, editing unrecognized Location, Customizing Geocoding, Maps etc., Map visualization, Custom territories, Map box WMS map and creating Map projects in Tableau and Dual Axes Maps. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working

Topics:

• 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, map box, WMS map
• How to create map projects in Tableau
• Creating dual axes maps and editing locations

  Hands-on Exercise:

• Plot longitude and latitude on a geo map
• Edit locations on the geo map
• Custom geocoding
• Use images of the map and plot points
• Find coordinates
• Create a polygon map
• Use WMS

In this module the candidate will learn about Calculations and functions in Tableau, LOD expressions, aggregation and Replication with LOD expressions, Nested LOD expressions, Levels of details, Quick table calculations, Creation of calculated fields and Predefined calculations and validation

• Calculation syntax and functions in Tableau
• Various types of calculations, including Table, String, Date, Aggregate, Logic, and Number
• LOD expressions, including concept and syntax
• Aggregation and replication with LOD expressions
• Nested LOD expressions
• Levels of details: fixed level, lower level, and higher level
• Quick table calculations
• The creation of calculated fields
• Predefined calculations
• How to validate

In this module the candidate will learn about Parameters, creating and its calculations, using Parameters with calculations Column and chart selection parameters, usage of Parameters in filter sessions, calculated fields and in reference line. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working

Topics:

• 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 calculated fields
• How to use parameters in the reference line

  Hands-on Exercise:

• Creating new parameters to apply on a filter
• Passing parameters to filters to select columns
• Passing parameters to filters to select charts

In this topic the candidate will learn about Charts and Graphs, such as, Dual axes graphs, Histograms, Single and dual axes, Box plot, Charts; motion, pie , bar etc., Maps: tree and heat maps, Market Based Analysis and text and highlighted table. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working

Topics:

• Dual axes graphs
• Histograms
• Single and dual axes
• Box plot
• Charts: motion, Pareto, funnel, pie, bar, line, bubble, bullet, scatter, and waterfall charts
• Maps: tree and heat maps
• Market basket analysis (MBA)
• Using Show me
• Text table and highlighted table

  Hands-on Exercise:

• Plot a histogram, tree map, heat map, funnel chart, and more using the given dataset
• Perform market basket analysis (MBA) on the same dataset

In this module the candidate will learn about Dashboard, which includes topics such as, building and formatting, best practices for making creative dashboard, creating stories, updating the story points, Adding annotations with descriptions, Highlight actions, URL actions, types of Joins, Tableau field types, Saving as well as publishing data source, difference between Live and Extract connection and various file types. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working.

11.1 Building and formatting a dashboard using size, objects, views, filters, and legends

11.2 Best practices for making creative as well as interactive dashboards using the actions

11.3 Creating stories, including the intro of story points

11.4 Creating as well as updating the story points

11.5 Adding catchy visuals in stories

11.6 Adding annotations with descriptions; dashboards and stories

11.7 What is a dashboard?

11.8 Highlight actions, URL actions, and filter actions

11.9 Selecting and clearing values

11.10 Best practices to create dashboards

11.11 Dashboard examples; using Tableau workspace and Tableau interface

11.12 Learning about Tableau joins

11.13 Types of joins

11.14 Tableau field types

11.15 Saving as well as publishing data source

11.16 Live vs extract connection

11.17 Various file types

Hands-on Exercise

1. Create a Tableau dashboard view, include legends, objects, and filters

2. Make the dashboard interactive

3. Use visual effects, annotations, and descriptions to create and edit a story

In this module the candidate will learn about Tableau prep, how Tableau prep helps combine join, sharp, and clean data for analysis, creation of smart examples with Tableau prep, and how data preparation is made simple and accessible, integrating Tableau prep with Tableau analytical workflow and a clear understanding the seamless process from data preparation to analysis with 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
• Understanding the seamless process from data preparation to analysis with Tableau Prep

In this module the candidate will learn about Tableau with R and Hadoop, which includes Application and use cases of R, Deploying R on the Tableau platform, R functions in Tableau and The integration of Tableau with Hadoop. The candidate will also be provided with Hands-on Exercises which will enhance the knowledge of the topics learned and its working

Topics:

• Introduction to R language
• Applications and use cases of R
• Deploying R on the Tableau platform
• Learning R functions in Tableau
• The integration of Tableau with Hadoop

  Hands-on Exercise:

• Deploy R on Tableau
• Create a line graph using R interface
• Connect Tableau with Hadoop to extract data

Soft Skills Training

Resume Writing

- HR: Analyze the Attrition rate of Employees

- Sales: Predicting Department wise Sales

- Multi-Domain: Business Analytics Optimization

- Marketing: Website Trend Analysis

- Financial Analysis: Stock Market Prediction

- Finance: Analyze ETF Trends