Autoplay
Autocomplete
Previous Lesson
Complete and Continue
CX-62-Mor-Mar
Introduction
Syllabus for Data Analytics/Data Science
Introductory Session (163:15)
Resume Samples
Software Tools Downloading Session
MS- EXCEL || Power BI || SQL Server || SSMS || Tableau Desktop and Public Downloading Guide (22:10)
Excel Module
Session-1(04-03-2023) (Introduction to Excel and Absolute and Relative Reference) (194:39)
Session-2(05-03-2023) (Mixed Reference , Header and Footer , HyperLink) (201:25)
Session-1 (11-03-2023) (Protect and Aggregated Functions) (160:48)
Session-2(12-03-2023)(Conditional Formatting , Data Validation , and Other Operations) (164:01)
Session-3(18-03-2023) (Statistical functions and LOOKUP Formulas) (191:36)
Session-4(19-03-2023)(Pivot Table , Visualization and Charts ,) (166:05)
EXCEL ASSIGNMENTS
Power BI Module
Session-1(25-03-2023)(Introduction and Installation) (159:49)
Session-2(26-03-2023) Power Query (148:19)
Session-3(01-04-2023) Power Query - Merged and Append Queries (145:21)
Session-4(02-04-2023) (Dashboard -1) (144:24)
Session-5(08-04-2023) Toggle Activity and BookMarks (147:53)
Session-6(09-04-2023) (DAX - Related and Related Table) (128:20)
Session-7(15-04-2023) AI Visuals in Power BI (145:54)
Session-8(16-04-2023) Power Query transformations (87:56)
Interview Preparation Session by Palash Sir
Session by Palash Sir (146:06)
Python Module
Session-1(22-04-2023) Introduction and Installation of Python (203:29)
Session-2(23-04-2023) (DataTypes , Variables Basics) (197:22)
Session-3(29-04-2023) String and List (208:54)
Session-4(30-04-2023) Advanced List and Tuples (205:25)
Session-5(06-05-2023) Tuples Slicing (215:25)
Session-6(07-05-2023) If_Else and Nested Tuples (190:39)
Session-7 (13-05-2023) While Loop (216:16)
Session-8(14-05-2023) (For Loop) (181:27)
Session-9(20-05-2023) While Loop (176:41)
Python Notes by Anjali Mam
Session-10(21-05-2023) Strings (200:22)
Session-11(27-05-2023) Functions (214:40)
Session-12(28-05-2023) Advance Functions and Exception Handling (211:26)
Session-13(03-06-2023) Statistics (197:56)
Session-14(04-06-2023) Pandas (187:55)
Session-15(10-06-2023) Matplotlib (181:10)
Session-16(11-06-2023) Seaborn and Encodings (184:40)
Session-17(17-06-2023)Projects (194:52)
ALL CODES AND FILES by Anajali Mam
Session-18(18-06-2023) Projects (176:25)
Assignments and Code by Anjali mam
ASSIGNMENTS
POWER BI
Capstone Projects
Excel
SQL
Python
Power BI
TABLEAU
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)
Statistics with Python By Hitesh
Statistics-1(03-06-2023) (209:55)
Project Session in Data Preprocessing by Hitesh (04-06-2023) (199:02)
NOTES || PPTS || INTERVIEW QUESTIONS || and Other things
Excel Notes
SQL Notes
Power BI Notes
Interview Questions
SQL Practice Queries
Statistics Notes
Python Assignments by Hitesh
CHEATSHEETS
SQL By Hitesh
Session - 1( 24-06-2023) Introduction to SQL , Databases (111:05)
Session-2(25-06-2023) CREATE TABLE , Datawarehouse (137:42)
Session-3(1-07-2023) CREATE AND INSERT STATEMENTS (167:00)
Session-4(2-07-2023) Data Manipulations and Data Query (180:28)
Session-5(08-07-2023) SQL JOINS and VIEWS and FUNCTIONS AND GROUP BY ORDER BY (145:32)
Session-6(09-07-2023) Subquery ,Stored Procedures(SP) ,TRIGGERS (157:53)
Session-7(15-07-2023) SQL INDEX , SQL Functions , Operators (147:42)
Session-8(16-07-2023) SQL INJECTION , DYNAMIC QUERIES ,NORMALIZATION , AZURE DATA STUDIO AND PROJECTS (148:39)
SQL ASSIGNMENTS
SQL CAPSTONE PROJECTS
Python By Vrushali
DATA
Session-1(15-07-2023) Introduction of Python (167:25)
Session-2(16-07-2023) Datatypes and Variables (169:56)
Session-3(22-07-2023) Data Structures (104:27)
Session-4 (23-07-2023) Slicing (181:38)
Session-5 (29-07-2023) Conditional Statements (198:42)
Session-6 (30-07-2023)LOOPS and functions (160:40)
Session-7 (05-08-2023)Functions (208:03)
Session-8 (06-08-2023) Project Calculator (157:52)
Session-9 (12-08-2023) (173:58)
Session-10 (13-08-2023) (153:11)
Session-11 (19-08-2023) (162:10)
Session-12 (20-08-2023) (214:00)
Session-13- (26-08-2023) (158:01)
Session-14(27-08-2023) (106:38)
Tableau By Bidhan
Session 1 - (22-07-2023) Introduction to tableau (138:40)
Session 2 - (23-07-2023) BARS and MAPS (124:13)
Session 3 - (29-07-2023)FILTERS (142:37)
Session 4 - (30-07-2023)FILTERS on Charts (127:07)
Session 5 - (05-08-2023)ADVANCED CHARTS (151:32)
Session 6 - (12-08-2023) (138:44)
Resume Guidance Session
Session on 13-08-2023 (134:37)
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-8(16-04-2023) Power Query transformations
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock