Tableau Desktop & Tableau Online Server Essentials – By Akriti Lal

The Total 24 Hrs Tableau Course Content to take you from Basic to Intermediate to Advance Tableau User . The course is covered in 8 Sessions of 3 Hrs each Or 3 Days of 8 Hrs Each .

For any further details ping me on LinkedInhttps://www.linkedin.com/in/akritipurbey/

Course Content

Day-1 – ( First 8 Hrs ) :

Tableau Introduction

  • Tableau Introduction.
  • Overview of Tableau workbook, worksheets.
  • Dimension & Measures
  • Discrete And Continuous

Install Tableau Desktop & Download & Connect To Database

  • How to Connect Tableau Desktop to Various Files.
  • Create Data Extracts
  • Live Connection
  • Use of Mark/Size/Colour/Transparency/Label
  • Tool Tip/ Detail / View Highlight

Different Data Mapping In Tableau

  • Relationship
  • Joins
  • Blends
  • Cross Data Base Joins
  • Union

 

Different Chart Types (using Show me & without using Show me)

  • Area Maps
  • Scatter Plot
  • Heat Maps
  • Bar Charts (Grouped Bar, Inverted Bar, Bar with rounded end)
  • Line Charts
  • Histograms
  • Box And Whisker
  • Pie Chart
  • Maps (Symbol Map, Filled Map, Dual Axis Map)
  • Dual Axis Charts
  • Waterfall Chart
  • Donut Chart
  • Bullet Graph, Bullet Highlighted Graph
  • Viz in tooltip

Formatting

  • Format Visualization
  • Size, Shapes, Details, Tooltips
  • Labels , Annotations, Folders
  • Titles, Captions
  • Legends ,Highlight
  • Handle Null Values

Dashboard Hands On

  • Calendar Dashboard

 

Day-2: ( Second 8 Hrs )

Data Organising

  • Create Sets
  • Create Bins
  • Create Groups
  • Using Sets and Group to Increase the Efficiency of Work.
  • Filters & Types of Filter
  • Drilling , Alias
  • Sorting ,Computed Sort, Axis Sort
  • Hierarchies

Calculated Fields

  • Calculated Fields
  • String / Date / Logical Functions
  • Calculated Column using single Formula.
  • Aggregation / Dis-Aggregation
  • Handel Null Value

Table Calculations

  • Using Table Calculations
  • Difference Between Calculated Field and Table Calculations
  • Computation Direction For Table Calculation.

Reference Lines, Bands, Distributions And Boxes

  • Types Of Reference Lines, Bands, Distributions and Boxes
  • Adding Of Reference Lines, Bands, Distributions and Boxes
  • Editing/ Removing Of Reference Lines, Bands, Distributions and Boxes

Forecasting

  • Forecasting Constraints
  • How Forecasting Works In Tableau
  • Create A Forecast.
  • Forecast using Business Growth & Churn Rate
  • Forecast using R

 

 

 

Parameters

  • Creating Parameters
  • Editing Parameters
  • Using Parameters In Filters, Calculations And Reference Lines
  • Parameter Controls

 

Analytics with R

  • Tableau with R Integration
  • Using “R” scripts in Tableau

 

Dashboard Hands On

  • Linking Dashboards
  • Url Dashboard
  • Min/Max Sales Analysis Dashboard

 

Day-3: ( Third 8 Hrs )

Level Of Detail Expressions

  • Table Scoped LOD
  • FIXED LOD
  • Include/ Exclude LOD.
  • LOD and Aggregations
  • Proportional brushing
  • Market basket Analysis
  • Comparative Analysis
  • Sales Analysis for Last N days

Sharing Your Visualization

  • Tableau Public Concepts
  • Basic Tableau Server Concepts
  • Workbook, Packaged Workbook
  • Export
  • Print
  • Publish as PDF

 

Interactive Dashboard Concepts

  • Dashboard Components Revisit
  • Tiled & Floating Layout
  • Filter , Highlight & URL Actions

Dashboard Formatting

 

 

Dashboard Hands On

  • Administrative Dashboard

 

Work with Tableau Server / Online:

  • Understanding Tableau Server
  • Sites
  • Projects
  • Groups
  • Roles
  • Users
  • Permissions
  • Overview of Extracts, Tasks, Schedules, Subscriptions
  • Performance Recorder/ Performance tunning