Data Analyst Course

About Course

This course is a Data Analyst training designed to take you from zero to job-ready by teaching the core skills used by professional data analysts. It covers essential tools and techniques for handling, cleaning, analyzing, and visualizing data — through hands-on tutorials, real projects, and portfolio-building exercises. You’ll work on SQL, Excel, Python, Tableau, Power BI, and practical projects, designed to replicate real job tasks.

Module 1 — Introduction & Career Foundations
What is Data Analytics / Data Analyst role
How to become a Data Analyst step-by-step
Career roadmap & soft skills
(Intro videos at the start of the playlist)
Module 2 — SQL for Data Analysis
Installing SQL environments
Basic SQL: SELECT, WHERE, FILTERS
Intermediate SQL: JOINS, GROUP BY, ORDER BY
Advanced SQL: CTEs, Subqueries, Temp tables
SQL projects & real dataset exploration
(Core SQL videos early in the playlist)
Module 3 — Excel for Analysts
Essential Excel functions & formulas
Pivot Tables & data summarization
Data cleaning, charts & visualizations
Hands-on Excel projects
(Excel tutorial section in the playlist)
Module 4 — Data Visualization Tools
Tableau
Installation & setup
Creating charts, dashboards
Using calculated fields & filters
Tableau project demonstration
Power BI
Installation & Power Query basics
Data modeling & DAX
Building dashboards & visual insights
(Tableau and Power BI segments from playlist)
Module 5 — Python for Data Analysis
Python fundamentals & environment setup
NumPy & Pandas basics
Data cleaning & manipulation in Python
Exploratory Data Analysis with Pandas
(Python and Pandas tutorial sections)
Module 6 — Portfolio Building
Real data projects (SQL, Excel, Python, BI)
Create portfolio case studies
Publish projects on GitHub
Resume and LinkedIn optimization for analysts
(Project and career strategy videos near the playlist end)

Course Content

Module 1

How to Become a Data Analyst

00:00
Installing MySQL and Creating Databases | MySQL for Beginners

00:00
Select Statement in MySQL | Beginner MySQL Series

00:00
Where Clause in MySQL | Beginner MySQL Series

00:00
Group By + Order By in MySQL | Beginner MySQL Series

00:00
Having vs Where in MySQL | Beginner MySQL Series

00:00
Limit + Aliasing in MySQL | MySQL Beginner Series

00:00
Limit + Aliasing in MySQL | MySQL Beginner Series

00:00
Unions in MySQL | Intermediate MySQL

00:00
String Functions in MySQL | Intermediate MySQL Series

00:00
Case Statements in MySQL | Intermediate MySQL

00:00
Subqueries in MySQL | Intermediate MySQL

00:00
Window Functions in MySQL | Intermediate MySQL

00:00
CTEs in MySQL | Advanced MySQL Series

00:00
Temp Tables in MySQL | Advanced MySQL Series

00:00
Stored Procedures in MySQL | Advanced MySQL Series

00:00
Triggers and Events in MySQL | Advanced MySQL Series

00:00
Data Cleaning in MySQL | Full Project

00:00
MySQL Exploratory Data Analysis | Full Project

00:00
Pivot Tables in Excel | Excel Tutorials for Beginners

00:00
Formulas in Excel | Excel Tutorials for Beginners

00:00
XLOOKUP in Excel | Excel Tutorials for Beginners

00:00
Conditional Formatting in Excel | Excel Tutorials for Beginners

00:00
Charts in Excel | Excel Tutorials for Beginners

00:00
Cleaning Data in Excel | Excel Tutorials for Beginners

00:00
Full Project in Excel | Excel Tutorials for Beginners

00:00
How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners

00:00
How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners

00:00
How to Create Visualizations in Tableau | Tableau Tutorials for Beginners

00:00
How to use Joins in Tableau | Tableau Tutorials for Beginners

00:00
Full Beginner Project in Tableau | Tableau Tutorials for Beginners

00:00
How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners

00:00
How to use Power Query in Power BI | Microsoft Power BI for Beginners

00:00
How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners

