Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete Data Analytics Course - CX 71
Introductory Session
Introductory Session by Palash (117:06)
Excel By Anoop Yadav
Data Set File
Session 1 -(22-07-2023) Introduction of EXCEL (161:10)
Session 2 -(23-07-2023) LOGICAL and Other Functions (155:34)
Session 3 -(29-07-2023) Aggregate functions (152:15)
Session 4 -(30-07-2023) Data Validation (159:36)
Session 5 - (05-08-2023)Dependent Validation (159:59)
Session 6 - (06-08-2023) Test Paper (158:22)
Session 7 - (12-08-2023)Other Formulas (150:03)
Session 8 - (13-08-2023) Excel Visuals and Dashboards (151:48)
EXCEL ASSIGNMENTS
Test Papers
Excel Test Paper
SQL By Anoop
Session 1 - (19-08-2023) Introduction of SQL (160:34)
Session 2 - (20-08-2023) CRUD Operations (188:39)
Session 3 - (26-08-2023) JOIN and Windows Functions(Dense and Rank) (185:58)
Session-4(27-08-2023) Stored Procedure (153:24)
Session - 5 (02-09-2023) Trigger (150:13)
Session - 6 (03-09-2023) Project (141:28)
SQL Assignments
POWER BI BY Anoop
Session 1 - (09-09-2023)Introduction of Power BI andBI (151:03)
Session-2(10-09-2023) ETL (143:05)
Session-3(16-09-2023) Append and Merge Queries (146:51)
Session-4(17-09-2023) Summary Dashboard (154:24)
Session-5(23-09-2023) DAX in Power BI (150:23)
Session-6(24-09-2023) Power BI Services (148:53)
Session-7(30-09-2023) Power BI AI (146:37)
Session-8 (01-10-2023) Project Discussion and Interview questions (150:12)
Tableau By Anoop Yadav
Session-1 (07-10-2023) (148:30)
Session-2(08-10-2023) (144:54)
Session-3(14-10-2023) (148:10)
Session-4(15-10-2023) (147:54)
CAPSTONE PROJECTS
EXCEL
SQL
POWER BI
Tableau
NOTES , REFERENCES , BOOKS , INTERVIEW QUESTIONS , PDFs , DOCS files
Excel
SQL
Power BI
Tableau
Python and Stats
INTERVIEW QUESTIONS
PPT Notes and Cheatsheets
PYTHON BY HITESH
Session-1(21-10-2023) Introduction to Python and DataTypes (176:41)
Session-2(22-10-2023) Datatypes and Operators (155:03)
Session-3(28-10-2023)Advanced Operators (135:00)
Session-4(29-10-2023) Control Statements and Iteration Statements (150:23)
Session-5(04-11-2023) While and For Loop (139:37)
Session-6(05-11-2023)Nested Loops( Pattern Programming) (158:56)
Session-7(18-11-2023) STRINGS and LIST (138:41)
Session-8(19-11-2023) Advanced_list , Tuples and Dictionaries (147:12)
Session-9(25-11-2023)Functions (135:02)
Session-10(26-11-2023) Functional_Programming and Sets (160:26)
Session-11(02-12-2023) Python Rock Paper Scissors and NUMPY (167:17)
Session-12(03-12-2023) Data Visualization with Matplotlib and Seaborn (136:39)
Session-13(03-12-2023) Statistics (134:03)
PYTHON NOTES
PROJECT SESSION (10-12-2023) STOCK MARKET ANALYSIS (139:37)
PYTHON CAPSTONE PROJECTS
PYTHON MEGA PROJECT
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)
GITHUB PROFILE CREATION BY HITESH
GitHub Session (15-05-2023) (79:02)
GitHub Session (16-05-2023) (74:50)
GitHub Session(17-05-2023) (56:19)
RESUME SESSION BY PALASH
Resume Session (134:40)
ChatGPT Master Class
Session 2 (11-2-2024) (98:27)
Session 1 (10-2-2024) (141:15)
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
Session 3 - (26-08-2023) JOIN and Windows Functions(Dense and Rank)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock