ABES Institute of Technology, Ghaziabad
CRC Technical Training Program - EVEN SEMESTER (Session - 2024-28)
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
• Creating and Understanding Tables
Module 2: Relational 2.1 Introduction to RDBMS • SELECT Queries, Filtering, Sorting
2 Databases & SQL 2.2 Working with Tables • CRUD operation
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
Module 3: Advanced 3.3 Subqueries & Nested • Window functions (ROW_NUMBER, RANK, LEAD, LAG); Case
3 SQL for Data SELECTs expressions
Analysis 3.4 Advanced SQL Functions • Handling NULLs; String manipulation; Date/time 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 • Data joins, relationships, unions; Data interpretation
Module 4: 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