Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete Data Analytics Course - CX 73
Syllabus
DATA ANALYTICS
BUSINESS ANALYTICS
DATA SCIENCE
Introductory Session
Introduction Session by Vrushali Mam (138:05)
REQUIREMENT ANALYSIS BY KANCHAN
Session 1 - (19-08-2023) Requirement and Elicitation (128:13)
EXCEL BY KANCHAN
DATA SET FILES
Session 1 - (20-08-2023) Excel Introduction (196:31)
Session 2 - (26-08-2023) Home Tab Functions (162:22)
Session-3(27-08-2023)Conditional Formatting (181:18)
Session-4(02-09-2023) Data Validation (170:28)
Session-5 (03-09-2023) VLOOKUP (164:40)
Session-6 (09-09-2023) PIVOT CHARTS (181:00)
Session-7(10-09-2023) Dashboard (163:01)
EXCEL Notes
EXCEL ASSIGNMENTS
SQL BY RUCHIKA
Session-1(16-09-2023)Introduction to SQL and Databases (196:01)
Session-2(17-09-2023) CREATE AND INSERT STATEMENTS (192:58)
Session-3(23-09-2023) Operators (189:06)
Session-4(24-09-2023) JOINS (177:38)
Session-5(30-09-2023) SQL SET Operators, SQL Execution Order, VIEWS in SQL (178:23)
Session-6 (01-10-2023) TCL, DCL, Sub Queries (182:24)
Session-7 (07-10-2023) Stored Procedure and Advanced Functions in SQL (161:22)
Session-8 (8-10-2023) LEAD, LAG and SQL Triggers (178:41)
SQL ASSIGNMENTS
SQL NOTES
POWER BI BY RUCHIKA
Introduction to Power BI(14-10-2023) (202:08)
Power Query Editor in Power BI(15-10-2023) (178:17)
Data Modelling in Power BI (21-10-2023) (189:54)
Creating Visualisations in Power BI(22-10-2023) (210:55)
Creating a Dashboard in Power BI(28-10-2023) (178:52)
Creating a Dashboard in Power BI part-2 (29-10-2023) (188:40)
Introduction to DAX in Power BI (04-11-2023) (196:52)
Advanced DAX in Power BI(05-11-2023) (182:59)
EDA Analysis Using Power BI (02-12-2023) (172:32)
POWER BI NOTES
Tableau by Ruchika
Introduction to Tableau and Tableau Public (18-11-2023) (169:19)
Creating Visualisations in Tableau (19-11-2023) (172:12)
Map Visuals in Tableau (25-11-2023) (169:46)
Report Creation in Tableau (26-11-2023) (180:54)
PYTHON SECTION BY HITESH
Session-1(09-12-2023) Introduction to Python (111:45)
Session-2(10-12-2023) GITHUB SESSION (102:28)
Session-3(16-12-2023) DATA TYPE In Python (119:53)
Session-4(17-12-2023) Operators in Python (136:25)
Session-5(23-12-2023) Control_Statements(if , else and elif) (112:30)
Session-6(24-12-2023) Looping Statements (WHILE LOOP) (121:35)
Session-7(30-12-2023) FOR LOOP (122:53)
Session-8(31-12-2023) STRINGS (108:25)
Session-9(06-1-2024) LIST (120:11)
Session-10(07-01-2024) Tuples (103:59)
Session-11(13-01-2024)Dictionary (99:25)
Session-12(14-01-2024) SETS (87:59)
Session-13(20-01-2024) TEST (107:31)
Session-14 (21-01-2024) FUNCTIONS (87:10)
Session-15(27-01-2024) Advanced Functions (88:19)
Session-16(28-01-2024) TEST ON SQL (86:57)
Session-17(03-02-2024) EXCEPTION HANDLING / Modules (78:40)
Session-18(03-02-2024) PYTHON SMALL PROJECT (73:49)
Session-19(10-02-2024) Python-OOPs(Part-1) ( Concepts like Class and Object , Inheritance)) (104:08)
Session-20(11-02-2024) Python-OOPS(Part-2) (Concepts like Advanced Inheritance and Polymorphism) (113:19)
Session-21(18-02-2024) Python-OOPs(Part-3) (Concepts like Encapsulation) (92:49)
Session-22(24-02-2024) Statistics-Part-1 (87:30)
Session-23(25-04-2024) Statistics -Part-2(Descriptive Statistics) (76:01)
Session-24(02-03-2024) Statistics-Part-3(Inferential Statistics) (35:13)
Session-25(03-03-2024) Statistics Part-4(Inferential Statistics-Hypothesis Testing) (99:06)
Session-26(09-03-2024) EDA(Part-1-Intro) (44:23)
Session-27(10-03-2024) EDA(Part-2-Numpy) (136:25)
Session-28(16-03-2024) EDA(Part-3- Pandas , Matplotlib , Seaborn) (119:21)
Session-29(17-03-2024) EDA(Part-4- Project on Stock Market Analysis) (126:43)
PYTHON ASSIGNMENTS
Excel Project Overview
Project Explanation Session for Excel (9:11)
RESUME SESSION BY PALASH
Resume Session (134:40)
CAPSTONE PROJECTS
EXCEL Project
SQL Project
Power BI Projects
Tableau
Python Projects
INTERVIEW QUESTIONS
INTERVIEW QUESTIONS
PPT Notes and Cheatsheets
Advance Excel by Anoop Yadav- VBA and Macros
Session-1 (11-11-2023) (158:50)
Session-2(12-11-2023) (130:49)
Session-3(16-11-2023) (110:38)
Session-4(20-11-2023) (78:25)
CHATGPT SESSION
Session-1(23-03-2024) (294:42)
Session-2(24-03-2024) (109:09)
Introduction to Cloud and Azure by Vikas
Session-1 (30-03-2024) (175:06)
Session-2 (31-03-2024) (168:03)
SQL Masterclass by Ruchika
Session-1 (11-06-2024) (154:44)
Session-2 (12-06-2024) (155:25)
Session-3 (13-06-2024) (155:35)
Data Set Files , Interview Questions and Projects By Ruchika
Solutions For projects and Assignments
SQL
EXCEL
Introduction to Machine Learning By Sourav
Session 1 - (12-04-2025) - Introduction to Machine Learning (84:35)
Session 2- (13-04-2025) -Titanic - Machine Learning from Disaster (79:21)
Session-25(03-03-2024) Statistics Part-4(Inferential Statistics-Hypothesis Testing)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock