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 LinkedIn – https://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
- 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