DATA ANALYSIS COURSE
Master the skills needed to become a job-ready Data Analyst in just 2 months. Learn how to clean, analyze, visualize, and present data using Microsoft Excel, MySQL, and Power BI. This hands-on course covers data cleaning, formulas, SQL queries, dashboards, data modeling, and business intelligence reporting through real-world projects and practical exercises. By the end of the program, you'll have a professional portfolio project, industry-relevant skills, and the confidence to analyze data and make data-driven decisions.
What You'll Learn
Course Lessons
1
Excel Interface
2
Data Types Entry
3
Formatting
4
Basic Formulas
5
Cell Referencing
6
Text Functions
7
Date Functions
8
Logical Functions
9
Lookup Functions
10
Math & Statistical Functions
11
Data Cleaning
12
Data Validation
13
Pivot Table Basics
14
Named Ranges & Tables
15
Charts
16
Conditional Formatting
17
Dashboard Design
18
Sheet Protection & Collaboration
19
Excel Capstone Project
20
Database Fundamentals
21
SELECT Queries
22
Filtering Data
23
Sorting & Limiting
24
Aggregate Functions
25
Table Relationships
25
Table Relationships
26
JOINs
27
Subqueries & HAVING
28
Modifying Data & Functions
29
MySQL Built-in Functions
30
Power BI Interface
31
Connecting to Data
32
Power Query Editor
33
Building Visuals
34
Introduction to DAX
35
Advanced DAX
36
Time Intelligence
37
Data Modelling
38
Advanced Report Design
39
Final Project Build Day
Ready to Advance Your Learning?
Join our cohort program for guided learning, personalized mentorship, real-world projects, and career support.