Data Analytics using SQL with Tableau Online Live Classroom Training

The Data Analytics using SQL with Tableau Online live Classroom Training by GingerBoard Academy is 4 weeks, 1.5 hours per day, 5 Days a week covering the basic concepts of SQL, DBMS, Join & Analytical functions and Visualization & building dashboard using Tableau. Student will also be doing a project during the training which needs to be submitted one week after the completion of the course.

You will learn through online live classroom and get great hands on experience. This program is packed with assignments, class tests, weekly quiz, coding exercises and final exam.

For doubt clearing you can post query on forum and get answers within 48 hours. Also, a student counceller to connect with on queries and support.

Please Note:

This will be regorous 4 week long program, there will be timed class test before each class of what you have learned a day before. Every week Quiz and aptitude test along with assignment and Final Exam after each module. (Module 1: Data Analysis & SQL, Module 2: Tableau & Dashboard). You will also be expected to do a project as final submission for certificate.

Online Live Classroom Course


Course Structure

Unit 1 - SQL and Data Warehousing
  • · Data & Database etc
  • · SQL Server Management Studio
  • · Creating Databases: Files [MDF, LDF]
  • · DDL, DML operations
  • · Data Types for its usage
  • · Single Row Inserts, Multi Row Inserts
  • · Data Retrieval for analysis (select etc)
  • · SELECT with WHERE Conditions onloadedmetadata=""
  • · CHAR Versus VARCHAR Data Types
  • · VARCHAR & NVARCHAR Data Types
  • · IN Operator and NOT IN Operator
  • · BETWEEN, NOT BETWEEN Operators
  • · LIKE and NOT LIKE Operators
  • · Using Wild Card Characters
  • · IS and IS NOT Operator, NULLs
  • · Using DISTINCT, TOP Keywords
  • · DELETE Statement & Conditions
  • · TRUNCATE & DELETE Differences
  • · Table Data / Content Modification
  • · Table Structure Modifications (DDL)
  • · ALTER, ADD and DROP Statements
  • · Removing Tables and Databases
  • · Table Migrations across Schemas
  • · Import / Export Wizard From SSMS
  • · GO Statement, SQL BATCH Concept
  • · INNER JOIN - Examples
  • · Left Outer Joins with Example Queries
  • · Right Outer Joins with Example Queries
  • · FULL Outer Joins with real time scenario
  • · CROSS join
  • · Joins with GROUP BY and HAVING
  • · Joins with Sub Queries, IS NULL
  • · Date and Time Functions: Getdate()
  • · Cast and Convert with Getdate()
  • · Data conversion
  • · DateAdd and DateDiff Functions
  • · String Functions: Left and Right
  • · SubString, Replace and CharIndex
  • · Reverse, Len, LTrim and RTrim
  • · Using Joins with Subqueries
  • · Using Joins with Nested Sub Queries
  • · IIF ( ) and CASE Statement Usage
  • · Using IIF and CASE in Joins
  • · Joins in Group By, Rollup, Cube
  • · Replacing Nulls: Isnull, Coalesce
  • · ROW_NUMBER() and RANK() Queries
  • · DENSE_RANK, Sequence Identification
  • · PARTITION BY and RowNumber ( )
  • · CTE : Common Table Expressions
  • · Using CTEs for Avoiding Self Joins
  • · Using CTEs for Avoiding Subqueries
  • · PIVOT versus UNPIVOT Queries
Unit 2 - Visualisation and Dashboards
  • Scenario
  • Objetives
  • Application Terminology and Definitions
  • Opening and closing tableau
  • Data source page
  • Tableau Workspace
  • Files and folders
  • Gettign started with Tableau
  • View terminoogy and definitions
  • View sections
  • Data Terminology and Definitions
  • View Sections
  • Data Terminology and Definitions
  • Data Types
  • Data Roles: Dimension vs. Measure
  • Data Roles: Continous vs Descrete
  • Changing Data Roles
  • Connecting to Tableau Data Server
  • What is a Join
  • Types of Joins
  • When to Use Joining
  • Enabling Right Outer Join
  • Right Outer Join and Custom SQL Enabled
  • What is Data Blending
  • When to Use Data Blending
  • Data Blending in Tableau
  • Differences Between Joining and Blending
  • Joining vs. Blending
  • Writing Custom SQL
  • Prepare your Data for Analysis
  • Organizing and Simplifying Data
  • Objectives
  • Filtering Data
  • What is a Filter
  • Applying a Filter to a View
  • Filtering on Dimensions
  • Filtering on Dimensions Functions
  • Aggregating Measures
  • Filtering on Measures
  • Filtering on Dates
  • Quick Filters
  • Sorting of Data
  • What is Sorting
  • Sorting Data in Tableau
  • Types of Sorting
  • Creating Combined Fields
  • Combined Fields
  • Creating Groups and Defining Aliases
  • What is a Group
  • What are Aliases
  • Defining an Alias
  • Working with Sets and Combined Sets
  • Sets
  • Combined Sets
  • Working with Groups and Sets
  • Drill to Other Levels in a Hierarchy
  • Grand totals and Subtotals
  • Adding Totals
  • How to Define Aggregations
  • Changing Aggregation Function
  • Tableau Bins
  • Bins
  • Fixed Sized Bins
  • Variable Sized Bins
  • Formatting and Annotations
  • Adding Caption to Views
  • Click Interaction Adding Title to View
  • Click Interaction2 Adding Captions to View
  • Using Titles Captions and Tool tips
  • Adding Tooltips to Views
  • Using Title Caption and Tooltip
  • Formatting the Axes
  • Edit Axis Option
  • Formatting Views with Labels and Annotations
  • Format Window
  • Format Mark Labels
  • Date Hierarchies
  • Drilling in the Time Hierarchy
  • Pivoting Date Parts on Shelves
  • Differentiate Between Discrete and Continuous Dates
  • Using Continuous Dates
  • Using Discrete Dates
  • Working with Discrete and Continuous dates
  • What are Custom Dates
  • Creating and Using Custom Dates
  • Fiscal Year
  • Define a Date Field on a Fiscal Year
  • Relative Date Filters
  • Importing Date Dimensions in Tableau from a Cube
  • Work with Date Hierarchies on Cubes
  • Chart Types
  • Working with Combined Axis
  • Working with Combination Charts
  • Understanding geocoding and geographic mapping in tableau
  • Combined Axis Graph and Scatter Plot
  • Describe text and highlight tables
  • Work with Pages Shelf and Create Motion Charts
  • Heat Maps
  • Using Bins and Histograms
  • Using Histograms
  • Using Pie Charts
  • Compare Measures Using Bullet Charts
  • Using Bar in Bar Charts
  • Using Pareto Charts
  • Creating Pareto Charts
  • Using Waterfall Charts
  • Using Gantt Charts
  • Working with box plots
  • Using Sparkline Charts
  • Calculations
  • Objectives
  • Strings Date Logical and Arithmetic Calculation
  • Working with Strings Date Logical and Arithmetic Calculations
  • Using Strings Date Logical and Arithmetic Calculations
  • Working with Arithmetic Calculations
  • Aggregation Options
  • Working with Aggregation Options
  • Grand Totals and Sub-Totals
  • Quick Table Calculations
  • Creating Quick Table Calculations
  • Working with Quick Table Calculations
  • Automatic and Custom Split
  • Ad-hoc Analytics
  • LOD Calculations
  • Creating and using Parameters
  • Objectives
  • What is a Parameter
  • Creating a Parameter
  • Exploring Parameter Controls
  • Work with Parameters
  • Click Interaction Working with Parameters
  • Dashboards
  • Objectives
  • Build Interactive Dashboards
  • What is a Dashboard
  • Building Dashboards
  • Best practices for creating effective dashboards
  • Comprehending Best Practices
  • Creating a Dashboard and Importing Sheets
  • Interaction Exploring Dashboard Actions
  • Use of Running Actions
  • Using Dashboard Actions
  • Sharing your Work
  • How to Share your Reports
  • Exporting your Work

Reasons to Join this Course

Live Training Classes

Live Training Classes

Project

Project

Councellor and Forum Support

Councellor and Forum Support


Certificate

Certificate

Hands on Practice

Hands on Practice

Technical Interview Preparation during the course

Technical Interview Preparation during the course

Pursue your Dream Career with our Best Courses and expert trainers! Register Today!

Connect with us