Skip to main content
Main menu
Includes navigation links and user settings
Browse products
Sign up
Log in
Cohort 136 - (Da/Ds/GenAI/AI - SS)
Course content
31 sections | 63 lessons
Expand all sections
Batch link. passcode and updates section
1 Lessons
Introduction to data analytics/science & Python Installation
2 Lessons
1. Python and IDE installation 2. Introduction to Excel
2 Lessons
Analytics using Excel
2 Lessons
1. Excel advanced formulae - class project completions 2. Python: variables, mathematical operations, basic data types, type(), format string
2 Lessons
1. Relational operators 2. Logical operators 3. functions: input(), int(), range() 4. conditions: if, elif, else 5. introduction to for loop
2 Lessons
1. Conditions: Practice Programs 2. Loops: For loop, Nested For loop and While loop
2 Lessons
1. For loop 2. While Loop 3. match-case 4. Mini Project
2 Lessons
* String declaration * String Operations * indexing * string methods Introduction to List
2 Lessons
1. List 2. Tuple 3. Dictionary. 4. Exercises in Lists and Dictionary 5. Assignment 2 (Python -1)
2 Lessons
1. Sets in Python 2. Function tutorial: Arguments (Required, Default, Positional, Keyword, variable length), Return type, doc string 3. Modules
2 Lessons
1. Practice functions in Python 2. Class and objects in Python
3 Lessons
1. PIVOT in excel 2. LAMBDA functions 3. Map(), Filter(), Reduce() in Python lists 4. Exception handling in Python
2 Lessons
1. File Handling in Python 2. Introduction to Database, RDBMS 3. Keys in Database 4. Relationships 5. MYSQL Installation
2 Lessons
SQL Commands * CREATE , DROP Table in SQL
2 Lessons
SQL tutorial * Insert , Update, Truncate * Select session 1
2 Lessons
1. SELECT Commands in SQL - session 2 2. INDEX, VIEWS and TEMPORARY TABLES IN MYSQL
2 Lessons
1. Stored Procedures in MYSQL 2. Statistics: Types of data, Descriptive statistics, Handing data
2 Lessons
1. Statistics- Managing Numerical v Numerical and Categorical v Categorical data analysis
2 Lessons
1. Categorical v Numerical 2. Boxplot 3. ANOVA 4. Quartile, Percentile 5. Identifying Outliers
2 Lessons
Numpy Session 1
3 Lessons
1. Numpy tutorial 2. Pandas basic tutorial 3. matplotlib tutorial
2 Lessons
1. Advanced Pandas discussions with lab 2. Mini Project for Data Analytics 3. Projects for Home Work
3 Lessons
1. Handling missing values using Python (mini project)
2 Lessons
8th February
1 Lessons
1. Power BI Data Analytics Process 2. Data processing steps
2 Lessons
Data Transformation in Power BI
2 Lessons
* Data transformation - 2 * Basic Visualization
2 Lessons
1. Power BI Visualization and editing the various properties 2. Data Modelling 3. Basic DAX operations
2 Lessons
1. Advanced visualization in Power BI 2. Advanced DAX 3. Introduction to Machine Learning
2 Lessons
1. Introduction Machine Learning, examples and life cycle 2. Understanding Data cleaning
2 Lessons
₹100,000
one-time purchase
Buy now
