Course Content :
Introduction to Data Visualization and Power of Tableau
What is data visualization.
Comparison 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
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
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 hierarchies 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.