Home
Course
Tableau with SQL

Tableau with SQL

~~$24~~ $20
Enroll Now Enroll Now

Tableau with SQL

In this course, we are going to learn about Tableau and SQL, with a focus on providing hands-on practical experiences. Additionally, we offer assistance for certifications in these areas to help students validate their skills and expertise

Tableau & SQL Certification Preparation

Overview of Tableau and SQL Certification Tracks.
Exam Structure and Format
Study Materials and Resources
Practice Exams and Mock Tests.
Tips for Successful Exam Preparation.

Tableau BI Topics

Module 1

Introduction to Data visualization and the power of Tableau

What is data visualization?
Comparison and benefits against reading raw numbers
Real use cases from various business domains Some quick and powerful examples using Tableau without going into the technical details of Tableau
Installing Tableau
Tableau interface

Module 2

Architecture of Tableau

Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)
Tableau field types
Saving and publishing a data source
Live vs extract connection
Various file types
The ways to share and export the work done in Tableau

Module 3

Charts & Graphs

Basic Charts
Customized Charts
Dual axes graphs

Module 4

Working with Metadata and Data Blending

Connecting to Data Source
Tableau data types
Connection to Excel
Cubes and PDFs
Management of metadata and extracts
Data preparation Joins (Left, Right, Inner, and Outer) and Union
Dealing with NULL values, cross-database joining, data extraction, data blending, refresh extraction, incremental extraction, how to build extract, etc.
Advanced joins

Module 5

Advanced Data Manipulations

Mark and highlight
Groups
Sets (creating and editing sets, IN/OUT)
Bins
Hierarchies
Folders
Sorting and Types
Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.
5.9 Editing axes and annotations

Module 6

Working With Filters

Filters (addition and removal)
Filtering continuous dates, dimensions, and measures
Filtering in Tableau
Types of filters
Filtering the order of operations
Top N and Conditional Filters
Combined Sets as Filters
Filtering by Hierarchies
Cross Database Filters

Module 7

Organizing Data and Visual Analytics

K-means cluster analysis
Trend and reference lines
Visual analytics in Tableau
Forecasting, confidence interval, reference lines, and bands
Parameters and Dynamic Input
Advanced Calculations

Module 8

Working with Mapping

Working on coordinate points
Plotting longitude and latitude
Editing unrecognized locations
Customizing geocoding, polygon maps, WMS: web mapping services
Working on the background image, including add image
Plotting points on images and generating coordinates from them
Map visualization, custom territories
How to create map projects in Tableau
Creating dual axes maps, and editing locations
Background Images for Non-Geographical Data
Dynamic Maps with Parameters
Layer Blending on Maps
Real-Time Data and Live Maps
Path Analysis

Module 9

Working with Calculations and Expressions

Calculation syntax and functions in Tableau
Various types of calculations, including Table, String, Date, Aggregate, Logic, and Number
Levels of details: fixed level, lower level, and higher level Quick table calculations
The creation of calculated fields
Quick LODs
String Manipulation
Date Calculations and Date Functions
Table Calculations Beyond Quick Table Calculations
Aggregation within Calculated Fields
Advanced Logical Calculations

Module 10

Working with Parameters

Creating parameters
Parameters in calculations
Using parameters with filters
Column selection parameters
Chart selection parameters
How to use parameters in the filter session
How to use parameters in the reference line
Dynamic Axis Range with Parameters
Parameter Swapping
Dynamic Set Creation with Parameters
Parameter-driven Calculations
Relative Date Filtering with Parameters

Module 11

Dashboards and Stories

What is a dashboard?
Building and formatting a dashboard using size, objects, views, filters, and legends
Best practices for making creative as well as interactive dashboards using the actions
Creating stories
Adding annotations with descriptions; dashboards and stories
Highlight actions, URL actions, and filter actions
Selecting and clearing values
Dashboard examples using Tableau workspace and Tableau interface
Filter Actions with Multiple Data Sources
Dashboard Performance Optimization
Dashboard Extensions
Dynamic Titles and Headers

Module 12

Tableau Prep

Introduction to Tableau Prep
How Tableau Prep helps quickly combine join, shape, and clean data for analysis
Creation of smart examples with Tableau Prep
Getting deeper insights into the data with great visual experience
Making data preparation simpler and accessible
Integrating Tableau Prep with Tableau analytical workflow
Data Source Filters in Tableau Prep
Data Cleaning Techniques in Tableau Prep
Advanced Join and Union Operations in Tableau Prep
Regular Expressions in Tableau Prep
Data Sampling and Profiling in Tableau Prep
Custom Calculations in Tableau Prep

SQL Topics

Module 1

Introduction to SQL

Various types of databases
Introduction to Structured Query Language
Distinction between client server and file server databases
Understanding SQL Server Management Studio
SQL Table basics
Data types and functions
Transaction-SQL
Authentication for Windows
Data control language
The identification of the keywords in T-SQL, such as Drop Table
Introduction to SQL Commands
Normalization in Databases
Stored Procedures and Triggers in T-SQL

Module 2

Database Normalization and Entity Relationship Model

Entity-Relationship Model
Entity and Entity Set
Attributes and types of Attributes
Entity Sets
Relationship Sets
Degree of Relationship
Mapping Cardinalities, One-to-One, One-to-Many, Many-toone, Many-to-many
Symbols used in E-R Notation
Foreign Key Constraints:
Primary Key Constraints
Stored Procedures
Normalization
Denormalization

Module 3

SQL Operators

Introduction to relational databases
Fundamental concepts of relational rows, tables, and columns
Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys
Understanding group functions
The unique key
Data Integrity
Triggers in SQL
Database Design Principles

Module 4

Working with SQL: Join, Tables, and Variables

Advanced concepts of SQL tables
SQL functions
Operators & queries
Table creation
Data retrieval from tables
Combining rows from tables using inner, outer, cross, and self joins
Deploying operators such as intersect, except, union,
Temporary table creation
Set operator rules
Table variables

Module 5

Deep Dive into SQL Functions

Understanding SQL functions what do they do?
Scalar functions
Aggregate functions
Functions that can be used on different datasets, such as numbers, characters, strings, and dates
Inline SQL functions
General functions
Duplicate functions
Mathematical Functions
String Functions
Date and Time Functions

Module 6

Working with Subqueries

Understanding SQL subqueries, their rules
Statements and operators with which subqueries can be used
Using the set clause to modify subqueries
Understanding different types of subqueries, such as where, select, insert, update, delete, etc.
Methods to create and view subqueries
Common Table Expressions
Stored Procedures and Functions
Database Transactions