# Tableau Desktop & Server Essentials – 24hrs. / 3days Course Content

Course Content

Day-1:

Tableau Introduction

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

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

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

• Url Dashboard
• Min/Max Sales Analysis Dashboard

Day-3:

Level Of Detail Expressions

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

• 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

Work with Tableau Server / Online:

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

Tableau Desktop Course by Akriti Lal – https://in.linkedin.com/in/akritipurbey