Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete Data Analytics Course - CX 65
First Section
Introductory Session (155:38)
Sample Resumes
Excel Module
Session-1(29-04-2023) Introduction of Excel and Some Formulas (167:04)
Session-2(30-04-2023) Aggregate Functions (178:02)
Session-3(06-05-2023) Data Validation , Other Functions (161:29)
Session-4(07-05-2023) LOOKUP Functions (173:53)
Session-5(13-05-2023) (Pivot Tables and Offeset Functions) (157:59)
Session-6(20-05-2023) (Power Query and Dashboards ) (159:35)
Session-7(21-05-2023) Dashboards Creation (99:34)
EXCEL ASSIGNMENTS
CAPSTONE PROJECTS
Excel
Statistics
SQL
Power BI
PYTHON PROJECT
MEGA PROJECTS
TABLEAU PROJECT
SQL Session by Ruchika Mam
Session-1(14-05-2023) ( SQL Installation) (122:46)
Session-2(27-05-2023) (Introduction to SQL Server) (146:15)
Session-3(28-05-2023) DELETE and TRUNCATE (170:31)
Session-4(03-06-2023) Joins (339:35)
Session-4(04-06-2023) Distinct , Group BY and Order By (165:54)
Session -5(10-06-2023) Views and Subqueries (161:02)
Session-6(11-06-2023) Functions (139:01)
SQL Assignments by Hitesh
TABLEAU By RUCHIKA Mam
Session-1(17-06-2023) Tableau Introduction and Datawarehouse Concepts (142:17)
Session-2(18-06-2023) Charts (95:54)
Session-3(23-06-2023) Hierarchy and Annotations (156:26)
Session-4(24-06-2023) Other Visual (120:28)
Session-5(01-07-2023)Data joining and Data Binding (160:13)
Session-6(02-07-2023) Advanced Charts (153:07)
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)
NOTES , PPTS , Interview Questions , and etc
Excel Notes
SQL Notes
SQL Practice Queries
Power BI Notes
Statistics Notes
Tableau Notes
Python Notes
Reference Books
Python Codes by Hitesh
POWER BI by RUCHIKA MAM
Session-1(08-07-2023) Introduction to Power BI (165:15)
Session-2(09-07-2023) Transformation Query (163:28)
Session-3(15-07-2023) Sales Dashboard (156:01)
Session-4(16-07-2023) Merges Queries and Append Queries (168:03)
Session-5(22-07-2023) DAX-1 (156:49)
Session-6(23-07-2023)DAX-2 (149:34)
Session-7(29-07-2023) Enlighten Aquarium (101:00)
Session - 8 (04-08-2023) EDA Analysis Using Power BI (157:31)
PYTHON BY MADHU
Session-1(05-08-2023) Introduction to Python (160:33)
Session-2(06-08-2023) (165:38)
Session-3(12-08-2023) (139:47)
Session - 4 (17-08-2023) (107:56)
Session-5(19-08-2023) (170:05)
Session-6(20-08-2023) (158:56)
Session-7(26-08-2023) (155:52)
Session-8(27-08-2023) (157:15)
Session-9(02-09-2023) (169:49)
Session-10(03-09-2023 (174:41)
Session-11(09-09-2023) (168:19)
Session-12(16-09-2023) (171:36)
STATISTICS BY HITESH
Statistics Session (209:56)
Project Session on Analysis Project (199:03)
Python
RESUME GUIDANCE SESSION
Resume Session (142:15)
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 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-1(14-05-2023) ( SQL Installation)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock