Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete Data Analytics Course - CX 70
Introductory Session
Syllabus
Session-1(25-06-2023) Introductory Session (114:31)
EXCEL COURSE
DATA SET FILE
Session-1(01-07-2023) Introduction of Excel and OverViews of Excel (189:33)
Session-2(02-07-2023)Conditionals and VLOOKUP (184:40)
Session-3(08-07-2023) Subtotal and Validation Conditions (170:28)
Session-4(09-07-2023) Macros and Analytics Session (133:36)
Session-5(15-07-2023)Dependent and Data Validation (172:33)
Session-6(16-07-2023) SOLVER AND CHARTS (150:22)
EXCEL ASSIGNMENTS
CAPSTONE PROJECTS
EXCEL
SQL
TABLEAU
POWER BI
SQL Course
Session-1(22-07-2023) Introduction of SQL (206:16)
Session-2(23-07-2023) CREATE DATABASE AND INSERT CMD (226:20)
Session-3(29-07-2023) ACID Properties (203:39)
Session-4(30-07-2023) ALTER and UPDATE (200:04)
Session-5(05-08-2023)INDEX and VIEW Page (193:24)
Session-6(06-08-2023) JOINS (194:17)
Session-7(12-08-2023)SQL INJECTION (208:04)
Session-8(13-08-2023)SQL Project (210:54)
SQL ASSIGNMENTS
NOTES || INTERVIEW QUESTIONS || PDFS || REFERENCE BOOKS
Excel Notes
SQL Notes
INTERVIEW QUESTIONS
Tableau Notes
Python and Stats
Python lec Code by Hitesh
PPT Notes and Cheatsheets
TABLEAU BY ANOOP
SESSION 1 - (19-08-2023) Introduction (158:22)
Session-2(20-08-2023) Some Charts (163:28)
Session-3(26-08-2023) Advanced Charts (159:12)
Session-4(27-08-2023)Advanced Visuals (145:19)
Session-5(02-09-2023)Query Language (145:55)
Session-6(03-09-2023) Functions (160:23)
Session-7(09-09-2023) (164:26)
DATA Files
Session-8(10-09-2023) (136:22)
Tableau Project Files
Session-9(16-09-2023) (143:27)
Power BI by Anoop Yadav
Datasets File
Session-1(17-09-2023) Introduction to Power BI (143:49)
Session-2(23-09-2023) Transformation Query (156:13)
Session-3(24-09-2023) Summary Dashboards (154:56)
Session-4(30-09-2023)Transformation Query (169:57)
Session-5(1-10-2023) Graphs (159:46)
Session-6 (07-10-2023) (199:15)
Session-7 (08-10-2023) (156:43)
PYTHON SESSION BY HITESH
Session(15-10-2023) GIT AND GITHUB (307:14)
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 Game (Rock Paper and 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
MEGA PROJECTS
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)
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-4(30-07-2023) ALTER and UPDATE
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock