Course Overview
Become a Data Analyst with practical, job-ready skills using Excel, SQL, and Python — even if you’re starting from scratch.
This is a complete Data Analyst Bootcamp with real-world projects, designed to teach you how data analysis actually works in real companies.
Instead of learning tools separately, you will follow a structured path:
=> Excel → SQL → Python → Real Projects
What makes this course different?
Beginner-friendly and step-by-step learning path
Focus on practical data analysis skills
Real-world datasets and hands-on projects
Covers Excel, SQL, and Python together (not isolated)
In this course, you will learn:
Data analysis using Excel (formulas, dashboards, reporting)
Writing SQL queries for data extraction and analysis
Python fundamentals for data handling and automation
Data analysis using Pandas
Data visualization techniques
How tools work together in real analyst workflows
Hands-On Projects Include:
Excel dashboards and reports
SQL-based data analysis tasks
Python data analysis projects
Real-world datasets for practice
Course Structure:
Excel for Data Analysis (beginner to advanced)
SQL for Data Analysis (queries, joins, functions)
Python Basics & Projects
Python for Data Analysis (Pandas & visualization)
Additional tools and practice datasets
Who This Course Is For:
Beginners starting a career in data analysis
Students and fresh graduates
Professionals switching to data roles
Excel users upgrading to SQL and Python
Anyone preparing for entry-level data analyst jobs
Why Learn Data Analysis?
Data analysts are in high demand across industries.
With the right skills, you can:
Analyze business data
Create dashboards and reports
Support decision-making
Start a career in tech
By the end of this course, you will have the skills to work as a junior data analyst using Excel, SQL, and Python.
Start your journey today and build real-world data analysis skills.
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction & Roadmap 1 bài · 4 phút
Chương 2 Excel Basics for Data Analysis 10 bài · 2 giờ 38 phút
- Introduction to Excel Học thử 16:32
- Your First Excel Workbook Học thử 24:44
- Excel Productivity Học thử 24:31
- Professional Formatting Học thử 16:22
- Sort & Filter Học thử 9:55
-
Core formulas & cell referencing 10:15
-
Basic functions 15:42
- Cell Referencing Types Học thử 13:52
-
Ranges & Name ranges 10:59
-
Airthmetic Operator 14:41
Chương 3 Excel Functions & Data Cleaning 9 bài · 2 giờ 25 phút
-
Advanced Excel Functions 16:12
-
Text Functions 13:28
-
Nested IF 22:54
-
Data Cleaning & Validation 17:49
-
Deconstructing Data 14:47
-
Productivity Tools 20:35
-
Lookup & Reference 12:07
-
Vlookup, Hlookup, IFerror 10:06
-
Index Match 16:55
Chương 4 Excel Analysis, Charts & Projects 7 bài · 1 giờ 28 phút
-
Mini Project 9:31
-
Monthly budget tracker 21:00
-
Practical Inventory Tracker + Salary Master 9:54
-
Charting & Visualization 11:20
-
Choosing the Right Chart 13:40
-
Combo Charts 12:32
-
Monthly Sales chart dashboard 9:59
Chương 5 Pivot Tables & Dashboards 10 bài · 2 giờ 10 phút
-
Pivot Tables 16:18
-
Understanding Fields 11:56
-
Calculated Fields 18:18
-
Advanced Excel features 17:20
-
Dashboard Project: planning & setup 12:42
-
Cleaning & Structuring Data 13:06
-
Planning dashboard layout 9:39
-
Dashboard Project -2 8:27
-
Refreshing summary tables 11:58
-
Linking Form controls to charts 10:14
Chương 6 Excel Projects & AI 12 bài · 3 giờ 12 phút
-
Project I 13:18
-
Project II 20:47
-
Project III 13:21
-
Project IV 19:15
-
Project V 17:13
-
Project VI 14:06
-
Project VII 24:09
-
Project VIII 12:44
-
Excel_ai- I 13:52
-
Excel_ai- II 15:18
-
Excel_ai- III 16:02
-
Excel_ai- IV 11:51
Chương 7 SQL for Data Analysis (Oracle Live SQL) 21 bài · 1 giờ 28 phút
-
SQL 1 3:04
-
SQL 2 3:41
-
SQL 3 1:49
-
SQL 4 1:35
-
SQL 5 1:04
-
DRL - Data Retrieval Language 11:15
-
DML 1 0:38
-
DML 2 1:30
-
DML 3 6:19
-
DML 4 3:34
-
DML 5 4:17
-
Functions 1 0:44
-
Functions 2 2:01
-
Functions 3 6:36
-
Functions 4 14:23
-
Numeric 1 1:15
-
Numeric 2 8:11
-
Date Time 1 2:11
-
Date Time 2 3:08
-
JOINS 1 2:37
-
JOINS 2 7:40
Chương 8 Python Foundations & Projects 37 bài · 12 giờ 20 phút
-
Introduction to Python 3:25
-
Software installation and writing our first program 7:54
-
Keywords operators typecasting 8:45
-
Variables datatypes comments indentation 9:26
-
Taking input from User 5:52
-
Conditional statements and loops 15:02
-
Functions and Scope 24:48
-
__name__==__main__ 5:05
-
Data Structures working with LISTS 15:32
-
Data Structures(working with tuples) 11:46
-
Data Structures(working with dictionaries) 10:45
-
Data Structures working with SETS 17:45
-
Calculator app 7:55
-
File Handling_1 22:40
-
Handling CSV files (csv module) 18:08
-
JSON File Handling 8:28
-
Error Handling 17:19
-
Understanding Classes and Objects in Python (OOP Basics) 22:47
-
Methods in Python OOP (Instance, Class & Static Methods) 17:51
-
The Four Pillars of Object-Oriented Programming in Python 19:30
-
Working with External Modules 9:16
-
API in Programming 13:44
-
Building a Weather App with OpenWeather API 16:49
-
To-do list or task manager 6:53
-
Flask – Building Web Apps - Copy 4:22
-
Machine Learning Basics with Python 33:23
-
(Pygame) Build a Simple Color Match Game in Python 27:01
-
Major Project - Expense Tracker 41:21
-
Data Analysis with Pandas 01 23:22
-
Data Analysis with Pandas 02 39:19
-
Data Visualization with Pandas and Matplotlib 42:34
-
Data Analysis Project with Pandas and Matplotlib 55:14
-
Python Web Scraping basics 10:37
-
Python Automation Automating Everyday Tasks 30:04
-
Python Databases Introduction to SQL 38:48
-
Python CRUD App with sqlite (fixed) 35:49
-
Chatbot (Major Project) 40:34
Chương 9 Additional Excel Topics 12 bài · 5 giờ 1 phút
-
Chart 21:27
-
Chart 3D 29:04
-
New Chart 3D 29:04
-
Stacked Chart 30:24
-
Doughnut Chart 31:36
-
Funnel Chart 28:37
-
Map Chart 36:35
-
Histogram 22:04
-
Scatter Plot Chart 41:26
-
Data Validation 17:13
-
Superstore Sales Dataset (pdf file)
-
Macro and VBA 13:01
Requirment
-
No prior programming or data analysis experience required
-
Basic computer usage knowledge is enough
-
Willingness to learn and practice step by step
Outcomes
-
Analyze data using Microsoft Excel with formulas, functions, charts, pivot tables, dashboards, and projects
-
Clean, organize, and validate real-world data using Excel best practices
-
Create Excel dashboards and reports used in business and analyst roles
-
Write SQL queries to retrieve, filter, group, and analyze data from databases
-
Use SQL functions and JOINs to work with multiple tables
-
Learn Python fundamentals required for data analysis
-
Work with CSV and JSON files using Python
-
Perform data analysis using Python Pandas
-
Visualize data using Python charts and plots
-
Understand when to use Excel, SQL, or Python in real data analyst workflows
-
Apply skills through practical projects and real datasets
-
Build a strong foundation for entry-level data analyst roles
0 Student
1 Course
0 review