• What is Tableau Tool?
• Importance and Scope of Tableau?
• Tableau compatibility with high level languages
• Tableau Installation
• Role of Tableau in current industry
• Why MS-SQL and Advance Excel are required for Tableau?

• Defining names for cells, Range of Data
• Working with Functions in Excel
• Conditional Formatting using Formulas
• Data Validation
• Working with Excel Tables
• Data Sorting
• Data Filtering
• Working with Subtotal
• Working with Pivot Tables and Pivot Charts
• Working with Lookup Functions
  1. VLOOKUP
  2. Match
  3. Index, Offset etc.
  4. Indirect
• Statistical Functions
  1. Moving Average
  2. Rank and Percentile
• What if Analysis Tools
  1. Goalseek
  2. Solver Scenario manager
  3. Data Tables
• Protect worksheets (Full and partial Protection)
• Creating templates
• Protect workbooks
• Recording Macros and Using it

Module 1 – Introduction to RDBMS                                                                        

• Explain the concept of data and database.
• Describe the approaches to Data Management.
• Define a Database Management System and list its benefits.
• Explain the different database models.
• Define and explain RDBMS.
• Describe entities and tables and list the characteristics of tables.
• List the differences between a DBMS and RDBMS.

Module 2 – Database Files and Database Engine Architecture                       

• Describe SQL Server and state its features.
• Identify the various components under SQL Server.
• Describe two-tier, three-tier and multi-tier models.
• List the system databases under SQL Server .
• State the uses of primary, secondary and log files.
• Explain briefly the physical database architecture.
• Explain briefly the relational database engine architecture.

Module 3 – Database’s, File File-Groups.                                                          

• Describe the system and user-defined databases in SQL Server .
• Outline the key features of the Adventure Works sample database.
• Describe how to add file groups and transaction logs.
• List types of database modifications and describe how to drop a database.

Module 4 –Sql Statements (Data Query Language)                                          

• Understanding Select Statement
• Filter Columns, use Expressions, Alias Names
• Usage of Top, Distinct, Null etc. keywords
• Using String and Arithmetic Expressions
• Exploring Where Clause
  • Relational Operators
  • Logical Operator
  • Between
  • IN
• Sorting data using Order By clause
  • Using Column Names
  • Using Column Index
  • Based on Multiple Columns

Module 5 —  Function is a set of Transact-SQL                                                  

• Aggregate Functions
  • Count, Sum, Min, Max, Avg Group By and Having Clause
• Group by Clause
• Having Clause
• Using Group By with Rollup and Cube
• Conversion Functions
• Date Functions
• Mathematical Functions
• System Functions

Module 6 —  Function is a set of Transact-SQL                                                  

• Windows Functions
• Window Aggregate Functions
• Window Ranking Functions
• Writing Queries with PIVOT and UNPIVOT
• Working with Grouping Sets

Module 7 – Multi-Table Queries                                                            

• Describe joins.
• Describe the various types of joins.
  • Inner Join
  • Outer Join
  • Self-Join
• Explain subqueries.
  • Single Row Subquery
  • Multi row Subquery
  • Multi column Subquery
• Co-Related Sub Queries
• Set Operators using UNION, EXCEPT and INTERSECT operators.

Module 8 – Data Definition Language (DDL)                                                     

• Create Table
• Constraints
  • Primary Key
  • Unique
  • Not Null
  • Check
  • Default
• Implement Constraint
  • Column Level Constraint
  • Table Level Constraint
• Alter Command
  • Add, Drop column using Alter Table
  • Add, Drop Constraint using Alter Table
• Drop table

Module 9 – Data Manipulation Language (DML)                                              

• Insert a record to Table
• Insert a record only to selected Columns
• Update Command
• Delete Command
• Truncate table Command
• Understand the difference between
  • Delete, Drop & Truncate Command.

Module 10 – Introduction to Indexes                                                                

• Introduction to Indexes
• Types Of Index
  • Clustered
  • Non-Clustered
  • Unique
  • Composite
• Commands to create Index
• Create Index using SSMS

Module 11 – Implementing Views                                                                     

• Introduction to Views
• Defining Advantages of Views
• Creating, Altering, Dropping Views
• Modifying data through Views
• Simple view, Complex Views

Module 12 – Introducing Stored Procedures                                                    

• Introduction to stored procedures
• Benefits of Stored Procedures
• System Stored Procedures
• Extended Stored Procedures
• User defined Stored Procedures
• Create and execute user defined stored procedures
• Understand Variables
  • Local Variables
  • System global Variables
• Stored Procedures with Parameters

Module 12 – More on Stored Procedures                                                         

• Return Output from Stored Procedure using return keyword
• Return Output from Stored Procedure using Parameters
• Input–Output and Optional Parameters
• Viewing information
• Modifying Stored Procedures
• Dropping Stored Procedures
• Exception Handling in MS SQL
• @@ERROR function
• RAISERROR statement returns the user-defined error message

Module 13 – Introduction to Triggers                                                               

• Introduction to Triggers
• Constraints vs Triggers
• Understand Inserted and Deleted Tables
• Creating DML Triggers
• Insert Trigger
• Update Trigger
• Delete Trigger

1. Working with Sets
2. Sorting
   1. Ascending
   2. Descending
   3. Default
3. Creating Groups
4. Data Types in Tableau
5. Parameters
6. Database Calculations
   1. Aggregate Functions
   2. Numeric Functions
   3. String Functions
   4. Logical Functions
7. Grouping
8. Hierarchies
9. Filters
   1. Static
   2. Interactive
   3. Format Filters
10. Formatting
    1. Color
    2. Border
    3. Table Formats
11. Analysis
    1. Applying Totals
    2. Grand Total
    3. Sub Total
12. Table Calculations
    1. Quick Table Calculation
    2. Percentage of Total
    3. Running Totals
13. Using Compute
14. Live and Extract in Tableau
    1. Live connect to the Live Data
    2. Extracts works on snapshot of Data.
15. Working on Data-Source
    1. View Data
    2. Sort Fields
    3. Hiding the Fields

1. What role does cards play?
2. Marks Card
3. Filter Card
4. Measure Names and Values

1. Bar Charts
2. Stacked Bar Charts
3. Pie Charts
4. Line Chart
5. Scatter Chart
6. Bubble Chart
7. Maps Chart
8. Bump Chart
9. Bump (rank)
10. Funnel Chart
11. Tree-map
12. Water-Fall Chart

• Dash-Board Functionalities
• Joins and Data Blending
• Story Point
• Device Designer

• Automating a business Process using Tableau Tool