Tableau + SQL

Tableau + SQL

Tableau + SQL is the most universally asked-for skill combination in any analyst role — and analysts who master both move up the ladder faster (and earn more) than tool specialists. This focused one-month program covers advanced SQL (joins, window functions, CTEs, performance tuning) alongside Tableau Desktop's full power — calculated fields, LOD expressions, parameters, dashboards, storyboards, and Tableau Server publishing. Real business scenarios throughout: sales analytics, churn analysis, marketing attribution. Built to prepare you for the Tableau Desktop Specialist certification.

0 lessons

What you'll learn

  • Write complex SQL queries with window functions, CTEs, and subqueries
  • Tune SQL performance — read EXPLAIN plans, add the right indexes
  • Build production-grade Tableau dashboards with calculated fields + LOD
  • Use parameters and actions to create interactive analytics experiences
  • Publish dashboards to Tableau Server + manage permissions properly
  • Storytell with data — design dashboards executives actually use
  • Connect Tableau to modern data sources — Snowflake, BigQuery, Redshift
  • Pass the Tableau Desktop Specialist certification
  • Land Tableau Developer / BI Analyst roles paying ₹4-12 LPA

Technologies Taught

Advanced SQL — joins, window functions, CTEs, recursive queriesSQL performance — indexes, EXPLAIN plans, query optimisationTableau Desktop — calculated fields, LOD expressions, parametersTableau Prep Builder for data preparationTableau Server + Tableau Cloud for publishing + sharingTableau Bridge for hybrid environmentsConnection to real-time data sources — Snowflake, BigQuery, PostgresTableau Desktop Specialist certification prep

Training Unique Features

  • Fast-paced 1-month track — designed for working professionals
  • Build a 3-dashboard portfolio: sales, marketing, operations
  • SQL + Tableau covered together — not in isolation
  • Daily 90-minute live class with live data walkthroughs
  • Real business datasets — not textbook examples
  • Tableau Desktop Specialist certification preparation included
  • Mock interview rounds covering SQL + Tableau patterns
  • Trained by BI consultants with 11+ years cross-industry experience
  • Resume + LinkedIn polish for BI / Analyst roles
  • Lifetime access to course recordings + dashboard templates

You Can Work As

Tableau DeveloperBI AnalystData Visualization SpecialistReporting AnalystBI ConsultantSenior BI Developer

Upcoming In-Demand Jobs

Cloud BI EngineerSelf-Service Analytics EngineerEmbedded Analytics Developer

Training Curriculum

Oracle Basics

11 topics
  • •Basics of RDMBS
  • •DDL, DML, DQL, and TCL Commands
  • •Operators in Oracle (And, OR, Not, IN, LIKE, Between)
  • •Null, Not Null
  • •Order By in Oracle
  • •Group By, Group Functions and Having Clause
  • •Constraints (Not Null, Unique, Primary key, Foreign Key and Check)
  • •Joins (Inner join, Left outer, right outer, Full outer joins, Self-join and Cross join)
  • •Set Operators (Union, Union All, Intersect, Minus)
  • •Rank and Dense Rank functions
  • •Views and indexes

Introduction to Data Visualization

7 topics
  • •What is Data Visualization?
  • •Why is it needed?
  • •Uses of Tableau
  • •Architecture of Tableau
  • •Installation of Tableau Desktop
  • •Tableau Products
  • •Comparison with Other Visualization Tools

Connecting to Data

8 topics
  • •Tableau Home Page
  • •Data Source Page
  • •Connecting to Text and Excel Files
  • •Connecting to Databases
  • •Connecting to Cloud Data sources (Snowflake)
  • •Live and Extract Connections
  • •Using and Refreshing Extracts
  • •Clipboard Data

Tableau Environment

6 topics
  • •Tableau Window Partitions
  • •Visual Cues in Tableau
  • •Dimensions, Measures
  • •Continuous and Discrete
  • •Generated Fields
  • •Workbooks and Sheets

Basic Visualizations

11 topics
  • •Line, Bar, Area Charts
  • •Text Tables
  • •High Light Tables
  • •Totals and Sub Totals
  • •Creating Charts Using "Show Me"
  • •Highlight Tables
  • •Flavored Bar Charts
  • •Heat Maps & Tree Maps
  • •Area Charts & Bubble Charts
  • •Scatter Plots
  • •Gantt Bars & Lollipop Charts

Building Data Views

4 topics
  • •Sorting
  • •Grouping
  • •Sets
  • •Bins and Histogram

Building Interactive Views

5 topics
  • •Filters
  • •Parameters
  • •Calculated Fields
  • •Table Calculations
  • •Conditional Formatting

Calculations

5 topics
  • •Creating Calculated Fields
  • •Number Functions
  • •String Functions
  • •Date Functions
  • •LODs and their Types

Maps and Geo Coding

7 topics
  • •Mapping Basics
  • •Symbol Maps
  • •Filled Maps
  • •Editing Locations
  • •Map Options
  • •Map Layers
  • •WMS Servers

Advanced Analysis

5 topics
  • •Parameters
  • •Clusters in Data
  • •Reference Lines & Reference Bands
  • •Distribution Bands
  • •Forecast

Handling Multiple Data Sources

4 topics
  • •What is Data Blending?
  • •Uses of Data Blending
  • •Cross Data Base Joins
  • •Report creation using Data Blending

Present Your Work

6 topics
  • •Actions and their types
  • •Formatting
  • •Annotations
  • •Drop lines
  • •Log Axes
  • •Exporting Data

Performance Tuning

3 topics
  • •How to Optimize workbook performance
  • •How to Publish Data Sources?
  • •How to Publish Worksheets & Workbooks

Tableau Server

6 topics
  • •Introduction To Tableau Server
  • •Tableau Server Architecture
  • •Scheduling Refreshes/Emails
  • •Alert Creation
  • •Realtime Project with Explanation using Tableau Desktop
  • •Interview Questions & Resume Building

Training Instructed By

MK
Mr. Krishna K---

15+ Years of experience in DWH/BI Projects having exposure to multiple technologies like Salesforce, Tableau, Oracle Database many many more. Approved trainer by Raj Cloud Technologies.

Approved trainer by Raj Cloud Technologies

Training content

Lifetime access

Watch at your own pace

Certificate included

On 100% completion

Q&A community

Ask anything, get answers

₹14,499

One-time payment. Lifetime access.

Sign in to Enroll
Have questions?

Ask anything about this training

Curriculum, fees, schedule, EMI options — drop your question and our admissions team replies within one business day.

We reply within 1 business day · Your details are never shared

  • 0 on-demand lessons
  • Lifetime access
  • Certificate of completion