Scribd
Upload
11 views1 page

SQL and Tableau for Data Analysis

The document outlines a training program on 'Data Analysis using SQL and Tableau' at ABES Institute of Technology for the 2025-26 session. It includes modules covering foundations of data analysis, relational databases and SQL basics, advanced SQL techniques, and data visualization with Tableau. Each module consists of various topics and subtopics, along with hands-on projects to reinforce learning.

Uploaded by

sajal.j2286
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views1 page

SQL and Tableau for Data Analysis

The document outlines a training program on 'Data Analysis using SQL and Tableau' at ABES Institute of Technology for the 2025-26 session. It includes modules covering foundations of data analysis, relational databases and SQL basics, advanced SQL techniques, and data visualization with Tableau. Each module consists of various topics and subtopics, along with hands-on projects to reinforce learning.

Uploaded by

sajal.j2286
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ABES Institute of Technology, Ghaziabad

CRC Technical Training Program - ODD Sem (Session - 2025-26)


Training Name - "Data Analysis using SQL and Tableau"
S. No. Modules Topics Subtopics

1.1 Understanding Data • Definition and scope; Data analysis lifecycle; Importance of data-
Module 1: Analysis driven decision making
Foundations of Data 1.2 Key Tools in Data • Role of SQL; Role of Tableau; Real-world case studies
1
Analysis Analysis • Structured vs. Unstructured data; Descriptive, Diagnostic,
1.3 Types of Data & Analysis Predictive, Prescriptive analysis

• Introduction to RDBMS and SQL


Module 2: Relational 2.1 Introduction to RDBMS • Creating and Understanding Tables
2 Databases & SQL 2.2 Working with Tables • SELECT Queries, Filtering, Sorting
Basics 2.3 Basic Querying

Hands-on Project

• COUNT, SUM, AVG, MIN, MAX; GROUP BY; HAVING clauses


3.1 Aggregations & Grouping • INNER, LEFT, RIGHT, FULL JOIN; Relationships between datasets
3.2 Joins & Relationships • Inline views; Correlated subqueries
3.3 Subqueries & Nested • Window functions (ROW_NUMBER, RANK, LEAD, LAG); Case
Module 3: Advanced
SELECTs expressions
3 SQL for Data
3.4 Advanced SQL • Handling NULLs; String manipulation; Date/time
Analysis
Functions transformations
3.5 Data Cleaning with SQL

Practical implementation project

4.1 Getting Started with


Tableau • Tableau Desktop vs. Public; Connecting data sources
4.2 Tableau Interface & • Data joins, relationships, unions; Data interpretation
Module 4: Data Data Preparation • Dimensions vs. Measures; Trend, seasonality, granularity
4 Visualization with 4.3 Creating Your First • Calculated fields; Parameters; Sorting, grouping, hierarchies
Tableau Dashboard • Dashboard design best practices; Interactive dashboards
4.4 Advanced Visualization
Features
4.5 Storytelling with Data

Practical visualization project

You might also like