Business Analytics using Tableau Training Course

  Lecture-1 Data Visualization and Power of Tableau
Live Lecture 
·      What is data visualization?

·      Comparison and benefits against reading raw numbers

·      Real use cases from various business domains

·      Installing Tableau

·      Tableau interface

·      Connecting to DataSource

·      Tableau data types

·      Data preparation

·      Practical Exercise

  Lecture-2 Tableau Architecture
Live Lecture 
·      Installation of Tableau Desktop

·      Architecture of Tableau

·      Tableau Layout

·      Tableau Toolbars

·      Tableau Data Pane

·      Tableau Analytics Pane

·      How to start with Tableau

·      The ways to share and export the work done in Tableau

·      Practical Exercise

  Lecture-3 Tableau Metadata and Data Blending
Live Lecture 
·      Connection to Excel

·      Cubes and PDFs

·      Management of metadata and extracts

·      Data preparation

·      Joins and Union

·      Dealing with NULL values

·      Cross-database joining

·      Data extraction

·      Data blending

·      Refresh extraction

·      Incremental extraction

·      How to build extract

·      Practical Exercise

  Lecture-4 Creation of Sets and Using Filters
Live Lecture 
·      Mark

·      Highlight

·      Sort

·      Group, and use sets

·      Creating and editing sets

·      IN/OUT

·      Sets in hierarchies

·      Constant sets

·      Computed sets

·      Bins

·      Filters

·      Filtering continuous dates

·      Dimensions, and measures

·      Interactive filters

·      Marks card

·      Hierarchies

·      How to create folders in Tableau

·      Sorting in Tableau

·      Types of sorting

·      Filtering in Tableau

·      Types of filters

·      Filtering the order of operations

·      Practical Exercise

  Lecture-5 Organizing Data and Visual Analytics
Live Lecture 
·      Using Formatting Panel to work with Tableau

·      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

·      Bands

·      Practical Exercise

  Lecture-6 Working with Mapping, Calculations, Expressions and Parameters
Live Lecture 
·      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

·      Calculation syntax and functions in Tableau

·      Various types of calculations,

·      Table, String, and Date

·      Aggregate, Logic, and Number

·      LOD expressions, including concept and syntax

·      Aggregation and replication with LOD expressions

·      Nested LOD expressions

·      Fixed level

·      Lower level

·      Higher level

·      Quick table calculations

·      The creation of calculated fields

·      Predefined calculations

·      How to validate

·      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

·      Practical Exercise

  Lecture-7 Introduction of Charts, Graphs, Dashboards and Stories
Live Lecture 
·      Dual axes graphs

·      Histograms

·      Single and dual axes

·      Box plot

·      Motion Charts

·      Pareto Charts

·      Funnel Charts

·      Pie Charts

·      Bar Charts

·      Line Charts

·      Bubble Charts

·      Bullet Charts

·      Scatter Charts

·      Waterfall charts

·      Tree Maps

·      Heat Maps

·      Market basket analysis (MBA)

·      Using Show me

·      Text table and highlighted table

·      Building and formatting a dashboard 

·     Making creative as well as interactive dashboards 

·      Creating stories, including the intro of story points

·      Creating as well as updating the story points

·      Adding catchy visuals in stories

·      Adding annotations with descriptions; dashboards and stories

·      What is dashboard?

·      Highlight actions, URL actions, and filter actions

·      Selecting and clearing values

·      Best practices to create dashboards

·      Learning about Tableau joins

·      Types of joins

·      Tableau field types

·      Saving as well as publishing data source

·      Live vs extract connection

·      Various file types

·      Practical Exercise

  Lecture-8 Tableau Prep
Live Lecture 
·      Introduction to Tableau Prep

·      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 analysis 

·      Practical Exercise