Tableau Training

This Training program will get you up to speed on concepts of data visualization with a firm understanding of Tableau Architecture. You will be well-versed in the concepts of Filters, Parameters, Graphs, Maps, Table Calculation and Dashboards. You will gain further expertise in data blending, data aggregation and R Connectivity with Tableau.

What you will learn in this Tableau Training Course?

• Understand Tableau Desktop Architecture and how to use Tableau in real life
• Tableau statistics and Tableau interactive dashboard
• Master Tableau Reporting, Graphs, Maps, Table Calculation
• Simplify and organize data with data connections
• Master Special Field Types and Tableau Generated Fields
• Learn to implement Data Aggregation and Data Blending in tableau
• Understand R Connectivity with Tableau
• Gain knowledge on using R scripts in Tableau
• Perform real time analytics and Tableau data visualization
• Prepare for Tableau Desktop Qualified Associate Exam

Course Content

Introduction to Data Visualization and Power of Tableau

What is data visualization, Comparision and benefits against reading raw numbers, Real usage examples from various business domains, Some quick powerful examples using Tableau without going into the technical details of Tableau

Architecture of Tableau

Installation of Tableau Desktop, Architecture of Tableau, Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane etc), How to start with Tableau, Ways to share and exporting the work done in Tableau

Hands-on Exercise – Play with the tableau desktop, interface to learn its user interface, Share an existing work, Export an existing work

Working with Metadata & Data Blending

Connection to Excels, PDFs and Cubes, Managing Metadata and Extracts, Data Preparation and dealing with NULL values, Data Joins (Inner, Left, Right, Outer) and Union, Cross Database joining, Data Blending

Hands-on Exercise – Connect to an excel sheet and import data, Use metadata and extracts, Handle NULL values, Clean up the data before the actual use, Perform various join techniques, Perform data blending from more than one sources

Creation of sets

Marks, Highlighting, Sort and Group, Working with Sets (Creation of sets, Editing sets, IN/OUT, Sets in Hierarchies)

Hands-on Exercise – Create and edit sets using Marks, Highlight desired items, Make groups, Applying sorting on result, Make hierachies in the created set

Working with Filters

Filters (Addition and Removal), Filtering continuous dates, dimensions, measures, Interactive Filters

Hands-on Exercise – Add Filter on data set by date/dimensions/measures, Use interactive filter to views, Remove some filters to see the result

Organizing Data and Visual Analytics

Formatting Data (Labels, Annotations, Tooltips, Edit axes), Formatting Pane (Menu, Settings, Font, Alignment, Copy-Paste), Trend and Reference Lines, Forecasting, k-means Cluster Analysis in Tableau

Hands-on Exercise – Apply labels, annotations, tooltips to graphs, Edit the attributes of axes, Set a reference line, Do k-means cluster analysis on a dataset

Working with Mapping

Coordinate points, Plotting Longitude and Latitude, Editing Unrecognized Locations, Custom Geocoding, Polygon Maps, WMS: Web Mapping Services, Background Image (Add Image, Plot Points on Image, Generate coordinates from Image)

Hands-on Exercise – Plot latitude and longitude on geo map, Edit locations on the map, Create custom geocoding, Use images of a map and plot points on it, find coordinates in the image, Create a polygon map, Use WMS

Working with Calculations & Expressions

Calculation Syntax and Functions in Tableau, Types of Calculations (Table, String, Logic, Date, Number, Aggregate), LOD Expressions (concept and syntax), Aggregation and Replication with LOD Expressions, Nested LOD Expressions

Working with Parameters

Create Parameters, Parameters in Calculations, Using Parameters with Filters, Column Selection Parameters, Chart Selection Parameters

Hands-on Exercise – Create new parameters to apply on a filter, Pass parameters to filters to selet columns, Pass parameters to filters to select charts

Charts and Graphs

Dual Axes Graphs, Histogram (Single and Dual Axes), Box Plot, Pareto Chart, Motion Chart, Funnel Chart, Waterfall Chart, Tree Map, Heat Map, Market Basket analysis

Hands-on Exercise – Plot a histogram, heat map, tree map, funnel chart and others using the same data set, Do market basket analysis on a given dataset

Dashboards and Stories

Build and Format a Dashboard (Size, Views, Objects, Legends and Filters), Best Practices for Creative and Interactive Dashboards using Actions, Create Stories (Intro of Story Points, Creating and Updating Story Points, Adding Visuals in Stories, Annotations with Description)

Hands-on Exercise – Create a dashboard view, Include objects, legends and filters, Make the dashboard interactive, Create and edit a story with visual effects, annotation, description

Integration of Tableau with R and Hadoop

Introduction to R Language, Applications and Use Cases of R, Deploying R on Tableau Platform, Learning R functions in Tableau, Integration with Hadoop

Hands-on Exercise – Deploy R on tableau, Create a line graph using R interface, Connect tableau with Hadoop and extract data