Tableau Desktop , Tableau Server , Prep
What is this course about?
This Tableau course focuses on creating a strong and enhanced understanding of the world of Data Analytics using one of the most powerful analytics tool Tableau. The course is structured in such a way that the candidate will be quickly able to comprehend the working of Tableau. Tableau is used to analyse data and represent the same in the form of charts to arrive at a conclusion.
There are numerous kinds of charts within the tableau that help elaborate data thus making it easier for the end user to read the data in an understandable form. Each chart in Tableau is built for specific scenario and to arrive at different conclusion based on the data and analysis requirement. At our institute you will be working with sample data and later implementing the understanding of a session on real-time samples which will ensure end to end understanding of the tool and its capabilities.
Tableau Course Content Tableau Introduction
Why Tableau
History of Tableau Characteristics of Tableau Tableau versions.
Differences between different versions of tableau. Tableau Architecture and components.
Tableau Components
What is Tableau Desktop, Server What is Tableau Reader
What is Tableau Online
What is Tableau Public?
Tableau Extensions
Types of Extensions
When to use Tableau Extensions
Differences between. Twb and .Twbx extensions
Data Connection in Tableau Interface Types of Data Connections in Tableau Connect to Live Data connection
Connect to Extract Data connection in Tableau Creation of Extract file in Tableau
Data Joins in Tableau What is Join Types of Joins
When to use Joining
Rules to perform the Joins in tableau. What is Custom SQL?
Custom SQL Enabled Custom SQL. Writing
Data Refresh
Data Blending in Tableau What is Data Blending Types of Data Blending When to use Data Blending
Rules to perform the Joins in tableau Join vs. Data Blending
Graphs/Charts/Bars Line Graphs Single Line graphs Dual Line Graphs Blended Axis
Difference between Dual axis and Blended axis Horizontal Bar Charts
Vertical Bar charts Side-Side by bar charts Stacked Bar charts
Pie Charts Gantt Charts
Maps
What is Tree Maps Heat Maps
Tree map implementation Filed Maps
What is Geo-Coding and implementation Importing External Custom Geo coding Symbol Maps
Hierarchy in Tableau
What is a Hierarchy?
Relation between Drill downs, Roll ups and Hierarchies. What are Automatic Hierarchies?
How to create Custom Hierarchy in Tableau? Removing Hierarchy
Aggregation and Disaggregation
What is Aggregation When to use Aggregation What is Disaggregation
When to use Disaggregation.
Filters and Types
What is Filters
Filters on Dimensions What is Wild Card Filters on Measures Context Filters Global Filters
Quick Filters
Defining Filters at Source Defining Filters at Custom SQL
Groups and Sets
What is Group When to use Group
Editing Existing Group Limitation of groups What is Set
When to Use Sets Types of Sets
Calculated Fields
What is Tableau Calculation
When to use INDEX (),RANK (),LAST(),FIRST() Functions RUNNING_SUM Calculations
WINDOW_SUM Calculations
String Calculations Boolean Calculations DATE Calculations.
Creating and Using Parameters
What is Parameter Creating Parameter
Exploring Parameter Controls
Work with the parameter
Click interaction working with parameter Parameters and use with real time examples Dynamically Show and Hide Sheets with Parameter
Trend Analysis
What is Trend Analysis Logarithmic Model Exponential Model Linear Model Polynomial Model
Fore Casting and Reference Lines
What is Fore Casting and implementation What is Reference Line
Lines Bands
Distributions
Box Plot
Annotations
Mark Annotation Point Annotation Area Annotation
Page-shelf or Automated Maps
What is Page Shelf?
When to use Page Shelf
Page Shelf Customized Controls What is Drop Lines
When to use Drop Lines? What is summary Card?
When to Use Summary Card in Tableau?
Getting Started with Dashboard Sections
What is Dashboard, when to use Dashboard and Ways to use Dashboard What is work book and When to use Workbook
What is work sheet and When to use worksheets What is stories their usage
Ways to use Workbook, Dashboard, Worksheet, Stories
Dash Board Components
Horizontal
Vertical component Image Component Text Component Blank Component
Actions in Tableau
What is Actions & When to use Actions
Types of Actions in tableau How to Trigger the Action
Tableau Advanced Charts – User defined Charts (IMP)
Water Fall charts Donut charts Funnel Charts Word cloud Lollipops charts Whisker plots.
Scatter plot
Different Add INS and new feature in Tableau
Advanced Tableau 10 New Features.
Reporting Migration Process and Check list in Real-Time
Tableau Desktop:
Publishing workbook and data source Managing and creation of sites
Migration of workbook in different environment Tabadmin commands on server level
Postgrey SQL to connect the tableau server Postgrey SQL to create server level report Backup and recovery at tableau server Performance recording at server level
Getting Started with Tableau Prep
The Union Step The Output Step
The Tableau Prep Interface The Input Step
The Cleaning Step Group and Replace The Profile Pane The Pivot Step
The Aggregate Step The Join Step