Tableau certification training program helps you learn Tableau and gets you up to work on the concepts of data visualization with a firm understanding of the Tableau architecture. You will become proficient in the concepts of filters, parameters, maps, graphs, dashboards, and table calculation. Furthermore, you will learn about data blending, data aggregation, and R connectivity with Tableau in this course. This course covers Tableau Creator functionality required for new Tableau users. It starts with simple visualisations and moves to an in-depth look at the different chart and graph functions, calculations, mapping and other functionality. The lessons are organised into modules that provide conceptual information, how-to steps, follow me (where the students follow the instructor using Tableau) and tutorials on each subject.

Course content

SQL

Introduction to Oracle Database (SQL):

• What is Database
• Why Oracle
• Introduction to SQL and SQL *Plus, More SQL*Plus Commands
• The Data Dictionary

Data Query Language (DQL):

• Categories of SQL Statements
• Oracle Data types
• The SELECT Statement
• Practical examples

Data Definition Language (DDL):

• DDL Statements
  The CREATE Statement
• The DROP Command
• The ALTER Command
• Practical examples

Data Manipulation Language (DML):                                       

• DML Statements,
• The INSERT Statement
• The DELETE Statement
• The UPDATE Statement

Transaction Control Language (TCL):

• TCL Statements
• COMMIT Statement
• ROLLBACK Statement
• SAVEPOINT Statement

Data Control Language (DCL):

• DCL Statements
• GRANT Statement
• REVOKE Statement

Integrity Constraints:

• Introduction to Integrity Constraints
• Categories of Integrity Constraints
• NOT NULL Constraints
• UNIQUE KEY Constraints
• PRIMARY KEY Constraints
• FOREIGN KEY or Referential Integrity Constraints
• CHECK Constraints, Practical examples

SQL Operators:

• Simple Selects
• Comparison Operators
• IN and NOT IN Operators
• BETWEEN Operator
• The LIKE Operator
• Logical Operators
• IS NULL and IS NOT NULL
• ANY
• ALL
• EXISTS

Set Operators:

• Introduction
• Selection Criteria
• Union
• Union All
• Intersect
• Minus

Joining Tables:

• Joins
• Table Aliases
• Cartesian Product
• Inner Joins
• Equi- Join
• Non-Equi Join
• Non-Key Join
• Reflexive / Self Join
• Natural Join
• Outer Joins
• Right Outer Join
• Left Outer Join
• Full Outer Join

SQL Sub queries:

• Introduction
• Using a Sub query with a DML Statement
• Typical Sub queries
• Sub query Operators
• Standard vs. Correlated Sub queries
• Correlated Sub query

Groups:

• SQL Statements
• GROUP BY Clause
• HAVING Clause
• Order of a SELECT Statement

SQL BUILT-IN FUNCTIONS:

• Introduction, Pseudo Columns
• GROUP Functions
• MATHEMATICAL / NUMERIC Functions
• STRING / CHARACTER Functions
• DATE / TIME Functions
• CONVERSION Functions
• MISCELLANEOUS Functions

More Database Objects:

• More Database Objects
• VIEWS
• SEQUENCE
• SYNONYMS

Tableau

Chapter – I: The Tableau Environment The

Tableau Workspace

• Data Window
• Toolbar, Status Bar
• Tooltips, Cards and Shelves
• Reorganizing the Workspace
• Workbooks and Sheets
• Changing the Repository Location

Chapter – II: Connect to Data

2. Connect to Data

• How to Connect to a Data Source
• Connect Live/Import
• Editing a Connection
• Replace Data Source
• Replacing Field References
• Renaming the Connection
• Duplicating the Connection
• Refreshing the Data
• Closing the Connection
• Clipboard Data Sources
• Number of Records
• Latitude and Longitude,
• Measure Names

Data Types and Roles 

• Data Types
• Data Roles

Joining Tables

• Adding Tables
• Editing Tables
• Custom SQL

Working with Multiple Connections

• Understanding Data Blending
• Adding a Secondary Connection
• Defining/Edit Relationships

Data Window Features and Functions

• Folders
• Sort
• Find Fields
• Rename Fields
• Combine Fields
• Hide or Unhide Fields
• Add Fields to the Data Window (calculation field)

Editing Field Properties 

• Comments
• Aliases
• Hierarchies
• Colors
• Shapes
• Formats
• Sort & bull; Aggregation
• Grouping
• Sets
• Aggregation & Disaggregation

Chapter – III: Building Data Views

Parts of the View 

• Table Components
• Headers, Axes
• Panes, Cells, Marks Card
• Using Stepped Color
• Mark Borders
• Titles
• Captions
• Field Labels
• Legends

Building Views Manually

• Dragging Fields
• Shelves and Cards
• Multidimensional Hierarchies
• Example – Building Data Views Manually

Building Views Automatically 

• Show Me
• Add to Sheet: Double-Click

All Views – 24 Types

Filtering 

• Adding Filters
• Sharing Filters
• Context Filters

Actions 

• Filter Actions
• Highlight Actions
• URL Actions
• Running Actions
• Actions and Dashboards
• Using Field and Filter Values in Actions

Chapter – IV: Advanced Analysis

Calculations 

• Aggregations
• Calculated Fields (Create, copy-paste, Formula,)
• If/then, case calculations
• Table Calculations
• Binned Data
• Totals
• Percentages

Parameters

• Creating Parameters
• Editing Parameters
• Using Parameters in Calculations
• Using Parameters in Filters
• Using Parameters in Reference Lines
• Parameter Controls

Using Multiple Measures 

• Individual Axes
• Blended Axes
• Dual Axes
• Combination Charts

Forecasting

• Forecasting Constraints
• How Forecasting Works in Tableau
• To Create a Forecast
• Forecast Field Results
• Configure Forecast Options
• Forecast Descriptions
• Troubleshooting Forecasting
• Resolving Forecasting Errors

Trend Lines and Statistics

• Adding Trend Lines
• Removing Trend Lines
• The Trend Line Model
• Removing Factors from the Model
• Assessing Trend Line Significance
• Assumptions
• Trend Line Model Terms

Background Images

• Adding Background Images
• Setting up the View
• Managing Background Images

Background Map

• Geographic Roles
• Building a Map View
• Map Options
• Setting a Default Location
• Editing Locations
• Custom Geo-coding
• Background Map Source
• Map Storing and Working Offline

Chapter – V: Publish and Share

 Formatting

• Worksheet Level Formatting
• Formatting Specific Parts of the View
• Copying and Pasting Formatting
• Clearing Formatting
• Workbook Themes
• Resizing the Table
• Editing Axes
• Annotations and Mark Labels

Dashboards

• Creating Dashboards
• Organizing Dashboards
• Understanding Dashboards and Worksheets

Saving and Exporting 

• Saving Your Work
• Reverting Workbooks
• Exporting Your Work
• Exporting the Data Source Connection
• Copying Information between Workbooks

Tableau Server Comprehensive 

• Create the First Admin User& users
• Create Projects and Groups
• Assign Permissions to Projects
• Publishing Workbooks
• Publishing Data Sources
• Setting Permissions
• Opening Workbooks from the Server
• Importing Data Sources from the Server
• User Filtering

To see the full course content Download now