File

Cohort 119 - (Da/Ds/GenAi - SS)

Link, passcode & update section

No Class Scheduled for Today – Sunday, 13th July 2025.pdf

Induction class & Python installation

23rd Feb Recording (131:14)
23 Feb Files

Introduction to Data analytics & starting with Python Basics

1st March Recording (145:26)
File

Variables and operations in Python

2nd March Recording (145:50)
File

Excel class notes and Excel Project

8th March Recording (153:49)
8th March file

Excel Assignment (Assignment 1), Operators in Python, Conditions in Python

9th March recording (148:05)
9th March file

Loops (For and While), Range and commands (Pass, Break)

15th March Recording (154:04)
File

1. One line conditions 2. One line loops 3. mini project in conditions and loops 4. Strings - part 1

16th March Recording (152:49)
File

Strings - 2 List Tuples

22nd March Recording (154:13)
File

Dictionary Sets Functions in Python - Part 1

23rd March Recording part-1 (0:24)
23rd March Recording part-2 (152:17)
File

Functions in Python Modules in Python

29th March Recording (148:20)
File

1. Exception handling 2. Class and Objects introduction

30th March Recording (112:31)
File

Database Session 1 (Introduction to database and SQL)

5th April Recording (155:45)
File

1. Create Schema 2. Create, Alter, Drop tables 3. Primary Key and Foreign key 4. Insert into table 5. Delete data from table 6. Import data using csv

6th April Recording (150:56)
File

1. SQL Query Where clause 2. Assignment 2: Python 3. Assignment 3: SQL

12th April Recording (55:52)
Files

1/ Database last part: Aggregate functions, WIndow functions, JOINS, Stored Procedures, Temporary tables, Views, Normalizations, Dimensional Modelling 2. Introduction to Statistics

19th April Recording (149:36)
File

1. Types of data 2. Measure of central tendency

20th April Recording (143:20)
File

Data analysis with: 1. One variable 2. Two variable

26th April Recording (153:36)
Files

1. Analyzing 2 datasets: Numerical v Numerical 2. Box plot 3. Skewness and Kurtosis

27th April Recording (145:33)
File

1. Hypothesis 2. Z stat 3. Chi squared test

3rd May Recording (153:11)
3rd May File

Probability Distribution

4th May Recording (145:45)
File

1. Array 2. Numpy: creating 2 D array and basic operations

10th may Recording (101:18)
File

1. Numpy: 2 and multi diamensional dataset 2. Numpy application in linear algebra problem 3. Pandas: Creating dataframe from various sources 4. Adding Rows and Columns to existing DataFrame

11th May Recording (153:30)
File

1. Pandas filter 2. Pandas join 3. matplotlib plots: Boxplot, Bar graph and stack bar chart

17th May Recording (158:22)
17th May File

1. Basic data analysis with iris dataset 2. Understanding imbalanced dataset

18th May Recording (156:01)
File

1. Balancing the dataset using Pandas 2. Power BI Introduction to Data Transformation and Visualizations

24th May Recording (153:43)
File

1. Power BI Visualization and Dashboards 2. Assignment

25th May Recording (160:21)
Files

1. Data Modelling 2. Data Transformation

31st May Recor ding (154:52)
File

1. DAX in Power BI

1st June Recording (152:59)
File

1. Python script to load data in Power BI 2. Python script to perform preprocessing in Power BI 3. Visualization using columns from different tables (related) 4. Introduction to Tableau

7th June Recording (151:56)
File

Power BI Slicers Power BI Filters Row Level Security in Power BI Introduction to Report Builder

8th June Recording (145:22)
File

1. Visualization using Tableau 2. Data preprocessing using Natural Language Processing (NLP)

14th June Recording (153:32)
File

1. Advanced Excel 2. Reading data from the Database into Python 3. Reading content of a JSON file into Python

15th June Recording (152:16)
File

21st June

21st June Recording (155:08)

1. Data cleaning using Pandas 2. Web scraping 3. Project on Data Cleaning 4. Additional practice questions on data cleaning

22nd June Recording (154:23)
File

28th June

28th June Recording (220:32)

1. Projects 2. Github 3. Doubt Discussion

29th June REcording (159:44)
File

1. Introduction to Machine Learning - Part 2 2. Data preprocessing: Missing values, Categorical values and Scalling

5th July Recording (157:49)

1. Data Cleaning for ML 2. ML Process 3. Simple Linear Regression

6th July Recording (160:06)
File

1. Multiple linear regression 2. Logistics regression 2a. Confusion matrix 3. ML projects

12th July REcording (158:45)
File

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock