LightBlog
Contact at mumbai.academics@gmail.com or 8097636691/9323040215
Responsive Ads Here

Sunday, 27 May 2018

Tableau

Tableau is one of the fastest evolving Business Intelligence (BI) and data visualization tools. It is very easy and fast to deploy, easy to learn and very intuitive to use for a customer. Here is a learning path to all those people who are new to Tableau. This path will help you to learn Tableau in a structured approach. Beginners are recommended to follow this path religiously. If you already have some background, or don’t need all the components, feel free to follow your own paths and let us know how did it turn out to be.Tableau

Tableau

This course perfect for someone who wishes to enter the field of analytics. training is designed for:
Analytics professionals,IT developers & Data analysts, Data scientists, BI and reporting professionals Project managers Professionals aspiring for a career in growing and demanding fields of real-time big data analytics Business users who want to develop a set of core Tableau Desktop Aspirants and students, who wish to gain a thorough understanding of Tableau Desktop Professionals looking to appear for a Tableau Certification exam

Introduction to Data Where housing

  • What is Database evaluation?
  • Database Evaluation types
  • What is Data where Housing.
  • Data where Housing Characteristics.
  • Data where Housing Architecture.
  • Difference between OLTP And OLAP.
  • What is Dimension table.
  • When to use Dimension.
  • Types of Dimension Tables.
  • What is Fact table and types.
  • When to use Fact table.
  • Types of Fact tables.
  • What is Star schema and snowflake schema?

Business Intelligence

  • What is Business Intelligence?
  • What is Visual Intelligence?

Tableau Introduction 

  • Why Tableau
  • History of Tableau
  • Characteristics of Tableau
  • Tableau versions.
  • Differences between different versions of tableau.
  • What is Vizql
  • Use of Vizql in Tableau.
  • Tableau Architecture and components. 

Tableau Components

  • What is Tableau Desktop
  • What is Tableau 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 

View Sections

  • What is Dashboard 
  • When to use Dashboard 
  • Ways to use Dashboard 
  • What is work book 
  • When to use Workbook 
  • What is work sheet 
  • 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 

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 

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 

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 

Groups & 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. 

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 

Aggregation and Disaggregation

  • What is Aggregation 
  • When to use Aggregation 
  • What is Disaggregation 
  • When to use Disaggregation. 

PageShelf or Automated Maps

  • What is Page Shelf? 
  • When to use Page Shelf 
  • Page Shelf Customized Controls 

Drop Lines

  • What is Drop Lines 
  • When to use Drop Lines? 
  • What is summary Card? 
  • When to Use summary Card in Tableau? 

Actions in Tableau

  • What is Actions & When to use Actions 
  • Types of Actions in tableau 
  • How to Trigger the Action 

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 

Tableau Advanced Charts – User defined Charts (IMP)

  • Water Fall charts 
  • Donut charts 
  • Funel Charts 
  • Lollipops charts 
  • Whisker plots. 
  • Scatter plot 

Case Study

  • Resume Preparation 
  • Mock Interviews 
  • Advanced Tableau 10 New Features. 
  • Reporting Migration Process and Check list in Real-Time.

No comments:

Post a Comment