Data Analytics Full Course

About Course

This course teaches the full process of data analytics, from working with raw data to producing clear, usable insights.

You will learn SQL as the starting point, focusing on how data is stored and how it can be extracted from databases. You will then learn Excel for fast data cleaning, exploration, and practical analysis.

The course builds a strong foundation in statistics so you can understand patterns in data, summarize it correctly, and make sound interpretations. After that, you will learn Power BI to present your analysis through structured, interactive dashboards.

Finally, you will learn Python to handle more advanced data tasks, perform deeper analysis, and work efficiently with larger datasets.

The course is designed to show how these skills connect, so you understand the full workflow of data analytics rather than isolated tools.

Course Content

SQL FOR DATA ANALYTICS

Understanding Databases and Their Role in Data Science and Analytics.

00:00
MYSQL SETUP AND PRACTICE DATABASE INSTALLATION

00:00
Database Creation and Management Fundamentals.

00:00
SELECT, FROM, WHERE Fundamentals (Part 1: Filtering and Comparison Operators)

00:00
SELECT, FROM, WHERE Fundamentals (Part 2: Filtering with Logic and Patterns)

00:00
Data Aggregation and Grouping in SQL

00:00
Inner Join in SQL: Combining Related Tables

00:00
Advanced Joins in SQL: LEFT, RIGHT, FULL AND SELF JOIN.

00:00
Subqueries in SQL: Querying within queries.

00:00
SQL Functions and Conditional Logics (Core Functions)

00:00
SQL Functions and Conditional Logic (CASE Statement)

00:00
Common Table Expression in SQL (CTEs)

00:00
Window Functions in SQL: Advanced Row Level Analytics

00:00

COMPLETE MICROSOFT EXCEL FOR DATA ANALYTICS

Introduction to Excel For Data Analytics.
Working with Data in Excel: Basic Spreadsheet Operation.
Data Cleaning and Preparation in Microsoft Excel.
Core Excel Functions for Analysis.
Lookup and Reference Functions
Sorting, Filtering, and Data Exploration.
Pivot Tables for Data Analysis
Data Visualization in Excel
Introduction to Power Query
Building Reports and Dashboards in Excel
Best Practices for Excel in Data Analytics
End-to-End Excel Analysis Project

UNDERSTANDING STATISTICS FOR DATA ANALYTICS

Introduction to Statistics for Data Analytics
Types of Data and Measurement Scales
Descriptive Statistics: Summarizing Data
Understanding Data Distribution
Probability Fundamentals
Sampling and Data Collection.
Hypothesis Testing 1 (Introduction)
Hypothesis Testing 2 (Tests of Difference)
Hypothesis Testing 3 (Tests of Association)
Confidence Intervals
Common Statistical Mistakes in Data Analysis
Applying Statistics in Real-World Analysis

BUSINESS INTELLIGENCE FOR DATA ANALYTICS WITH MICROSOFT POWERBI.

FUNDAMENTALS OF PYTHON PROGRAMMING FOR DATA ANALYTICS

Introduction to Jupyter Notebooks and Python for Data Analytics

00:00
Variables, Data Types, and Type Conversion in Python

00:00
Operators in Python.

00:00
Basic Data Structures I (Lists)

00:00
Basic Data Structures In Python II (Tuples)

00:00
Basic Data Structures In Python III (Dictionaries & Sets)

00:00
Control Flow in Python I: Conditional Statements

00:00
Control Flow in Python II: For Loops.

00:00
Control Flow in Python III: While Loop.

00:00
Comprehensions in Python

00:00
Functions In Python.

00:00
Exception Handling In Python.

00:00
Lambda Functions and Functional Tools: map, filter, and reduce

00:00
Object Oriented Programming (OOP) I

00:00
Object Oriented Programming (OOP) II (Encapsulation & Inheritance)

00:00

EXPLORATORY DATA ANALYSIS WITH PYTHON

CAPSTONE PROJECT

Student Ratings & Reviews

No Review Yet

About Course

Course Content

SQL FOR DATA ANALYTICS

Understanding Databases and Their Role in Data Science and Analytics.

MYSQL SETUP AND PRACTICE DATABASE INSTALLATION

Database Creation and Management Fundamentals.

SELECT, FROM, WHERE Fundamentals (Part 1: Filtering and Comparison Operators)

SELECT, FROM, WHERE Fundamentals (Part 2: Filtering with Logic and Patterns)

Data Aggregation and Grouping in SQL

Inner Join in SQL: Combining Related Tables

Advanced Joins in SQL: LEFT, RIGHT, FULL AND SELF JOIN.

Subqueries in SQL: Querying within queries.

SQL Functions and Conditional Logics (Core Functions)

SQL Functions and Conditional Logic (CASE Statement)

Common Table Expression in SQL (CTEs)

Window Functions in SQL: Advanced Row Level Analytics

COMPLETE MICROSOFT EXCEL FOR DATA ANALYTICS

Introduction to Excel For Data Analytics.

Working with Data in Excel: Basic Spreadsheet Operation.

Data Cleaning and Preparation in Microsoft Excel.

Core Excel Functions for Analysis.

Lookup and Reference Functions

Sorting, Filtering, and Data Exploration.

Pivot Tables for Data Analysis

Data Visualization in Excel

Introduction to Power Query

Building Reports and Dashboards in Excel

Best Practices for Excel in Data Analytics

End-to-End Excel Analysis Project

UNDERSTANDING STATISTICS FOR DATA ANALYTICS

Introduction to Statistics for Data Analytics

Types of Data and Measurement Scales

Descriptive Statistics: Summarizing Data

Understanding Data Distribution

Probability Fundamentals

Sampling and Data Collection.

Hypothesis Testing 1 (Introduction)

Hypothesis Testing 2 (Tests of Difference)

Hypothesis Testing 3 (Tests of Association)

Confidence Intervals

Common Statistical Mistakes in Data Analysis

Applying Statistics in Real-World Analysis

BUSINESS INTELLIGENCE FOR DATA ANALYTICS WITH MICROSOFT POWERBI.

Introduction to Business Intelligence and Power BI

Data Wrangling In PowerBI With PowerQuery

Data Modeling and Relationships

Data Analysis Expression (DAX)

Data Visualization in Power BI

Building Interactive Dashboards

Advanced Reporting and Insights.

End-to-End Power BI Project.

FUNDAMENTALS OF PYTHON PROGRAMMING FOR DATA ANALYTICS

Introduction to Jupyter Notebooks and Python for Data Analytics

Variables, Data Types, and Type Conversion in Python

Operators in Python.

Basic Data Structures I (Lists)

Basic Data Structures In Python II (Tuples)

Basic Data Structures In Python III (Dictionaries & Sets)

Control Flow in Python I: Conditional Statements

Control Flow in Python II: For Loops.

Control Flow in Python III: While Loop.

Comprehensions in Python

Functions In Python.

Exception Handling In Python.

Lambda Functions and Functional Tools: map, filter, and reduce

Object Oriented Programming (OOP) I

Object Oriented Programming (OOP) II (Encapsulation & Inheritance)

EXPLORATORY DATA ANALYSIS WITH PYTHON

Numpy Fundamentals

Introduction to Pandas for Data Manipulation

Data Cleaning and Preparation with Pandas

Fundamentals of Data Visualization with Matplotlib, Seaborn, and Plotly

Advanced Visualization with Matplotlib, Seaborn and Plotly.

Descriptive Statistics with NumPy and SciPy

Time Series Exploratory Data Analysis (EDA)

Complete EDA Workflow Project

CAPSTONE PROJECT

Student Ratings & Reviews

Quick Links

Resources