Tableau Training

100% Practical Training course with Realtime Project. This Tableau Training course includes Basic to Advanced Visualizations, Data Modelling, Big Data Access, API Integrations, Groups, Bins, Sets, Filters, Sets, Calculations, Functions, Table Expressions, LOD (Level Of Detail), Custom Layouts, Cloud Colloborations, Actions, Dashboards, Stories, Tableau Server, Tableau Online, Alerts, Subscriptions and Tableau Prep Compponents for ETL and End to End implementations in Realworld.

Pre-Requisites : Basic knowledge on SQL is mandatory. If you are new to Database, please opt for Plan B or Plan C below.

Tableau Training Plans

  PLAN A PLAN B PLAN C
Description Tableau PLSQL &
Tableau
PLSQL, Tableau &
Python
Course Duration 4 Weeks 8 Weeks 12 Weeks
Completely Real-time, Practical
Tableau Desktop & Reports
Groups, Sets, Hierarchies
Filters, LOD Expressions
Actions, Bookmarks, Calc
Tableau Prep and ETL
Tableau Server, Online
Table Admin & Security
Dashboards & Worksheets - Security
Tableau : Real-time Project
SQL : Basic SQL, SQL Server Concepts
PL-SQL : Queries, Joins, Group By
PL-SQL : Queries, SProcs, Lock Hints
PL-SQL: Queries, Normal Forms, Excel
Python: Modules
Python: Detailed Design of Interactive
Python: Python Dictionary
Python: Introduction to Web
Python: GUI Programming-Tkinter
Total Course Fee * INR 15,000
USD 203
INR 21,000
USD 284
INR 27,000
USD 365
Tableau Training Schedules
S No Timings (IST) Start Date  
1 8:30 AM - 9:30 AM Feb 15th Register
2 8:30 AM - 10:30 AM (W) Mar 11th Register
Oracle SQL & PL-SQL Training Schedules
S No Time (IST, Mon - Fri) Start Date  
1 6:30 AM - 7:30 AM Feb 2nd Register
2 8:30 AM - 9:30 AM Feb 21st Register
3 10:30 AM - 11:30 AM Feb 15th Register
4 6:30 PM - 7:30 PM Jan 31st Register
5 8:30 AM - 10:30 AM (W) Feb 4th Register
Python Training Schedules
S No Time (IST, Mon - Fri) Start Date  
1 7:30 AM - 8:30 AM Feb 28th Register
2 5:30 PM - 6:30 PM Mar 7th Register

Tableau Training Highlights :

Advanced Reporting Concepts Paginated Reports
Detailed Design of Interactive Data Formatting
Advanced Visualizations Data Access Operations
Dynamic Data Acces Parameterized Connections
Cloud (Service) with Reports Dashboards & Apps
Tableau Server Configuration Data Refresh Options
Project for your Resume Excel, Database Sources

If above schedule does not work, opt for Tableau Training Videos

Tableau Training Course Contents:

Module 1: Basic SQL

Module 2: SQL & PL SQL

Module 3: Adv PLSQL

CHAPTER 1 : INTRODUCTION TO DBMS

  • What is Data and Information?
  • Purpose of Data Management
  • File and File System For Data Storage
  • Disadvantages of File Data Management
  • Database : Purpose, Basic Terminology
  • Advantages of Database for Data Storage
  • Possible Operations on the Database
  • Database Models – Hierarchical Model
  • Network Model and Relational Model
  • Introduction to DBMS
  • Introduction to RDBMS
  • Database Design
  • Most Popular RDBMS Products
  • History, Real-time Database Examples (LIVE)

CHAPTER 7 : CONSTRAINTS & KEYS

  • Importance of Data Integrity
  • Working with Integrity constraints
  • Types of Integrity Constraints
  • Domain Integrity Constraint and Usage
  • Entity Integrity Constraints and Usage
  • Referential Integrity Constraint and Usage
  • Check Constraints and Usage
  • NOT NULL Constraint, UNIQUE Constraint
  • PRIMARY KEY Constraint and Usage
  • FOREIGN KEY Constraints and Relations
  • Column Level  & Table Level Constraints
  • Adding Constraints to Tables, User_Constraints
  • Enabling - Dropping Constraints, Self Referential Integrity
  • Disabling Constraints on Tables

CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I

  • Simple If, If..Else. Nested If..Else Statements
  • Ladder, Selection, Simple Case Statements
  • GOTO Label and EXIT Statements in PL/SQL
  • Iterations in PL/SQL, Simple LOOP, WHILE
  • FOR LOOP and NESTED LOOPS in PLSQL
  • PL/SQL Select statements
  • SQL within PL/SQL, Composite Data Types
  • Cursor Variables and Management in PL/SQL
  • Implicit & Explicit Cursors and Attributes
  • Cursor with Parameters and Nested LOOPs
  • Cursors with Sub Queries, Reference Cursors
  • Implicit Cursors,Explicit Cursor
  • Parameterized Cursors,Ref Cursors
  • REF Cursors

CHAPTER 2: ORACLE INSTALLATION

  • Oracle 2018 Installation Guidance
  • Oracle 2012 Installation
  • Installation Pre-Requisites and Precautions
  • Oracle Sql Developer
  • Oracle Sql Command prompt
  • Oracle Versions and Editions Comparisions
  • Connect Sql Developer Tool
  • Creating a new User
  • Grant permission
  • Lock and Unlock User Account
  • How to Reset User Account Password
  • SQL* Plus
  • How to Establish the Oracle Connection
  • Default System user  in Oracle
  • Default Sysdba user  in Oracle

