4.85
(66 Ratings)
Data Analytics course with Excel | Power BI | Python | SQL
Categories: Development, Programming Language
What Will You Learn?
- Numpy
- Matplotlib & Seaborn
- Power BI
- Pandas & SQL
- Python Programming Language
Course Content
Join for Live Class
-
Join Our Live Session and Group [No Vidoes]
00:00 -
All Resources Download Here ✅
-
Resource Collection Hub [No Video]
HelpDesk
-
Microsoft Office Activator
05:27
Excel for Data Analysis
-
Excel Interface
04:48 -
Excel Typography
07:50 -
Excel Text Alignment
06:59 -
Clear
03:58 -
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:12 -
Goal Seek in Excel
05:53 -
Flashfill
05:03 -
conditional Formatting (Highlights Rules)
07:35 -
Conditional formatting (Top to Bottom Rules)
03:23 -
Conditional formatting (Data Bar)
03:42 -
conditional Formatting Color Scale
04:46 -
cells formatting
06:41 -
Advanced Filter in Excel
11:12 -
Advanced Unique formula in Excel
05:12 -
Simple Index Match Formuls in Excels
02:44 -
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:03 -
Excel Choose formula
03:13 -
Excel torow, tocol formula
03:51 -
Sort, SortBy formula
05:34 -
textsplit Formula
04:38 -
Shape
05:46 -
shape styles
01:37 -
icons
05:25 -
Excel images
06:48 -
Equation and Symbols
05:09 -
Column Chart
09:20
Data Cleaning With Excel
-
Data Cleaning Agenda
02:03 -
Remove Blank Data and Duplicate Data
08:08 -
Fix Data text formatting
10:36 -
Fix data text formatting
05:19 -
Flashfill and Convert text to column
07:01 -
Clean Data Table
04:47
power Query
-
get and transform data
13:30 -
power Query interface
06:48 -
Load and Connection Data
04:50 -
Manage Column
04:08 -
Reduce Rows
04:16 -
split column
05:47 -
Sorting
02:35 -
Group By
03:19 -
Replace Values
03:22 -
Data types
05:52 -
Transform Table
02:57 -
any column
04:21 -
Text Column
04:01 -
Number Column
04:20 -
date time column
02:30 -
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:14 -
Bar chart Visualization
09:02 -
power Bi Table
05:07 -
Power Bi table Customization
07:42 -
power bi matrix
04:29 -
Power Bi Matrix Customization
05:51 -
Power Bi Pie Chart
09:31 -
Power Bi Donut Chart
03:41 -
Power bi Line chart
08:00 -
Power Bi Elements
07:02 -
Combo Chart
04:30 -
Power Bi slicer
05:06 -
Slicer Customization
07:26 -
Power Bi Card
06:28 -
Power Bi text Card
05:18 -
Multi Row Card
03:12 -
Gauge Chart
08:18 -
Data Modeling
03:27 -
Dax introduction
04:27 -
How to start DAX
04:48 -
Basic DAX Formula
05:01 -
Power Bi Filter
05:19 -
Calculate unique Data using filter
04:55 -
Calculated sum by multiple filter
04:54 -
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:52 -
MySQL Select
04:11 -
MySQL Distinct
03:38 -
where
04:31 -
MySQL Order By
04:36 -
MySQL Delete
03:30 -
MySQL Drop Table
11:16 -
SQL Operator
02:24 -
SQL OR
05:40 -
And operator
04:22 -
IN, Not IN
04:12 -
MySQL Limit
11:56 -
MySQL Group by
05:12 -
MySQL Between
04:17 -
Alter Update
04:51 -
Alter Rename
04:16 -
SQL Truncate
04:04 -
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 -
MySQL Update Table
10:01
1st Batch Special Live Class 🎯
-
Orientation
01:16:58 -
Class 01
01:24:51 -
Class 02
01:29:36 -
Class 03
46:46 -
Class 04
01:10:26 -
Class 05
01:09:13 -
Class 06
01:19:21 -
Class 07
01:19:21 -
Class 08
51:04
2nd batch Special Live Class 🎯
-
Class 01
01:02:08 -
Class 02
01:18:55 -
Class 03
59:37 -
Class 04
01:02:53 -
Class 05
56:11 -
Class 06
01:19:21 -
Class 07
01:19:21 -
Class 08
51:04
3rd Batch Special Live Class 🎯
-
Class 01
47:39 -
Class 02
56:01 -
Class 03
58:47 -
Class 04
45:20
4th Batch Special Live Class 🎯 🎯
-
Class 01
01:03:33 -
Class 02
46:26 -
Class 03
01:01:51 -
Oct 26 2024
01:01:50 -
Nov 4 2024
01:06:05 -
Nov 8, 2024
01:04:35
5th Batch Special Live Class 🎯🎯
-
Nov 16, 2024
54:03 -
Nov 18, 2024
01:04:36 -
Nov 22, 2024
01:02:16 -
Nov 25, 2024
01:14:35 -
Nov 30, 2024
01:20:07 -
13 December 2024
42:29 -
Data Analysis with python (20 December 2024)
01:26:58 -
Python Sequence Data type (24 December 2024)
01:11:38 -
Python OOP-1 (28 December 2024)
01:07:24
6th Batch Special Live Class 🎯🎯
-
Orientation (16 December 2024)
01:23:28 -
Python Sequence Data type (24 December 2024)
01:11:38 -
Python OOP-1 (28 December 2024)
01:07:25
7th Batch Special Live Class 🎯
-
20 January 2025
01:08:20 -
17 January 2025
01:04:30 -
28 January 2025
56:41 -
10 February [Power Bi 1]
40:32 -
14 April 2025
16:24 -
21 April 2025
8th Batch Special Live Class 🎯
-
10 February 2025 (orientation)
01:00:33 -
15 February 2025
00:00 -
17 February 2025 (Projects)
01:20:47 -
19 February Power BI
59:44 -
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:31 -
13 April 2025
-
15 April 2025
56:35 -
19 April 2025
37:40
9th Batch special Live Class 🎯
-
27 February 2025 (orientation)
01:39:41 -
9 March 2024 (Theory)
41:15 -
11 March 2025 (Data Collection & Cleaning)
49:27 -
13 April 2025
48:22 -
15 April 2025
56:36 -
19 April 2025
37:40
10th Batch Special Live Class 🎯
-
13 April 2025
48:22 -
19 April 2025
37:40
Part 01 (Structure Programming- Basic)
-
introduction to Python Programming Language
12:13 -
input , Output & Comments
22:25 -
Python Data types & Variables
24:23 -
Variable & Data Structures
27:06 -
Operator Part 01
27:30 -
Operators Part 02
19:25 -
if else statements
15:08 -
Loop Part 01
25:41 -
Loop Part 02
20:50
Part 02 (procedural Programming-Advanced)
-
string declaration & string indexing slicing
26:01 -
String formatting & Modify
17:05 -
string state checking & Operators
15:22 -
List Declaration & indexing slicing
16:05 -
List Methods & Operators
20:23 -
Python Tuple
11:03 -
Python sets
26:54 -
Python Dictionary
19:20
Part 03 (Structure Programming – Extreme)
-
function Parameter & Arguments
14:13 -
function keyword agruments
17:30 -
Anonymus Function
14:17 -
Python Methods
14:28 -
Python Methods and function
14:29
Part 04: 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:53 -
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:17
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:02 -
NumPy Sorting Arrays
10:51 -
Numpy Live Class
01:16:22
Pandas (Basic)
-
introduction to Pandas
02:07 -
Pandas Getting Started
03:40 -
Pandas Series
05:31 -
Data Frame using Dictionary
05:25 -
Data Frame using list
03:57 -
Read CSV Excel or any files using Pandas
06:16 -
File Save using Pandas
03:49
Pandas (Advanced)
-
Pandas – Analyzing DataFrames
10:51 -
Pandas – Cleaning Data
11:56 -
Pandas – Cleaning Empty Cells
11:28 -
Cleaning Data of Wrong Format
11:28 -
Fixing Wrong Data
11:16 -
Removing Duplicates
11:16 -
Data Correlations
10:51
Matplotlib
-
Matplotlib Tutorial
10:43 -
Matplotlib Markers
16:26 -
Matplotlib Line
10:34 -
Matplotlib Labels, Title and grid
04:06 -
Matplotlib Subplot
10:51 -
Matplotlib Scatter
11:56 -
Matplotlib Bars
05:39 -
Matplotlib Histograms
10:02 -
Matplotlib Pie Charts
11:28
SQL Live Class ✅
-
SQL 6 May 2025
01:05:14 -
SQL 7 May 2025
43:40 -
SQL 12 May 2025
01:08:11 -
introduction to SQL
08:53 -
Database and Table
06:11 -
Multiple Regression
10:51 -
Scale
11:28 -
Train/Test
11:28 -
Decision Tree
11:56 -
Confusion Matrix
10:02
Part 13: Projects
-
Hierarchical Clustering
10:50 -
Logistic Regression
11:56 -
K-means
11:28 -
ootstrap Aggregation (Bagging)
11:16 -
Cross Validation
10:02 -
AUC – ROC Curve
11:56 -
K-nearest neighbors (KNN)
11:15
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:51 -
Excel Pivot Table Full Class 🔥
46:46 -
Python Pandas ✅
01:09:12 -
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:55 -
Excel Data Trasformation 🟢
59:37 -
understanding to Power Quary ✔️
01:02:53 -
Excel Filter 🟢
56:11 -
Power Bi full Class 2
56:01 -
Dashboard Design Using Power BI 🟠
45:20 -
Data Collecting and Transformation Using Power Query 🟠
46:26
11th Special Live Class 🟠
-
Power Bi Full Dashboard Design Batch 11 (25 May 2025)
01:25:28 -
power Query 21 June 2025
47:25
12th & 13th Special Live class 🟠
-
20 June 2025
01:11:23 -
23 june 2025
48:44
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
4.9
Total 66 Ratings
5
58 Ratings
4
6 Ratings
3
2 Ratings
2
0 Rating
1
0 Rating
It was a nice course for data analyst.
I recently completed a Data Analytics course, and it was a highly valuable experience. The course covered Excel, SQL, data cleaning, and dashboard creation with practical, real-world examples.
It helped me improve my analytical thinking and confidence in working with business data, especially from an MIS perspective.
I highly recommend this course to anyone looking to start or grow in Data Analytics.
It helped me improve my analytical thinking and confidence in working with business data, especially from an MIS perspective.
I highly recommend this course to anyone looking to start or grow in Data Analytics.
Very good
This course undoubtedly one of the best i have ever learned
Moderate level course for everyone
Good and easy learning platforms.
yes
best
This course is very helpful for me in my professional life..
Just Wow!
Useful
It was a great learning platform; many, many thanks to our instructor, Md Tafsir Kabir Vai, for his dedication and support.
good
very organized the course.
yes, the classes were very informative
Outstanding Course
Excelent
Excellent. Will help me upgrade my career.
Nice course for improvement of my career.
It's an amazing course and our instructor has taught us in a fruitful way. Not only that I understood all the things he taught us during the course and all the materials were insanely useful as well as practical.