00:00
How to use DAX in Power BI | Microsoft Power BI for Beginners

00:00
How to use Drill Down in Power BI | Microsoft Power BI for Beginners

00:00
How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners

00:00
How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners

00:00
Popular Visualizations in Power BI | Microsoft Power BI for Beginners

00:00
Full Power BI Guided Project | Microsoft Power BI for Beginners

00:00
Installing Jupyter Notebooks/Anaconda | Python for Beginners

00:00
Variables in Python | Python for Beginners

00:00
Data Types in Python | Python for Beginners

00:00
Comparison, Logical, and Membership Operators in Python | Python for Beginners

00:00
If Else Statements in Python | Python for Beginners

00:00
For Loops in Python | Python for Beginners

00:00
While Loops in Python | Python for Beginners

00:00
Functions in Python | Python for Beginners

00:00
Converting Data Types in Python | Python for Beginners

00:00
Building a BMI Calculator with Python | Python Projects for Beginners

00:00
Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners

00:00
Inspecting Web Pages with HTML | Web Scraping in Python

00:00
BeautifulSoup + Requests | Web Scraping in Python

00:00
Find and Find_All | Web Scraping in Python

00:00
Scraping Data from a Real Website | Web Scraping in Python

00:00
Reading in Files in Pandas | Python Pandas Tutorials

00:00
Filtering Columns and Rows in Pandas | Python Pandas Tutorials

00:00
Indexes in Pandas | Python Pandas Tutorials

00:00
Group By and Aggregate Functions in Pandas | Python Pandas Tutorials

00:00
Merging DataFrames in Pandas | Python Pandas Tutorials

00:00
Creating Visualizations using Pandas Library | Python Pandas Tutorials

00:00
Data Cleaning in Pandas | Python Pandas Tutorials

00:00
Exploratory Data Analysis in Pandas | Python Pandas Tutorials

00:00
Amazon Web Scraping Using Python | Data Analyst Portfolio Project

00:00
Automating Crypto Website API Pull Using Python | Data Analyst Project

00:00
How to Create a Portfolio Website for FREE

00:00
Create the Perfect Data Analyst Resume | Free Templates!

00:00
Solving Easy SQL Interview Questions on Analyst Builder

00:00
Solving Medium SQL Interview Questions on Analyst Builder

00:00
Solving HARD SQL Interview Questions on Analyst Builder

00:00
Solving VERY HARD SQL Interview Questions on Analyst Builder

00:00
Azure Account Setup + $200 Free Credits | Azure Fundamentals

00:00
Blob Storage and Storage Accounts in Azure | Azure Fundamentals

00:00
How to use Azure SQL Databases | Azure Fundamentals

00:00
Getting Started in Azure Data Factory | Azure Fundamentals

00:00
Getting Started in Azure Synapse Analytics | Azure Fundamentals

00:00
AWS Setup and UI Walkthough | AWS

00:00
S3 Storage in AWS | AWS Essentials

00:00
Amazon Athena in AWS | AWS Fundamentals

00:00
AWS Glue DataBrew and Glue | AWS Essentials

00:00
AWS Quicksight | AWS Essentials

00:00
Top 3 Tips on Using LinkedIn to Land a Job

00:00

Student Ratings & Reviews

5.0

Total 2 Ratings

2 Ratings

0 Rating

7 years ago

This was my first time taking an online course.
The content is excellent, and the instructors are also excellent.
How much you learn from this course is pretty much what you put into it.

7 years ago

Thank you! I enjoyed your course and humor.
Please keep working on making great stuff to share and help more people.
Look forward to more additional features to this project near future.

About Course

What Will You Learn?

Course Content

Module 1

How to Become a Data Analyst

Installing MySQL and Creating Databases | MySQL for Beginners

Select Statement in MySQL | Beginner MySQL Series

Where Clause in MySQL | Beginner MySQL Series

Group By + Order By in MySQL | Beginner MySQL Series

Having vs Where in MySQL | Beginner MySQL Series

Limit + Aliasing in MySQL | MySQL Beginner Series

Limit + Aliasing in MySQL | MySQL Beginner Series

