Data Analysis: Excel, SQL, PowerBi

Overview

What you'll learn

Understand what data is and the main types of data

Calculate and interpret mean, median, mode and dispersion

Spot and handle outliers in a dataset

Navigate Excel confidently and use its key functions

Analyse real-world datasets and build clear dashboards

Turn numbers into insights you can present to others

Explore career paths and opportunities in data analysis

About this course

Every business, school and organisation runs on data, and people who can make sense of it are in high demand. This course teaches you to turn raw numbers into clear answers and confident decisions.

You will begin with the foundations: what data is, the different types of data, and the basic statistics every analyst relies on, including mean, median, mode, dispersion and outliers. Then you will move into Excel, learning the interface and the functions that do the heavy lifting, and use it to analyse real-world datasets, build dashboards and present insights clearly.

The course finishes with the career side of data analysis, showing you the roles, skills and opportunities available so you know exactly where this can take you. Lessons are short and practical, and you can learn at your own pace. No prior experience is required.

Curriculum

Course content

48 sections · 48 lessons · 11h 51m total length

Types of DataVideo

13 min

Basic StatisticsVideo

18 min

Career Opportunities in Data AnalysisVideo

8 min

Functions in EXcelVideo

11 min

Calculating Mean, Median, and ModeVideo

8 min

Calculating DispersionVideo

13 min

OutliersVideo

11 min

Data VisualizationVideo

8 min

Practicals With Data Visualization and CleaningVideo

10 min

Standardization of DataVideo

7 min

Introduction to Charts in ExcelVideo

7 min

How To Use Pivot TablesVideo

10 min

Introduction to SQLVideo

7 min

Your First SQL CodeVideo

9 min

Using Conditions in SQLVideo

22 min

Counting, Ordering, and Summarizing Data in SQLVideo

23 min

Counting, Ordering, and Summarizing data in SQLVideo

23 min

HAVING clause, and Introduction to JOIN clauseVideo

8 min

Practicals with JOIN clauseVideo

16 min

Advanced SQL Sub queriesVideo

10 min

Common Table ExpressionVideo

12 min

Window FunctionsVideo

17 min

Putting all SQL codes TogetherVideo

3 min

Common String FunctionsVideo

19 min

Introduction to PowerBi and InstallationVideo

6 min

PowerBi WorkflowVideo

21 min

Building Your First PowerBi ReportVideo

15 min

PowerBi Slicers and FormattingVideo

13 min

PowerBi DAXVideo

21 min

Overview of PowerBi ProjectVideo

21 min

Data Modelling 1Video

11 min

Data Modelling 2Video

5 min

Data Modelling 3Video

15 min

Introduction to Essential DAX FunctionsVideo

4 min

CALCULATE Function in DAXVideo

12 min

Ohter DAX Functions 1Video

23 min

Other DAX Functions 2Video

18 min

Representing DAX Functions on other ChartsVideo

13 min

Time Intelligence DAX Functions 1Video

33 min

Time Intelligence DAX Functions 2Video

9 min

Introduction to How to Build Professional Dashboard, and Course ConclusionVideo

4 min

Building a Professional Dashboard 1Video

59 min

Building a Professional Dashboard (Excel)Video

20 min

Building Professional Dashboard 3 (PowerBi)Video

56 min

Requirements

No prior data or coding experience needed

A computer with Microsoft Excel (or a free alternative like Google Sheets)

A stable internet connection

Basic maths: addition, division and percentages

Your instructor

Learn from YIVAI

YIVAI

Ready to start learning?

Join 6 students and get lifetime access to every lesson.

Enroll Now