Skip to main content
Main menu
Includes navigation links and user settings
Browse products
Sign up
Log in
Cohort 132 - (Da/Ds/GenAi/AI - AT)
₹100,000
one-time purchase
Buy now
Course content
17 sections | 34 lessons
Expand all sections
link. passcode and updates section
1 Lessons
Orientation Call & Basics of Data Analytics/Science
2 Lessons
31st August
3 Lessons
- Loading Data from txt files to Excel - Text to columns (different delimiters) - ADDRESS Function - VLOOKUP - HLOOKUP
2 Lessons
- LOOKUP - XLOOKUP - Creating Pivot Table - Creating Reports via Pivot - Basics about Charts in Excel
2 Lessons
- Report Building And Filters in Pivot - Pivot Charts - Data Analysis - Correlation - Regression
2 Lessons
- Co-Variance - Moving Average - Descriptive Stats - Goal Seek
2 Lessons
- Scenario Manager - Introduction to Power Query tool - Walk through Power Query - Importing data and transformations using Power Query
2 Lessons
- Add column options - Merging Queries - Appending Queries - Load data from live website - Introduction to type of data - Descriptive stats
2 Lessons
- Mean, Median, Mode - Variance, Standard Deviation - Skewness - Kurtosis - Range, Quantiles - Population and Sample - Hypothesis Testing
2 Lessons
- t -test - Tables and Critical Value - Probability Distributions - Z-score - Introduction to Python Programming - Python Installation
2 Lessons
- Basics of Python Coding - Variables in Python - Basic data types - Arithmetic Operator - Comparison Operator - Logical Operators
2 Lessons
- Bitwise Operators - Membership Operators - Identity Operator - Control Flow Statements - IF, ELIF, ELSE, Nested IF
2 Lessons
While and For Loop - Range Function - Break, Continue and Pass statements - Indexing in Python (positive and negative) - Introduction to String data type
2 Lessons
String practice with different methods - List practice with different methods
2 Lessons
- Finished List - Finished Tuple - Started with set
2 Lessons
- Finished Set - Finished Dictionary - Built-In Functions - Lambda Functions - User Defined Functions - args and **kwargs
2 Lessons
