Files

Cohort 142 - (Da/Ds/GenAI - AT)

Link and Passcode & Updates Section

Cohort 142 - Link & Passcode

Introduction to Data Science

8th February Recording (163:17)
Files

Analytics Theory - Introduction to Excel Basic - Time Functions - Basic and Statistical Functions

14th February Recording (157:17)
Files

TEXT related Function in Excel - LOOKUP - VLOOKUP - HLOOKUP - XLOOKUP

15th February Recording Part-1 (36:43)
15th February Recording Part-2 (6:32)
15th February Recording Part-3 (7:06)
15th February Recording Part-4 (114:05)
Files
Assignment

21st February

21st February Recording (7:54)

- Excel Shortcuts - Pivot Table - Data Analysis using Pivot Table - Pivot Charts - Report Building and filters in Pivot - Correlation

28th February Recording (165:32)
Files

Regression - Moving Average - Descriptive Stats - Overview of Data - Types and Forms of Data - Descriptive Statistics

1st March Recording Part-1 (56:45)
1st March Recording Part-2 (10:46)
1st March Recording Part-3 (112:50)
Files
Assignment

What if Analysis - Goal Seek and Scenario Manager - Power Query - Transformations in Power Query

8th March Recording (148:04)
Files

Joins in Power Query - Live Data Connection in Excel - Mode, Variance, Standard Deviation - Skewness, Kurtosis, Range, Coefficient of Range

14th March Recording (166:21)
Files

Correlation (Pearson and Spearman) - Co-Variance - Squared Error - Mean Squared Error, RMSE, MAD - Inferential statistics - Sample and Population - Sampling Methods - Hypothesis Testing

15th March Recording (153:58)
Files

t-test - chi-square test, anova - p-value, critical tables - confidence interval - probability distributions - Introduction to Programming - Python Installations

21st March Recording (161:47)
Files

Keywords in Python - Variable declaration - Rules to write name of Variable - Data Types in Python - Operators in Python - Arithmetic Operators - Comparison Operators - Logical Operators - Assignment Operators

22nd March Recording (171:38)
Files

28th March

28th March Recording (173:08)
Files

Nested if statements - while and for loop - range function - Nested loops - pass - break - continue

29th March Recording (164:53)
Files
Assignment

4th April

4th April Recording (171:40)

5th April

5th April Recording (171:51)

Files

Lesson content locked

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

Enroll in Course to Unlock