4.78
(45 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:22 -
Excel String Manipulations
10:53 -
Excel Number Conversion
05:13 -
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:47 -
cells formatting
06:42 -
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:50 -
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 BI
-
All About Power Bi
08:31 -
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:41 -
Power bi Line chart
08:01 -
Power Bi Elements
07:02 -
Combo Chart
04:30 -
Power Bi slicer
05:07 -
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:18 -
Calculate unique Data using filter
04:56 -
Calculated sum by multiple filter
04:54 -
CalculateTable using Filter
04:47 -
Decomposition tree
05:36
MySQL Database
-
introduction to SQL
08:53 -
How to Download Xampp 🟢
01:54 -
Create Drop Show Database
06:18 -
MySQL Create Table
06:57 -
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:43 -
Join Table
08:05 -
Left and Right Join
08:26 -
MySQL Update Table
10:02
1st Batch Special Live Class 🎯
-
Orientation
01:16:58 -
Class 01
01:24:50 -
Class 02
01:29:37 -
Class 03
46:47 -
Class 04
01:10:26 -
Class 05
01:09:13 -
Class 06
01:19:21 -
Class 07
01:19:21 -
Class 08
51:03
2nd batch Special Live Class 🎯
-
Class 01
01:02:08 -
Class 02
01:18:54 -
Class 03
59:36 -
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:40 -
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:25 -
Class 03
01:01:50 -
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:02 -
Nov 18, 2024
01:04:36 -
Nov 22, 2024
01:02:16 -
Nov 25, 2024
01:14:35 -
Nov 30, 2024
01:20:06 -
13 December 2024
42:29 -
Data Analysis with python (20 December 2024)
01:26:57 -
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:24
7th Batch Special Live Class 🎯
-
20 January 2025
01:08:20 -
17 January 2025
01:04:30 -
28 January 2025
56:40 -
10 February [Power Bi 1]
40:31 -
14 April 2025
16:24 -
21 April 2025
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: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:21 -
15 April 2025
56:36 -
19 April 2025
37:40
10th Batch Special Live Class 🎯
-
13 April 2025
48:21 -
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:22 -
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:28
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: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
Numpy
-
NumPy Array Diclaration
09:03 -
Numpy Array Dimension
09:33 -
NumPy Array indexing & Slicing
11:55 -
Numpy Special Array
08:51 -
NumPy Data Types
12:11 -
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:58 -
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:35 -
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:55 -
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:16
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:47 -
Python Pandas ✅
01:09:13 -
Excel Advanced (Lookup, Conditional Formatting, Filter, Consolidate) ✔️
01:19:21 -
introduction To Power Bi 🟠
51:03 -
Data Analysis Road Map 🔥
01:02:07 -
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.8
Total 45 Ratings
5
37 Ratings
4
6 Ratings
3
2 Ratings
2
0 Rating
1
0 Rating
Recommended ....
very good
Very Informative and best in Bangladesh
Very good & helpfull.
good
Helpful for beginners to advance data analyst
very good
Good for beginner
Very Good
Yeah, it's given to me a great opportunity to learn essential tools.
Yes. It was actually excellent course, that i benefited from it.
Mashallah, these courses will be more helpful for marginal people all over the country. Basically who are enthusiastic about the data-related courses & other topics.
Very Helpful for Career
The course was really helpful. I learnt excel elaborately. Also the numpy,pandas,matplotlib and seaborn along with python fundamentals helped me lot to deepen my knowledge. Power Bi dashboards helped me to build data visualization projects.
Its was a great course for me.
TutorialspointBD offers a great Data Analysis course — clear lessons, practical examples, and easy-to-follow explanations. It’s a solid choice for anyone looking to build strong data skills. Highly recommended!
Even though this course costs only 399 Taka, you can learn a lot from it. Highly recommended.
Great Course. Learned a lot
Good Course.
good