Complete Data Science and Machine Learning Career Program with AI - Live

Day 1: Introduction to Excel for Data Analysis

• Overview of Excel interface and navigation
• Understanding cells, rows, columns, and ranges
• Using basic Excel functions for calculations
• Applying mathematical and statistical functions
• Introduction to text functions for data cleaning and manipulation

Day 2: Advanced Formulas and Functions

• Working with logical functions (IF, AND, OR, etc.)
• Exploring lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Introduction to array formulas and dynamic ranges
• Identifying and handling missing or inconsistent data
• Formatting data effectively for analysis
• Creating basic charts and graphs for visualization
• Tips for professional data presentation
• Introduction to PivotTables for dynamic data summaries
• Creating PivotCharts for visual insights
• Leveraging Excel with AI for smarter analysis

Day 1: Excel AI,  Project, Kaggle & Github Introduction

• AI-assisted data cleaning & transformation
• Excel with AI project 
• Kaggle and Github optimization

Day 2: Introduction to SQL

• Overview of SQL & databases
• Basic syntax, SELECT, WHERE
• Creating & modifying tables (CREATE/ALTER)
• Understanding constraints

Day 1: Aggregations & GROUP BY

• COUNT, SUM, AVG, MIN, MAX
• Filtering aggregates
• GROUP BY, HAVING
• ORDER BY, LIMIT, sorting
• DISTINCT vs GROUP BY
• LLM-powered optimization suggestions

Day 2: Joins & Subqueries

• Introduction to Joins 
• INNER, LEFT, RIGHT, FULL OUTER Joins & Self join
• Deep Dive into Joins & Subquery Logic
• Subqueries 

Day 1: Window Functions

• Basic windows functions Aggregate functions ,(SUM,MIN,MAX,COUNT,AVG)
• Rank functions( ROW_NUMBER(), RANK(), DENSE_RANK() ,PARTITION BY)
• Advance windows functions (LAG(), LEAD(), SUM() OVER(), AVG() OVER())
• AI error detection in analytical SQL

Day 2: Data Cleaning & Recursive CTE's

• CTE ,SUBSTRING, LENGTH, TRIM, REPLACE
• UPPER/LOWER
• UNION vs UNION ALL
• DATE_ADD, DATEDIFF, EXTRACT
• AI-assisted SQL debugging