What you will learn

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.

Lessons

1 Excel Interface 17 min 2 Data Types Entry 14 min 3 Formatting 20 min 4 Basic Formulas 12 min 5 Cell Referencing 11 min 6 Text Functions 11 min 7 Date Functions 13 min 8 Logical Functions 11 min 9 Lookup Functions 11 min 10 Math & Statistical Functions 11 min 11 Data Cleaning 13 min 12 Data Validation 12 min 13 Pivot Table Basics 10 min 14 Named Ranges & Tables 13 min 15 Charts 15 min 16 Conditional Formatting 19 min 17 Dashboard Design 17 min 18 Sheet Protection & Collaboration 14 min 19 Excel Capstone Project 12 min 20 Database Fundamentals 18 min 21 SELECT Queries 14 min 22 Filtering Data 15 min 23 Sorting & Limiting 15 min 24 Aggregate Functions 16 min 25 Table Relationships 18 min 25 Table Relationships 18 min 26 JOINs 16 min 27 Subqueries & HAVING 17 min 28 Modifying Data & Functions 17 min 29 MySQL Built-in Functions 17 min 30 Power BI Interface 17 min 31 Connecting to Data 20 min 32 Power Query Editor 24 min 33 Building Visuals 26 min 34 Introduction to DAX 18 min 35 Advanced DAX 18 min 36 Time Intelligence 18 min 37 Data Modelling 21 min 38 Advanced Report Design 24 min 39 Final Project Build Day 13 min