Data Analytics course with Excel | Power BI | Python

Join for Live Class

Join Our Live Session and Group [No Vidoes]

00:00
All Resources Download Here ✅
Resource Collection Hub [No Video]

HelpDesk

Excel for Data Analysis

Excel Interface

04:47
Excel Typography

07:50
Excel Text Alignment

06:59
Clear

03:57
Cell Size

05:06
Find and Replace

04:08
Basic Arithemitic Formula

09:41
Arithmetics Operations

10:53
Sum, SumIF, SumIFS

12:21
if formula

03:19
IFS Formula

02:33
AND, OR Logical Formula

06:44
Excel Count Formulas

03:23
Excel String Manipulations

10:53
Excel Number Conversion

05:13
Goal Seek in Excel

05:53
Flashfill

05:03
conditional Formatting (Highlights Rules)

07:34
Conditional formatting (Top to Bottom Rules)

03:22
Conditional formatting (Data Bar)

03:42
conditional Formatting Color Scale

04:46
cells formatting

06:41
Advanced Filter in Excel

11:11
Advanced Unique formula in Excel

05:11
Simple Index Match Formuls in Excels

02:43
Multiple Criteria Index and Match

04:12
Advanced VLookUP in Excel

08:51
vlookup multiple tables

04:44
HlookUp formula in Excels

04:43
Advanced XLookUP Formula

05:37
Excel Vstack formula

04:06
Take and Drop Formula in Excel

06:02
Excel Choose formula

03:13
Excel torow, tocol formula

03:50
Sort, SortBy formula

05:33
textsplit Formula

04:39
Shape

05:46
shape styles

01:37
icons

05:25
Excel images

06:47
Equation and Symbols

05:09
Column Chart

09:20

Data Cleaning With Excel

power Query

get and transform data

13:30
power Query interface

06:48
Load and Connection Data

04:50
Manage Column

04:07
Reduce Rows

04:16
split column

05:48
Sorting

02:35
Group By

03:19
Replace Values

03:21
Data types

05:52
Transform Table

02:56
any column

04:21
Text Column

04:00
Number Column

04:20
date time column

02:29
merge and append queries

10:36
Manage Parameter

09:17
column from example

06:24
custom column

06:13

Power BI

All About Power Bi

08:30
Power BI download and installation

04:45
Power BI interface

08:14
Data connection and import

03:15
import Local Data using Power Bi

05:52
Canvas & Background

04:44
Page Navigation

05:12
power bi visualization

03:42
Power Bi Bar Chart

06:13
Bar chart Visualization

09:02
power Bi Table

05:07
Power Bi table Customization

07:41
power bi matrix

04:29
Power Bi Matrix Customization

05:51
Power Bi Pie Chart

09:31
Power Bi Donut Chart

03:42
Power bi Line chart

08:00
Power Bi Elements

07:02
Combo Chart

04:30
Power Bi slicer

05:07
Slicer Customization

07:26
Power Bi Card

06:27
Power Bi text Card

05:18
Multi Row Card

03:12
Gauge Chart

08:18
Data Modeling

03:27
Dax introduction

04:28
How to start DAX

04:48
Basic DAX Formula

05:00
Power Bi Filter

05:18
Calculate unique Data using filter

04:56
Calculated sum by multiple filter

04:55
CalculateTable using Filter

04:47
Decomposition tree

05:35

MySQL Database

introduction to SQL

08:53
How to Download Xampp 🟢

01:53
Create Drop Show Database

06:18
MySQL Create Table

06:58
Insert Into Table

06:53
MySQL Select

04:11
MySQL Distinct

03:38
where

04:31
MySQL Order By

04:36
MySQL Delete

03:30
SQL Operator

02:24
SQL OR

05:40
And operator

04:22
IN, Not IN

04:12
MySQL Group by

05:12
MySQL Between

04:17
Alter Update

04:51
Alter Rename

04:16
SQL Truncate

04:03
Alter Drop Column

04:07
SQL Comments

04:04
AS keyword

03:19
Aggregate Functions

09:42
Join Table

08:04
Left and Right Join

08:26

Python (Structure Programming- Basic)

Python (procedural Programming-Advanced)

Python (Structure Programming – Extreme)

Python (Object Oriented Programming)

Object & Class

11:47
Methods and Constructors

10:53
Types of constructor

13:26
instance variable and methods

08:00
Python Encapsulation

03:52
Private & Protected Members

06:17
Python Inheritance

09:32
Single , Multi-level, Hierarchical inheritance

09:50
Python Polymorphism

05:23
Methods overloading

06:34
Methods overriding

07:18

Python (Numpy)

NumPy Array Diclaration

09:03
Numpy Array Dimension

09:33
NumPy Array indexing & Slicing

11:55
Numpy Special Array

08:50
NumPy Data Types

12:10
NumPy Array Copy vs View

06:50
NumPy Array Shape

04:05
NumPy Array Iterating

11:28
NumPy Joining Array

11:28
NumPy Splitting Array

11:16
NumPy Searching Arrays

10:01
NumPy Sorting Arrays

10:50
Numpy Live Class

01:16:22

Python (Pandas (Basic)

Python (Pandas (Advanced))

Python (Matplotlib)

SQL Live Class ✅

SQL 6 May 2025

01:05:14
SQL 7 May 2025

43:40
SQL 12 May 2025

01:08:10
introduction to SQL

08:53
Database and Table

06:11
Multiple Regression

10:50
Scale

11:28
Train/Test

11:28
Decision Tree

11:55
Confusion Matrix

10:02

🟠 Projects

Special Live Class for All 🔥

Power Bi Full Dashboard Design Batch 11 (25 May 2025)

01:25:29
Data Collection and Data Cleaning Full Class ✅

49:27
Excel Special Class – (sum/sumif-Flashfill-Goal Seek- Text Formatting) ✅

01:16:58
Dashboard Design idea (pivot Table, VBA, Formatting, Searching) ✅

01:29:36
Dashboad Design Using Pivot table ✅

01:24:50
Excel Pivot Table Full Class 🔥

46:47
Python Pandas ✅

01:09:13
Excel Advanced (Lookup, Conditional Formatting, Filter, Consolidate) ✔️

01:19:21
introduction To Power Bi 🟠

51:04
Data Analysis Road Map 🔥

01:02:08
Data Cleaning using VBA and Manual 🔥

01:18:54
Excel Data Trasformation 🟢

59:36
understanding to Power Quary ✔️

01:02:53
Excel Filter 🟢

56:11
Power Bi full Class 2

56:00
Dashboard Design Using Power BI 🟠

45:20
Data Collecting and Transformation Using Power Query 🟠

46:25

1st Batch Special Live Class 🎯

2nd batch Special Live Class 🎯

3rd Batch Special Live Class 🎯

4th Batch Special Live Class 🎯 🎯

5th Batch Special Live Class 🎯🎯

6th Batch Special Live Class 🎯🎯

7th Batch Special Live Class 🎯

8th Batch Special Live Class 🎯

10 February 2025 (orientation)

01:00:32
15 February 2025

00:00
17 February 2025 (Projects)

01:20:47
19 February Power BI

59:45
24 February 2025

01:16:46
28 February 2025

01:25:59
14 March 2025

50:12
8 March (Theory)

37:39
16 March 2025

36:30
13 April 2025
15 April 2025

56:35
19 April 2025

37:40

What Will You Learn?

Course Content

Join for Live Class

Join Our Live Session and Group [No Vidoes]

All Resources Download Here ✅

Resource Collection Hub [No Video]

HelpDesk

Microsoft Office Activator

Excel for Data Analysis

Excel Interface

Excel Typography

Excel Text Alignment

Clear

Cell Size

Find and Replace

Basic Arithemitic Formula

Arithmetics Operations

Sum, SumIF, SumIFS

if formula

IFS Formula

AND, OR Logical Formula

Excel Count Formulas

Excel String Manipulations

Excel Number Conversion

Goal Seek in Excel

Flashfill

conditional Formatting (Highlights Rules)

Conditional formatting (Top to Bottom Rules)

Conditional formatting (Data Bar)

conditional Formatting Color Scale

cells formatting

Advanced Filter in Excel

Advanced Unique formula in Excel

Simple Index Match Formuls in Excels

Multiple Criteria Index and Match

Advanced VLookUP in Excel

vlookup multiple tables

HlookUp formula in Excels

Advanced XLookUP Formula

Excel Vstack formula

Take and Drop Formula in Excel

Excel Choose formula

Excel torow, tocol formula

Sort, SortBy formula

textsplit Formula

Shape

shape styles

icons

Excel images

Equation and Symbols

Column Chart

Data Cleaning With Excel

Data Cleaning Agenda

Remove Blank Data and Duplicate Data

Fix Data text formatting

Fix data text formatting

Flashfill and Convert text to column

Clean Data Table

power Query

get and transform data

power Query interface

Load and Connection Data

Manage Column

Reduce Rows

split column

Sorting

Group By

Replace Values

Data types

Transform Table

any column

Text Column

Number Column

date time column

merge and append queries

Manage Parameter

column from example

custom column

Power BI

All About Power Bi