5.00
(2 Ratings)
Data Analysis Complete Bangla Course
Categories: Data Science, Programming
What Will You Learn?
- Python Programming Language
- R Programming Language
- Numpy
- Matplotlib & Seaborn
- Power BI
- Pandas & SQL
Course Content
🟠 00. Join Our Live Class
-
Join our whatsapp Group
-
Resources Download here✅
-
Resource Collection Hub [No Video]
🟠 Helpdesk
-
Microsoft Office Activator
✅ Step: 01 Excel Data Analysis
-
Excel Interface
04:47 -
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: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:12 -
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:43 -
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:39 -
Shape
05:46 -
shape styles
01:37 -
icons
05:26 -
Excel images
06:48 -
Equation and Symbols
05:09 -
Column Chart
09:20
✅Step: 02 Data Cleaning With Excel
-
Data Cleaning Agenda
02:02 -
Remove Blank Data and Duplicate Data
08:08 -
Fix Data text formatting
-
Fix data text formatting
05:19 -
Flashfill and Convert text to column
07:01 -
Clean Data Table
04:47
✅ Step 03: Power Query
-
get and transform data
00:00 -
power Query interface
00:00 -
Load and Connection Data
00:00 -
Manage Column
00:00 -
Reduce Rows
00:00 -
split column
00:00 -
Sorting
00:00 -
Group By
00:00 -
Replace Values
00:00 -
Data types
00:00 -
Transform Table
00:00 -
any column
00:00 -
Text Column
00:00 -
Number Column
00:00 -
date time column
00:00 -
merge and append queries
00:00 -
Manage Parameter
00:00 -
column from example
00:00 -
custom column
00:00
✅ Step 04: PowerBI
-
All About Power Bi
08:31 -
Power BI download and installation
08:14 -
Power BI interface
08:14 -
Data connection and import
03:15 -
import Local Data using Power Bi
05:53 -
Canvas & Background
04:44 -
Page Navigation
05:12 -
power bi visualization
03:42 -
Power Bi Bar Chart
06:13 -
Bar chart Visualization
00:00 -
power Bi Table
00:00 -
Power Bi table Customization
00:00 -
power bi matrix
00:00 -
Power Bi Matrix Customization
00:00 -
Power Bi Pie Chart
00:00 -
Power Bi Donut Chart
00:00 -
Power bi Line chart
00:00 -
Power Bi Elements
00:00 -
Combo Chart
00:00 -
Power Bi slicer
00:00 -
Slicer Customization
00:00 -
Power Bi Card
00:00 -
Power Bi text Card
00:00 -
Multi Row Card
00:00 -
Gauge Chart
00:00 -
Data Modeling
00:00 -
Dax introduction
00:00 -
How to start DAX
00:00 -
Basic DAX Formula
00:00 -
Power Bi Filter
00:00 -
Calculate unique Data using filter
00:00 -
Calculated sum by multiple filter
00:00 -
CalculateTable using Filter
00:00 -
Decomposition tree
00:00
✅ Step 05: MySQL Database
-
introduction to SQL
00:00 -
How to Download Xampp 🟢
00:00 -
Create Drop Show Database
00:00 -
MySQL Create Table
00:00 -
Insert Into Table
00:00 -
MySQL Select
00:00 -
MySQL Distinct
00:00 -
where
00:00 -
MySQL Order By
00:00 -
MySQL Delete
00:00 -
SQL Operator
00:00 -
IN, Not IN
00:00 -
MySQL Group by
00:00 -
MySQL Between
00:00 -
Alter Update
00:00 -
Alter Rename
00:00 -
SQL Truncate
00:00 -
Alter Drop Column
00:00 -
SQL Comments
00:00 -
AS keyword
00:00 -
Aggregate Functions
00:00 -
Join Table
00:00 -
Left and Right Join
00:00
✅ Step 06: (Structure Programming-Basic)
-
introduction to Python Programming Language
12:13 -
input , Output & Comments
22:26 -
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:49
✅ Step 07: (Structure Programming – Advanced)
-
string declaration & string indexing slicing
26:02 -
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:55 -
Python Dictionary
19:21
✅ Step 08: (structure Programming- pro)
-
function Parameter & Arguments
14:13 -
function keyword arguments
17:31 -
Anonymous Function
14:18 -
Python Methods
14:29 -
Python Methods and function
14:29
✅ Step 09: Object Oriented Python
-
Object & Class
11:47 -
Methods and Constructors
10:53 -
Types of constructor
13:27 -
instance variable and methods
10:50 -
Python Encapsulation
11:55 -
Private & Protected Members
11:16 -
Python Inheritance
00:00 -
Single , Multi-level, Hierarchical inheritance
00:00 -
Python Polymorphism
00:00 -
Methods overloading
00:00 -
Methods overriding
00:00
✅ Step 10: Data Analysis (Numpy)
-
NumPy Array Declaration
09:03 -
Numpy Array Dimension
09:33 -
NumPy Array indexing & Slicing
11:55 -
Numpy Special Array
08:51 -
NumPy Data Types
12:10 -
NumPy Array Shape
11:28 -
NumPy Array Copy vs View
11:55 -
NumPy Joining Array
11:28 -
NumPy Splitting Array
11:16 -
NumPy Searching Arrays
10:02 -
NumPy Sorting Arrays
10:50
✅ Step 11: Pandas
-
Pandas Introduction
10:51 -
Pandas Getting Started
00:00 -
Pandas Series
00:00 -
Data Frame using Dictionary
00:00 -
Data Frame using list
00:00 -
Read CSV Excel or any files using Pandas
00:00 -
File Save using Pandas
00:00
✅ Step 12: Matplotlib
-
Matplotlib Tutorial
10:43 -
Matplotlib Markers
00:00 -
Matplotlib Line
00:00 -
Matplotlib Labels, Title and grid
00:00 -
Matplotlib Pyplot
00:00 -
Matplotlib Plotting
00:00 -
Matplotlib Adding Grid Lines
00:00 -
Matplotlib Subplot
00:00 -
Matplotlib Scatter
00:00 -
Matplotlib Bars
00:00 -
Matplotlib Histograms
00:00 -
Matplotlib Pie Charts
00:00
Student Ratings & Reviews
5.0
Total 2 Ratings
5
2 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
Excellent Course
One of the best Course ✅