Big Data Training - Learn MapReduce, Sqoop, PIG, Hive,Hbase‎,Spark

Tableau Developer Classroom Internship Program

About this Course: Tableau Software is an American computer software managed and located  in Seattle, WA, USA. It produces a …

82 STUDENTS ENROLLED
    Upcoming Batches :
    TICKET TYPE START DATE TIME (PDT) PRICE
    General Mar-19-2017 10:00 AM $649.00
    General Apr-14-2017 8:30 PM $649.00

    About this Course:

    Tableau Software is an American computer software managed and located  in Seattle, WA, USA. It produces a family of interactive data visualization products focused on business intelligence. Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag & drop to analyze data. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more.

    Why should I go for Tableau Training?

    Due to the popularity of Big Data in the IT Industry, many organizations are looking for a better data management by using the best Data Visualization tools. To handle a huge amount of data and analytics, it is required for the need of smart Data Visualization tools. Tableau is one of the fastest evolving Business Intelligence (BI) and data visualization tool. It is very fast to deploy, easy to learn and very intuitive to use for a customer. Tableau leads TOP among all BI Tools. Tableau has 3 major products: Online, Desktop, and Server.

    Why is Tableau  is important?

    The tableau is an important tool that helps in the visualization of data in different methods. It is user-friendly and gives the results very quickly than other tools.

    Job Opportunities for the Tableau:

    Tableau’s culture is casual and high-energy. Tableau offers exceptional professional and financial growth potential. As more and more sources of data are getting discovered, business managers at all levels embrace data visualization software’s, that allow them to analyze trends visually and take quick decisions.

    Eligibility for Big Tableau :

    Proficiency in Oracle/SQL is also required along with working knowledge of Excel, Python and R.

    TABLEAU – Desktop and Admin
    Course Contents


    Session Name

    Session Context

    Detailed Contents

    Session I

    Overview

    Data Visualization Introduction

    Tableau Prerequisite

    Tableau Overview – Features

    Tableau vs Other tools

    Course content summary

    Career Path

    Course Features

    Tableau Software and Information

    Tableau Server Architecture
    – Component Functions
    – Server Diagrams

    Session II

    Sql Overview and Practice Session

    SQL RDBMS Concepts

    Create Table, Alter table, Generate Primary Keys

    Select, filter and Sorting data

    Insert, Update and Delete Data

    Top | Like |Group By | Having Clause

    Joins, Union and Union all

    Create Views

    Operators | Temporary Tables | Clone Tables

    Sub Queries | Handling Duplicates | Useful Functions

    Student Exercises

    Practice Questions – Sql Queries – Using MySQL Database

    Session III

    Desktop : Getting Started

    Tableau Product Catalog

    Tableau Architecture Overview

    Quick Start: Tableau Desktop

    Desktop – Overview

    Report creation demo

    Chart type Selections – Best Practices

    Dashboard creation demo

    Connecting to various data sources

    Building Views – Manually and Automatically

    Save and Share your workbook

    Student Exercises

    Practice Question # 1 – Database and accessing tables

    Practice Question # 2 – Text Tables

    Practice Question # 3 – Bar graph

    Session IV

    Server – Install and Configure

    Tableau Server Installation Checklist

    Server Installation Steps

    Configuration Options
    – Activate Tableau
    – Data Connections
    – Alerts and Subscriptions
    – Configure Kerberos

    Trouble shooting during installation

    Add and Admin Account

    Reconfiguration – Tableau Server

    Exploring Server Content Types and Objects

    Student Exercises

    Practice Question # 4 : Install Tableau Server and Configure

    Practice Question # 5 : Creating Users and Groups

    Practice Question # 6 : Create Custom Administrative Views

    Session VI

    Data Views

    Data Blending – Working with Multiple Data Sources

    Create Custom Relationships

    Edit and Define Relationships – Extract Data

    Joining tables – Managing Queries – Split a Field

    Building Data Views -Pivot Data (from Columns to Rows)

    Data Filtering – Sorting – Groups( Global Vs Normal Filters)

    Sets – Aggregations – Actions – Using Multiple Measures

    Creating Bins

    Student Exercises

    Practice Question # 7 – Packed Bubble Charts

    Practice Question # 8 – Map Views

    Practice Question # 9 – Creating Key Progress Indicators (KPIs)

    Practice Question # 10 – Using – Survey Data

    Session V

    Advanced Analysis

    Dashboards – Create and Organize Dashboards

    Joining Tables Vs Data Blending

    Calculations

    Forecasting

    Reference Lines, Bands, Distributions, and Boxes

    Organizing Dashboards

    Data Story

    Student Exercises

    Practice Question # 11 – Adding Totals to Stacked Bars

    Practice Question # 12 – Dynamic Reference Lines

    Practice Question # 13 – Context filters

    Practice Question # 14 – Marimekko Charts

    Practice Question # 15 – Rolling calculation

    Session V

    Advanced Analysis II

    Generating Totals

    Creating Parameters/Calculated Fields – Functions, Operators

    Background Images – Cycle Fields

    Trend Lines – Forecasting

    Predictive Models – R to Tableau

    Student Exercises

    Practice Question # 16 – Panel Charts

    Practice Question # 17 – Pocket Price waterfall

    Practice Question # 18 – Slope chart

    Practice Question # 19 – Run Charts

    Practice Question # 20 – Adding Actions to Dashboards

    Session VI

    Maps – Performance Tuning

    Maps – View, Geographic Roles

    Custom geocoding, Background Maps

    Data Security – Row and Column Level

    Publish Workbook – Server

    Create Performance recording

    Student Exercises

    Scenario-Practice Question # 1 – Benford’s Law

    Scenario-Practice Question # 2 – Pocket Price waterfall

    Scenario-Practice Question # 3 – Slope chart

    Scenario-Practice Question # 4 – Run Charts

    Scenario-Practice Question # 5 – Adding Actions to Dashboards

    Session VII

    User Experience

    Exploring Server Content Types and Objects

    Setting the Start Page

    Distributed Environment Overview and setup

    Work with Server – Sites

    Setting Up Projects

    Creating groups

    Creating Users and assigning credentials

    Scheduled Refresh Tasks and Subscriptions

    Administrative Views

    Interact with Views

    Student Exercises

    Server Practice Question # 1 : Creating Users and Groups

    Server Practice Question # 2 : Schedule data refresh tasks

    Server Practice Question # 3 : Create Custom Administrative Views

    Session VIII

    Security

    Authentication

    Authorization – Sites/User Groups

    Permission Rules and Capabilities

    Content Ownership and Permissions

    Granting Permissions to Projects

    Publishing and Changing Ownership of a Workbook

    Data Security and Network Security

    Student Exercises

    Server Practice Question # 4

    Server Practice Question # 5

    Server Practice Question # 6

    Server Practice Question # 7

    Session IX

    Data Sources and Performance

    Create/Publish/Connect to Data Source

    Data Engine and File Store

    Creating and Publishing Extracts

    Automating and Programming Server Tasks

    General Performance Guidelines

    Add Workers and Reconfigure

    Improve Server Performance

    Server Processes

    Build a Performance Recording

    Interpret Recording

    Student Exercises

    Server Practice Question # 8

    Server Practice Question # 9

    Server Practice Question # 10

    Server Practice Question # 11

    Session X

    Utilities and Log files Administration(Trouble Shooting)

    tabcmd

    tabadmin

    Log files Overview

    Archiving Log files

    Running Zip logs and Cleanup

    Archiving Log Files with a Snapshot

    Using Server Logs

    Student Exercises

    Server Practice Question # 12

    Server Practice Question # 13

    Server Practice Question # 14

    Session XI

    Monitoring and Upgrade Server

    Viewing Server Status

    Admin Alerts

    Admin Views

    Preparing to Upgrade

    Configuring for Kerberos

    Trusted Authentication

    Embedding a View

    Student Exercises

    Server Practice Question # 15

    Server Practice Question # 16

    Server Practice Question # 17

    Session XII

    Process Flows and Performance

    Repository Fail over

    Publishing an Extract

    File Store Decommissioning

    Backup Cache Server

    View Query Caching Search and Browse

    Student Exercises

    Server Practice Question # 18

    Server Practice Question # 19

    Server Practice Question # 20

    Session XIII

    Automating Server Tasks

    Automating and Programming Server Tasks

    Restoring a Backup

    Customizing VizQL Query Limit

    Exporting Configuration Settings

    Data Extract API

    Student Exercises

    Server Practice Question # 21

    Server Practice Question # 22

    Server Practice Question # 23

    Session XIV

    Scenarios

    Multiple Data Sources into One View

    Global Filter

    Actions to Dashboards

    Summary and detail together

    Bin Measures

    Combo Charts Preparation

    Area Charts

    Mapping

    Secondary Axes

    Student Exercises

    Scenario-Practice Question # 1 – Combining Start & End Dates into a Single Axis

    Scenario-Practice Question # 2 – Quadrant Chart

    Scenario-Practice Question # 3 – Creating Sparklines

    Scenario-Practice Question # 4 -Filtering Across Multiple Data Sources

    Scenario-Practice Question # 5 -Navigation to other Dashboards

    Section XV

    Case Study I & II

    Interview Questions

    Sample Data – Requirements -Dashboard & Reports

    Case Study 1 Analysis

    Highlights

    1. Practice oriented course structure
    2. Real time scenarios and Case studies
    3. Interview Preparation

     

    Copyright@ZillionixLLC.