Unions in MySQL | Intermediate MySQL

String Functions in MySQL | Intermediate MySQL Series

Case Statements in MySQL | Intermediate MySQL

Subqueries in MySQL | Intermediate MySQL

Window Functions in MySQL | Intermediate MySQL

CTEs in MySQL | Advanced MySQL Series

Temp Tables in MySQL | Advanced MySQL Series

Stored Procedures in MySQL | Advanced MySQL Series

Triggers and Events in MySQL | Advanced MySQL Series

Data Cleaning in MySQL | Full Project

MySQL Exploratory Data Analysis | Full Project

Pivot Tables in Excel | Excel Tutorials for Beginners

Formulas in Excel | Excel Tutorials for Beginners

XLOOKUP in Excel | Excel Tutorials for Beginners

Conditional Formatting in Excel | Excel Tutorials for Beginners

Charts in Excel | Excel Tutorials for Beginners

Cleaning Data in Excel | Excel Tutorials for Beginners

Full Project in Excel | Excel Tutorials for Beginners

How to Install Tableau and Create First Visualization | Tableau Tutorials for Beginners

How to use Calculated Fields and Bins in Tableau | Tableau Tutorials for Beginners

How to Create Visualizations in Tableau | Tableau Tutorials for Beginners

How to use Joins in Tableau | Tableau Tutorials for Beginners

Full Beginner Project in Tableau | Tableau Tutorials for Beginners

How to Install Power BI | Building First Visualization | Microsoft Power BI for Beginners

How to use Power Query in Power BI | Microsoft Power BI for Beginners

How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners

How to use DAX in Power BI | Microsoft Power BI for Beginners

How to use Drill Down in Power BI | Microsoft Power BI for Beginners

How to use Conditional Formatting in Power BI | Microsoft Power BI for Beginners

How to use Bins and Lists in Power BI | Microsoft Power BI for Beginners

Popular Visualizations in Power BI | Microsoft Power BI for Beginners

Full Power BI Guided Project | Microsoft Power BI for Beginners

Installing Jupyter Notebooks/Anaconda | Python for Beginners

Variables in Python | Python for Beginners

Data Types in Python | Python for Beginners

Comparison, Logical, and Membership Operators in Python | Python for Beginners

If Else Statements in Python | Python for Beginners

For Loops in Python | Python for Beginners

While Loops in Python | Python for Beginners

Functions in Python | Python for Beginners

Converting Data Types in Python | Python for Beginners

Building a BMI Calculator with Python | Python Projects for Beginners

Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners

Inspecting Web Pages with HTML | Web Scraping in Python

BeautifulSoup + Requests | Web Scraping in Python

Find and Find_All | Web Scraping in Python

Scraping Data from a Real Website | Web Scraping in Python

Reading in Files in Pandas | Python Pandas Tutorials

Filtering Columns and Rows in Pandas | Python Pandas Tutorials

Indexes in Pandas | Python Pandas Tutorials

Group By and Aggregate Functions in Pandas | Python Pandas Tutorials

Merging DataFrames in Pandas | Python Pandas Tutorials

Creating Visualizations using Pandas Library | Python Pandas Tutorials

Data Cleaning in Pandas | Python Pandas Tutorials

Exploratory Data Analysis in Pandas | Python Pandas Tutorials

Amazon Web Scraping Using Python | Data Analyst Portfolio Project

Automating Crypto Website API Pull Using Python | Data Analyst Project

How to Create a Portfolio Website for FREE

Create the Perfect Data Analyst Resume | Free Templates!

Solving Easy SQL Interview Questions on Analyst Builder

Solving Medium SQL Interview Questions on Analyst Builder

Solving HARD SQL Interview Questions on Analyst Builder

Solving VERY HARD SQL Interview Questions on Analyst Builder

Azure Account Setup + $200 Free Credits | Azure Fundamentals

Blob Storage and Storage Accounts in Azure | Azure Fundamentals

How to use Azure SQL Databases | Azure Fundamentals

Getting Started in Azure Data Factory | Azure Fundamentals