CHAPTER 8 : QUERIES & JOINS

  • Need for Joins and Table Comparisons
  • SET Operations on Tables and Joins
  • Join Types : Equi Join, Simple Join
  • Inner Join and Query Conditions
  • Cross Join (Cartesian Join), Conditions
  • Join syntax - Sql syntax and Ansi Syntax
  • Non-Equi Join and Self Join
  • Outer Joins – Types, Advantages and Usage
  • Cross Joins – Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Using Aliases in Joins and Conditions
  • Using Inner Self Joins with HAVING
  • JOINS and GROUP BY Queries

CHAPTER 14: ADVANCED PL/SQL - 1

  • Procedures in PL/SQL: STORED PROCEDURE
  • PROCEDURES @ Parameters (IN, OUT, IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors and Sub Queries
  • ALTER and DROP of Stored Procedures
  • Functions in PL/SQL: Real-time Usage
  • User Defined Functions, Nested Functions
  • Using Functions in SQL Statements
  • Working with Procedures and Functions
  • Comparing Stored Procedures and Functions
  • Using SPs with Table Value Functions
  • Using SPs for Dynamic SQL Statements
  • Loops and Table Variables in SQL Programs
  • Merge, NVL2(), NULLIF(), COALESCE()
  • CASE & Temporary /Global Tables

CHAPTER 3: INTRODUCTION TO RDBMS

  • Features of RDBMS
  • Advantages of RDBMS
  • E.F Codd Rules for RDBMS
  • Normalization Concepts & Process
  • Client Server Communication
  • Oracle Corporation Products
  • RDBMS from Other Vendors: Microsoft, IBM,etc
  • Oracle Versions about SQL & SQL*PLUS
  • Database Types: OLTP and OLAP Databases
  • Real-world Advantage of OLTP & OLAP
  • Why a database is called as Relational Database Model
  • Database Entites and Attributes
  • Applicative use of RDBMS Databases

CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES

  • VIEWS IN ORACLE, Understanding Views & Use
  • Relational Views and Standard Views
  • SIMPLE VIEWS and COMPLEX VIEWS in PLSQL
  • Column Definitions in VIEWS
  • Using VIEWS for DML Operations
  • Forced Views, CHECK Constraints in Views
  • Creation of READ ONLY VIEWS - Realtime Use
  • TOP-N Analysis, (Indexed) Materialized Views
  • SequenWorking ces, with Synonyms
  • What is the Use of Synonym in Oracle?
  • Difference between View and Synonym in Oracle
  • When should Table Synonyms be used?
  • Public Synonym and Private Synonyms
  • All_Synonyms and Dba_Synonyms System Tables
  • Creating Index Tables – Purpose

CHAPTER 15 : ADVANCED PL/SQL - 2

  • Cross Tab Views using Pivot/Unpivot Operators
  • Follows Clause and READONLY Tables
  • IN-LINE VIEWS. Manipulations with Triggers
  • Purity Levels in Oracle - with Examples
  • User_Source Dictionary Table Packages
  • Creating PACKAGE Specifications with PLSQL
  • PACKAGE Body - Examples with Big Data Tables
  • Private and Public Objects in PACKAGE
  • Types of Exceptions: User Defined Exceptions
  • EXCEPTIONS in PL/SQL with Real-time
  • Event Handling and Error Handling Techniques
  • Important Error Code Values in PL/SQL
  • RAISE_APPLICATION_ERROR Procedure

CHAPTER 4 : SQL LANGUAGE COMMANDS

  • Structured Query Language (SQL) Basics
  • What is SQL?
  • What Can SQL do?
  • Possible Operations with SQL
  • Data Definition Language (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)
  • Rules of SQL Queries and Statements
  • Real-world applicative uses of SQL
  • Creating Users and Tables
  • Table Data Inserts and Validations
  • Oracle Data Types
  • DDL Commands with Examples
  • CREATE, ALTER, TRUNCATE,DROP,RENAME
  • Learn the DESCRIBE command to display the table structure
  • DML Command DRL Commands Operators
  • INSERT, UPDATE, DELETE Statements
  • Difference between Truncate and Delete commands
  • SELECT Statements with Multiplier
  • SQL Comments
  • Single Line Comments & Multi Line Comments
  • WHERE Keyword for Query Conditions

CHAPTER 10 : SUB QUERIES, NESTED QUERIES

  • Sub Queries in Real-world
  • Dynamic Conditions with Sub Queries
  • Sub Queries and Nested Sub Queries
  • How does oracle Execute Nested Sub Queries?
  • Inner Select and Outer Select Queries
  • Usage of Sub Queries with WHERE, HAVING
  • Impact of Having Clause in Sub Queries
  • Select Nth Highest salary
  • Select Duplicate Records
  • Delete Duplicate Records
  • Advantages of Oracle Sub Query
  • Subquery in the Select Clause Examples
  • Subquery in the From Clause Examples
  • Display Odd Rows in a table
  • Display Even Rows in a table
  • Execution of Correlated Sub Queries in SQL
  • IN, ANY SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE in Sub Queries
  • Single Row Subquery & Multiple Row Subquery
  • Multiple Column Subquery
  • UnCorrelated Subquery
  • Difference between Correlated and Non-Correlated Subquery
  • How does Oracle Execute Correlated Subquery?
  • NULLs and Correlated Sub Queries in SQL

CHAPTER 16 : ADVANCED PL/SQL - 3

  • Pragma_Autonomous_Transaction() with SPs
  • Returning into clause, Bulk Collect
  • For All, Definer/Invoker Rights & Usage
  • About Flash Back Queries, Dynamic SQL
  • Flash Back Command, Purge Command
  • Regular Expressions in PLSQL
  • What is the Recycle Bin?
  • How to Delete RecycleBin Table?
  • How to Delete Recycle Bin?
  • SQL Loader - Flat file into Oracle table
  • Abstract Datatypes
  • DML Error Logging and Virtual Columns
  • Types of Triggers, Row Level Triggers
  • Statement Level Triggers, DML Triggers
  • DDL Triggers and Schema Level Triggers
  • Using OLD & NEW References, Trigger Auditing
  • Enabling / Disabling Triggers, Dropping Triggers
  • Triggers in PL/SQL and Data Manipulations
  • Using Memory Tables in Triggers
  • DML and DDL Events with Triggers
  • Compound Triggers, New data types
  • Working with LARGE Tables in PLSQL
  • New: EXTRACT(), Autonomous Transaction
  • Pragma Exception_init in oracle

CHAPTER 5.SQL SPECIAL OPERATORS

  • SET, AND, OR, NOT, IN
  • Special Operators – IN (NOT IN)
  • BETWEEN (NOT BETWEEN),
  • Arithmetic and Logical Operators
  • Understand Operator Precedence
  • UNION, UNION ALL, INTERSECT, MINUS
  • LIKE (NOT LIKE), IS NULL (IS NOT NULL)
  • Understanding DCL and TCL Commands
  • Transaction Concepts in Databases with SQL
  • Transaction Types and Uses
  • Commit and Rollback Operations
  • Nested Transactions with Savepoints
  • Database Read Consistency with SQL
  • DDL and DML Operations with Transactions

CHAPTER 11: LOCKS in ORACLE TABLES

  • Open Transactions and Lock Concepts
  • Lock Types and Locking Mechanism
  • Row Level Locks for Table Data Access
  • Table Level Locks and Query Blocking
  • Shared Lock and Real-time Use
  • Shared Update Lock and Real-time Use
  • Exclusive Lock and Real-time Use
  • DeadLock : Detection, Prevention, Avoidance
  • Implicit Locking Concepts in Oracle with PLSQL
  • How to check howmany locks are occured?
  • LOCK Hints and Query Blocking
  • What is row exclusive lock in Oracle?
  • What is lock in SQL?
  • What are different types of locks?

CHAPTER 17: OBJECT TECHNOLOGY – Level I

  • Object Technology and Applicative Use
  • OOPS-Object Instances, Creation of Objects
  • Creating User Defined Data Types
  • Creating Object Tables in Oracle
  • Inserting rows in Table using Object
  • Retrieving data from Object Based Tables
  • Calling a Method, Indexing Abstract
  • Data type Attributes in PLSQL
  • Advantages of Collections
  • Ref Cursor (Dynamic Cursor), Weak Ref Cursor
  • Strong Ref Cursors and Nested Tables
  • Associative Arrays, VARRAYS/VARYING arrays
  • Creating tables using Nested Tables
  • Inserting, Updating & Deleting
  • Nested, Table Records

CHAPTER 6: GROUPING QUERY RESULTS

  • Identify Distinct Values in Tables
  • Group Function or Aggregate function
  • Group By Syntax
  • Group By Operations in Queries
  • Having Clause of DRL Statements
  • Aggregate Functions with Group By
  • Order By Clause and Group By
  • SQL Group By Statement
  • Query Execution Order with Group By
  • Arithmetic Functions,Character Function
  • Date & Time Functions,String Function
  • Conversion Functions,Analytical Function
  • Rank(), Dense_Rank(),Row_Number()
  • NVL(),NVL2(), NullIF(),Coalesce()

CHAPTER 12 : PERFORMANCE (QUERY) TUNING

  • Indexes - Definition and Architecture
  • B Tree Concept in Indexes
  • Clustered and Non clustered Indexes
  • Primary Key and Clustered Index
  • Unique Key and Non Clustered Indexes
  • Simple Index, Rebuild Index
  • Materialized Views - Indexed Views
  • Composite Index, Function Based Index
  • User_indexes System Table
  • Range Partitions and Hash Partition
  • Partion “VALUES LESS THAN “ Clause
  • List Partition and Composite Partition
  • Parallel Query Process with Partitions
  • Performance Tuning Advantages

CHAPTER 18: OBJECT TECHNOLOGY – Level II

  • Perform a Basic Search using the REGEXP_LIKE function
  • patterns using the REGEXP_INSTR function
  • Extract Substrings using the REGEXP_SUBSTR function
  • Replace Patterns Using the REGEXP_REPLACE
  • Invisible Columns in Oracle Database 12c
  • What is fetch in SQL?
  • Can we use limit in Oracle?
  • What is offset in Oracle?
  • Is PL SQL object oriented?
  • What is Oracle object type?
  • What is object type in Oracle PL SQL?
  • Is Oracle object oriented database?
  • What is PL SQL in Oracle?
  • What is Oracle constructor?

Part 1: Tableau Report Design - 1

Part 2: Tableau Report Design - 2

Part 3: Tableau Prep, Server, Online

Ch 1 : TABLEAU INTRO, INSTALLATION

  • Introduction to Tableau, Reporting Tools
  • Report Types in Real-time: Interactive
  • Paginated, Analytical and Mobile Reports
  • Data Sources for Report Design Process
  • Databases & Types: OLTP, DWH, OLAP
  • Tableau : Basic Understanding, Workflow
  • Tableau as a Self Service BI Tool
  • Tableau Features, Technical Advantages
  • Tableau Public Desktop : Installation
  • Development, Production and Access
  • Data Sources Types in Tableau
  • Tableau Prep Tools - Data Modelling
  • Power BI Licensing Plans - Types
  • Tableau Training : Course Plan, Lab
  • Study Material, Certifications, FAQs

Ch 7 : TABLEAU VIZ - LEVEL 1

  • Tableau Visualizations - Types
  • Visualization Categories, Usage
  • Tableau Bar Charts and Types
  • Simple Bar Charts and Usage
  • Horizontal & Colored Bar Charts
  • Stacked Bar Charts, Measures
  • Side By Side Bar Charts and Use
  • Interactive Bar Charts & Filters
  • Line Charts and Data Points
  • Continous Line Charts and Usage
  • Discrete Line Charts and Usage
  • Dual Line Chart and Types
  • Area Charts : Discrete, Continous
  • Stacked Area Charts, Reports
  • Combine Area Charts & Line Charts

Ch 13 : DASHBOARDS & STORIES

  • Dashboards and Stories in Tableau
  • Bulding Dashboards - Views, Sheets
  • Dashboard Size, Views, Objects
  • Legends and Quick Filters in Tableau
  • Tiles, Floating Layouts in Tableau
  • Layout Containers, Images, Web Pages
  • Dashboard Extensions, Management
  • API Extensions - Usage in Tableau
  • Device Designer - Default Layout
  • Adding and Customizing Layouts
  • Story Points - Creation and Updates
  • Bollinger Bands - Views, Summary
  • Data Cleansing - Bulk Re-aliasing
  • Tableau Prep : Installation ETL
  • Tableau Desktop Store, Server Store

Ch 2: BASIC REPORTS, GROUPING

  • Tableau Public Desktop : Installation
  • Tableau Workbook Creation, Data Sources
  • Tableau Worksheets : Creation, Options
  • Row Shelf & Column Shelf, Details View
  • Marks : Text, Detail, Tooltip, Colors
  • VizQL : Vizualization Query Language
  • Tableau In-Memory Database Usage
  • Dimensions, Measures Identification
  • Working with Data Sources, WorkBooks
  • Worksheets, Marks, Shelves, Axis
  • Basic Report Design Terminology
  • Grouping : Data Categorization
  • Creating Groups on Static Data
  • Dynamic Data Grouping, Binnig
  • Hierarchies: Creation, Real-time Use
  • Drilldown Reports in Tableau

Ch 8 : TABLEAU VIZ - LEVEL 2

  • Tableau Pie Charts, Real-time Use
  • Simple Pie Charts - Examples
  • Stacked Pie Charts - Examples
  • Side By Side Pie Charts
  • Reverse Rows and Row Count
  • Donut Charts and Agle Properties
  • Inner / Outer Pie Charts, Stacking
  • Drill-down Pie Charts and Usage
  • CrossTab Charts and Text Properties
  • Rows, Columns and Marks : Text
  • Conditional Formatting, Divergence
  • Using Quick Claculations in Tableau
  • Highlight Tables and Color Palettes
  • Box & Wishker Plots - Text Tables
  • Heat Maps and Real-time Usage
  • Size Controls and Color Options

Ch 14 : TABLEAU SERVER

  • Tableau Server - Architecture
  • Tableau Server - Installation Process
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Server
  • Adding Custom Layouts in Tableau Server
  • Adding Content to Custom Layouts
  • Java Script API in Table Server
  • Tableau Online Versus Table Server
  • Security Advantages @ Tableau Server
  • Tableau Online - Architecture
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Online
  • Adding Custom Layouts in Tableau Online
  • Adding Content to Custom Layouts
  • Security Advantages @ Tableau Online

Ch 3 : TABLEAU ARCHITECTURE, JOINS

  • Data Sources, Connectors, Clients
  • Tableau Server Components and Use
  • Application Server and Repository
  • VizQL Server and Data Engine
  • Backgrounder, Data Server, Search
  • Fast Data Engine, Gateway Components
  • Alias, Bins, Bookmarks, Calcualtions
  • Tableau File Types and Workbooks
  • CrossTabs, Dashboards, Data Pane
  • Data Source Page and Dimensions
  • Extract, Filters, Pages, Rows, Columns
  • Visual Sync Limitations with Slicer
  • Level of Detail, Sets, Marks, Workbooks
  • Using Joins in Tableau Sources
  • Inner, Left / Right Outer Joins

Ch 9 : TABLEAU VIZ - LEVEL 3

  • Tableau Treemaps & Nested Rectangles
  • Marks Type, Color, Size and Label
  • Comparing Treemaps with Bars & Tables
  • Circle View Vizualization and Usage
  • Side By Side Circle View, Usage
  • Scatter Plot - Labels, Axis Items
  • Packed Bubbles and Circles - Lables
  • Tableau Symbol Maps - Examples
  • Tableau Filled Maps - Examples
  • Using Quick Table Calculations
  • Histogram Charts and Properties
  • Measures and Value Comparisions
  • Tableau Motion Charts and Axis
  • Bullet Graphs and Limitations
  • Dimension - Measure Considerations

Ch 15 : Colloborate TABLEAU ONLINE

  • Tableau Online - Purpose, LIVE Reports
  • Projects and Workbooks in Tableau Online
  • Tableau Report Views in Tableau Online
  • Searching Content, Data Sources, Sites
  • Account Settings, Drill Down, Actions
  • Custom Views, Comments - Tableau Online
  • Downloads, Exports - Tableau Online
  • Sharing, Subscription and favorites
  • Web Authoring, Edits and Publish Online
  • Data Driven Alerts - Refining, Managing
  • Stacked Bars and Views For Alerting
  • Navigations, Snapshots, Searching
  • Mobile Reports - Phone Marks and Maps
  • Interacting with Content on Tableau Online

Ch 4 : BIG DATA ACCESS, BLENDING

  • Azure Data Access with Tableau
  • Remote Data Sources and Joins
  • Using SQL Queries in Tableau
  • Use Azure SQL Warehouse (DWH)
  • Data Blending Options in Tableau
  • Working with Multiple Data Sources
  • Data Combinations & Aggregations
  • Show Data & Data Grouping Options
  • Tableau Operators and Types
  • Tableau Functions and Real-time Use
  • Tableau Calculations and Formats
  • Numerical Calculatins & Examples
  • Aggregated Calculations in Tableau
  • Creating Calculations From Shelfs
  • Calculation Edits, Identifications

Ch 10 : TABLEAU FILTERS

  • Tableau Filters - Types & Usage
  • Extract Filters and TDE (hyper)
  • Data Source Filters (twb Files)
  • String and Numerical Data Fields
  • Date/ Time Data Fields, Usage
  • All Rows, Too & Bottom Rows
  • Aggregated Extracts and Usage
  • Extract History, TDE Files
  • Context Fitlers and Realtime Use
  • Context Filters: Performance Benefit
  • Dimension Filters & Limitations
  • Measure Filters and Aggregations
  • Measure Name Filters, Measure Values
  • Table Calculation Filters, Usage
  • Tableau Filters - Execution Order
  • Fiters Scope and Quick Filters

Ch 16: Colloborate TABLEAU SERVER

  • Tableau Server - Purpose, LIVE Reports
  • Projects, Workbooks in Tableau Server
  • Tableau Report Views in Tableau Server
  • Searching Content, Data Sources, Sites
  • Account Settings, Drill Down, Actions
  • Custom Views, Comments in Tableau Server
  • Downloads and Exports in Tableau Server
  • Sharing, Subscription and favorites
  • Web Authoring, Edits and Publish Online
  • Data Driven Alerts - Refining, Managing
  • Stacked Bars, Alerting Views in Server
  • Navigations, Snapshots, Searching in Server
  • Mobile Reports - Phone Marks and Maps
  • Interacting with Content on Tableau Server

Ch 5 : STRING, DATE FUNCTIONS

  • String Functions in Tableau
  • ASCII, CHAR, LEN, ENDSWITH
  • FIND, FINDNTH, LEFT, CONTAINS
  • LOWER, UPPER, LTRIM, RTRIM
  • MID, MIN, REPLACE, RIGHT
  • SPACE, SPLIT, UPPER, MAX
  • STARTSWITH, AND, CASE
  • ELSE, ELSEIF, END, IF, IIF
  • IFNULL, ISDATE, ISNULL, MAX
  • MIN, NOT, OR, THEN, WHEN, ZN
  • DATEADD, DATEDIFF, DATENAME
  • DATEPART, DATETRUNC, DAY
  • ISDATE, MAKEDATE, MONTH
  • NOW, QUARTER, TODAY, YEAR

Ch 11 : PARAMETERS, SETS

  • Tableau Parameters - Working
  • Creating Parameters, Conditions
  • Linking Parameters to Calculations
  • Using Calculations in Fields/View
  • Dynamic Filters using Parameters
  • Dynamic Dimension using Parameters
  • Dynamic Measures using Parameters
  • Creating, Using Sets in Tableau
  • IN and OUT Concepts in Sets
  • Working with Filters and Sets
  • Show Set Options and Exclude
  • Comparing Tableau Sets & Groups
  • Comparing Tableau Sets & Hierarchies
  • Dynamic Sets : Creation & Usage

Ch 17 : MANAGE TABLEAU SERVER

  • Tableau Server - Administration Concepts
  • Tableau Sites, Users, Groups Security
  • Group Rules, Web Edits in Tableau Server
  • Project Permission and Locking Options
  • Data Security with user Filters in Server
  • user Filters and Hybrid Models in Server
  • Access Roles, Schedules, Extraction
  • TSM : Tableau Services Manager
  • TSM Configuration for Real-time Use
  • Browser, Maintenance, GUI and CLI
  • Backups and Restores with Tableau TSM
  • TSM Upgrades For Tableau Report Config
  • Tabcmd : Command Line Utility - Imports
  • Tabcmd : user Import via CSV File
  • Comparing Tableau & Microsoft Power BI

Ch 6 : TABLE, LOD CALCULATIONS

  • Calcualtions For Year, Quarter, Month
  • Custom Calculations, Data Appending
  • Custom Date and Time Formatting
  • Calculations Reuse and Edits
  • Date and Time Conversions To INT
  • Two Digit Conversions with Date
  • Table Functions with Tableau
  • Running Total and Row Number
  • Case Statements, FIRST, LOOKUP
  • Table Calculations, Level of Details
  • Real-time Use of Table Calculations
  • Partitioning, Addressing Benefits
  • LOD : Types of Level Of Detail
  • FIXED LOD Expressions - Examples
  • INCLUDE LOD Expressions - Examples
  • EXCLUDE LOD Expressions - Examples

Ch 12 : TABLEAU FORECASTS, ACTIONS

  • Tableau Trend Lines and Usage
  • Reference Lines and Show Data
  • Forecasts, Exponential Smooting
  • Creating and Using Forecasts
  • Describing, Controlling Forecasts
  • Adding / Editing Bookmarks
  • Using Data Analytics in Tableau
  • Tableau Actions and Real-time Use
  • Tableau Action Types, Limitations
  • Filter Actions: Static/Dynamic
  • Highlight Actions, Dynamic Types
  • URL and Parameter Action Types
  • Set Actions, Runtime Actions
  • Tableau Actions & Dashboards
  • Use Field and Filter Actions

Ch 18 : REAL-TIME PROJECT
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering, FSA
Phase 1:
  • TABLEAU Report Design
  • Visualizations, Properties
  • Analytics and Formating
Phase 2:
  • Data Modeling, Tableau Prep
  • Dynamic Connections, Azure DB
  • Parameters and VizQL Scripts
Phase 3:
  • Tableau Online Analysis
  • Cloud and Tableau Server
  • Project FAQs and Solutions

Python Basics - Level I

Python Basics - Level II

Module II: Advanced Python

DAY 1 : INTRODUCTION TO SCRIPT

  • What is Script in Python?
  • What is a program in Python?
  • Types of Scripts in Python?
  • Difference between Script
  • programming languages list
  • main features of scripting Lang.
  • limitation of client side scripting
  • Programming Language Paradigms
  • Basic understanding of Python
  • Is Python a compiled language?
  • where is python used in real life?
  • Why is Python called Python?

DAY 9 : Python TUPLE

  • Advantages of Tuple over List
  • Packing and Unpacking - Tuples
  • Creating Nested tuple -Examples
  • Deleting Tuples - Slicing of Tuples
  • Comparing Tuple Membership Test
  • Built in Functions ,Dotted Charts

 Python Sets

  • how to create/declare a set in python
  • Iteration Over Sets - Python Methods
  • Python Set Operations - Union of Sets
  • Built-in Functions with Set
  • python frozenset get element

DAY 17 : Python Regular Expressions

  • What is Regular Expression?
  • Regular Expression Syntax
  • Understanding Regular Expressions
  • Regular Expression Patterns
  • Literal characters - Repetition Cases
  • Groups and Grouping Regular Expressions
  • Example of w+ and ^ Expression
  • Example of \s expression in re.split function
  • Using regular expression methods
  • Using re.match() in Regular Exp.
  • Finding Pattern in Text (re.search())
  • Using re.findall for text

DAY 2 : INTRODUCTION TO PYTHON

  • What is Python Programming?
  • Why Python is used in DS?
  • Where is python Mostly used?
  • Characteristics of Python Programming
  • History of Python Programming Language
  • What is PSF Python Programming?
  • Python Versions - Python Application
  • How to Download Python,print to the screen
  • How to Install Python , Creating Program
  • Install Python with Diff IDEs
  • Features of Python Programming
  • Limitations of Python Programming

DAY 10 : Python Dictionary

  • How to create a dictionary?
  • PYTHON HASHING - Dictinary Methods
  • Copying dictionary - Updating Dictionary
  • Delete Keys from the dictionary
  • Sorting the Dictionary - Dictionary len()
  • Python Dictionary in-built Functions
  • Variable Types - python List Cmp()
  • Python List cmp() Method
  • Python Dictionary Str(dict)
  • How do you create a dictionary in Python?
  • Can Python dictionary have multiple values?
  • How do you add to a dictionary in python?

DAY 18 : Python-Data Base Communication

  • What is Database? Types of Databases
  • What is Database Management System
  • What is Relational DBMS?
  • What is Big Data? Types of data?
  • Oracle - SQLSERVER - MYSQL - DB2
  • Postgre SQL - DataBase Sample
  • Executing the Queries - Bind Variables
  • Installing of Oracle Python Modules
  • Executing DML Operations..!!
  • Connecting to the Database
  • Create a connection object.
  • Create a cursor object to read/write.

DAY 3 : DIFFERENT MODE IN PYTHON

  • Execute the Script - Interactive & Script Mode
  • Python File Extensions - Script Mdoe
  • SETTING PATH IN Windows - Clear Screen
  • Learn Python Main Function - Comments
  • Quit the Python Shell - Simple Calculator
  • Order of operations - Multiline Statements
  • Quotations in Python - Python Path Testing
  • Joining two lines - Python Implementation
  • Python Packages - Usage of Python in DS
  • USES OF PYTHON IN IOT - Working in Python
  • in Unix/Linux/Windows/Mac/Android..!!
  • script Mode and Interactive mode

DAY 11 : Python Functions

  • What is a function? - Types of Function
  • How to define and call a function in Python
  • Significance of Indentation (Space) in Python
  • How Function Return Value?
  • Types of Arguments in Functions
  • Default Arguments - Non Default Arg.
  • Keyword Arguments - Non Keyword Arg.
  • Arbitrary Arguments in python
  • Various Forms of Function Arguments
  • Scope and Lifetime of variables - Nested Fun
  • Call By Value, Call by Reference in python
  • Anonymous Functions/Lambda functions

DAY 19 : Multi-Threading

  • What is Multi-Threading
  • Threading Module in python
  • Defining a Thread in python
  • Thread Synchronization
  • What is python multithreading?
  • Does Python have true multithreading?
  • Difference between multiprocessing & multithreading
  • Why does Python have a Gil?
  • Thread Control Block (TCB):
  • Thread Identifier in MultiThreading
  • Stack pointer in multi-Threading
  • Program counter, Thread State

DAY 4 : PYTHON NEW IDEs

  • PyCharm IDE - How to Work on Pycharm
  • PyCharm Components - Debugging in Pycharm
  • PYTHON Install Anaconda - What is Anaconda?
  • Coding Environments - Spyder Components
  • General Spyder Features - Spyder Shortcut Keys
  • Jupyter Notebook - What is Conda?
  • Conda List - Jupyter and Kernals Environment
  • Python PIP - Mutable Versus Immutable Objects

 Variables in Python

  • What is Variable? - Variables and Constants
  • Variable names - Mnemonic Variable Names
  • Values and Types - What Does "Type" Mean?
  • Multiple Assignment - Python Numerical types

DAY 12 : Python Modules

  • What is a Module? - Types of Modules
  • The import Statement - The from… import st
  • ..import * Statement - Underscores in python
  • The Dir() Function in python
  • Creating User defined Modules
  • Command line Arguments in python
  • Getting Python Module Search Path
  • What are modules and packages in Python?
  • What is Python import statement?
  • How do you import random in Python?
  • import <module_name> string python
  • from <module_name> import <name(s)>
  • from <module> import <name> as <name>

DAY 20 : Introduction to Python Web

  • Python Web Frameworks
  • Django – Design Form or patterns
  • Advantages of Django Web Framework
  • MVC and MVT - Installing Django
  • Designing Web Pages using python
  • HTML5, CSS3, AngularJS Templates
  • PYTHON Flask - Java Script variables
  • PYTHON Bottle - PYTHON pyramid - Falcon
  • How Python is used for web programming?
  • Can I build a website with Python?
  • Is Python suitable for Web development?
  • What is Python and Django?

DAY : 5 Python Operators and Operands

  • Arithmetic Operators - Relational Operators
  • Comparison Operators - Assignment Operator
  • Short hand Assignment Operators
  • Logical Operators or Bitwise Operators
  • Membership Operators - Identity Operators
  • Operator precedence - Evaluating Expressions
  • python evaluate expression in string
  • Standard Datatypes - Operators and Operands
  • Order of operations - Swap Variables
  • Types Conversion Function - Python Math.
  • Mutable Versus Immutable Objects
  • Operator precedence - Evaluating Exp.
  • Evaluating expressions in python

DAY 13 : Packages in Python

  • What is a Package in Python?
  • Introduction to Packages?
  • py file - Creating a package
  • Importing module from a package
  • Creating Sub Package in Python
  • Importing from Sub-Packages
  • Most Popular Python Packages
  • How many libraries are there in Python?
  • What are libraries in Python?
  • What is the difference between NumPy & SciPy?
  • Why is SciPy and NumPy used?
  • Python what is Seaborn? - Examples
  • Is NumPy a Python framework?

DAY 21 : GUI Programming-Tkinter

  • Introduction to Tkinter GUI Program
  • Components and Events in Tkinter
  • Adding Controls in Tkinter form
  • Entry Widget, Text Widget, Radio Button,
  • Check Button in Tkinter forms
  • List Boxes, Menus, ComboBox, Canvas, Entry
  • What is Tk () in Python?
  • What is Mainloop () in Python?
  • What is the best GUI for Python?
  • Can we make a GUI in Python?
  • Messagebox ,simpledialog
  • messagebox tkinter methods
  • showinfo(),showerror(), showwarning()

DAY 6 : String Handling

  • what is String ? - String Operations - String indices
  • String Functions - len , upper, lower,join,Split
  • SwapCase(), Title(),find(),isupper(),islower()
  • Delete a string - Python Keywords
  • String Multiplication and concatenation
  • Python Identifiers - Python Literals
  • string formatting operator in python
  • Built-in String Methods - Data Structures
  • Structuring with indentation in Python
  • Define Data Structure in Python Language
  • Reverse words - Reverse Characters Examples
  • How do you split a string in Python?

DAY 14 : Python Date and Time

  • How to Use Date & DateTime Class
  • How to Format Time Output
  • How to use Timedelta Objects
  • Calendar in Python
  • datetime classes in Python
  • How to Format Time Output?
  • Python Calendar Module,Time Module
  • Python Text Calendar
  • Python HTML Calendar Class
  • Unix Date and Time Commands
  • Python strftime()
  • How strftime() works?

DAY 22: Data Analytics

  • Introduction to data Big Data?
  • Introduction to NumPY and SciPY
  • Introduction to Pandas and MatPlotLib

Data Science

  • What is Data Science in Python
  • Data Science Life Cycle in python
  • what is data analysis using python
  • what is Data Mining in Python
  • Analytics vs Data Science in python
  • How Python is used in big data?
  • Is Python or R better for data science?
  • Why is Python used in data science?

DAY 7 : Python Conditional

  • Control Structures - Sequential Control Structure
  • Selective and Repetative Control Structure
  • How to use “if condition” in conditional
  • control Structures in python
  • if statement (One-Way Decisions)
  • if .. else statement (Two-way Decisions)
  • How to use “else condition”
  • if .. elif .. else statement (Multi-way)
  • When “else condition” does not work
  • How to use “elif” condition
  • How to execute conditional statement with
  • minimal code - Nested IF Statement
  • Nested IF Statement in python

DAY 15 : Python OS Module

  • Shell Script Commands in OS Modules
  • Various OS operations in Python
  • Python File System Shell Methods
  • Different Python Modules
  • os - math - cmd -csv - random
  • Numpy ( numerical python )
  • Pandas - sys - Matplotlib - Datetime
  • Python Exception Handling
  • Common RunTime Errors in PYTHON
  • Abnormal termination,Python Custom Exception
  • Chain of importance Of Exception,Assertions
  • Exception Handling, Argument of an Exception
  • Try … Except,Try…Except…else,Try…finally

DAY 23 : Internet of Things

  • IMPACT OF THE INTERNET
  • What is IOT - History of IOT
  • What is importance of Network?
  • What is importance of Protocol?
  • what is smart_open in python
  • How Internet of Things Works?
  • The Future of Internet of Things
  • What is future of Internet of Things
  • Is Python used in IoT? - Framework
  • Which language is better for IoT?
  • How many IoT devices will be there?
  • How many IoT devices are there?

DAY : 8 Python LOOPS

  • How to use While loop and For loop
  • Break and Continue Statements in For loop
  • Python Enumerate function for For Loop

 Sequence or Collections and Lists

  • Strings - Unicode Strings
  • Lists - Tuples - Sets - Dictionary - Xrange
  • Lists are mutable - Accessing the List
  • Updating a List - Deleting a List
  • List indices - Traversing a list
  • List operations - List Slices - List Methods
  • Map, filter and reduce - Deleting elements
  • What is list of list in python?
  • What is Python list function?
  • How do you add to a list in Python?

DAY 16 : Python Class and Objects

  • Introduction to OOPs Programming
  • Object Oriented Programming System
  • Define Classes - Built in Class Attributes
  • Creating Objects - Constructors
  • Class variables and Instance Variables
  • Basic concept of Object and Classes
  • Access Modifiers - Self Varible in python
  • How to define Python classes
  • Python Namespace - Garbage Collections
  • What is Inheritance? Types of Inheritance?
  • Single Inheritance - Hierarchical Inheritance
  • Multilevel,Multiple,Hybrid Inheritance
  • Overloading and Over Riding
  • Polymorphism - Abstraction – Encapsulation

DAY 24 : Introduction to Machine Learning

  • Learning with PYTHON  
  • What is Machine learning?
  • Machine Learning Methods
  • predictive models in python
  • Descriptive Models in Python
  • What are the steps used in Mach. Learning?
  • what is deep learning in python
  • How Python can be used in Mach. learning?
  • Which Python library is used for Mach.Learning?
  • What is PredictionIO machine learning server?
  • What are some well open source ML libraries?
  • Why are most machine learning projects?
  • Some good open source projects for ML
  • What is the best open source machine translation?
 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today
 

Who can benefit from this Tableau Training course?

Complete Real-time and Practical Tableau Training with Real-time Project. With this humongous amount of data and real business implications at play, business organizations across the world have the need for an easy to use tool to analyze data and derive actionable insights from it. Tableau helps organizations do exactly this – mining the data and visualizing business opportunities.

Tableau Training - Highlights :

  • Completely Real-time & Practical Classes
  • Highly Interactive with Technical Examples
  • Project Oriented FAQs for your Job Interviews
  • Real-time Project with Complete Solution Explanation
  • Chapter Wise Interview Questions (FAQs) with Answers
  • Real-time Case Studies for Queries and DB Design, Solutions
  • Case Studies for Programming, Business Logic Solutions
  • Mock Interviews - Chapter Wise. Solutions & Explanations
 
 
  • Basic to Advanced Reporting Concepts
  • Detailed Design of Interactive, Paginated Reports
  • Basic to Advanced Visualizations and Data Formatting
  • Working with Tableau Prep, ETL & Data Access Operations
  • Dynamic Data Acces and Parameterized Connections
  • Tableau Cloud (Service) with Reports, Dashboards, Apps
  • Tableau Server Configuration and Data Refresh Options
  • Project for your Resume with Excel, Database Sources
 

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

 
 
 
For latest schedules Click Here