Data Analysis

Businesses are drowning in numbers and starving for insight. The analyst's job is to find the pattern and explain it clearly. We start with data cleaning, because that is where most of the real work lives, then move through Excel analysis, SQL and Power BI.

You finish with a capstone: a real dataset, a proper analysis and a dashboard you present as if to a manager.

What you will build

• A cleaned and documented dataset
• A set of SQL queries answering business questions
• An interactive Power BI dashboard
• A capstone presentation of findings

The journey

1. 1

   Data foundations and cleaning

   Data types, cleaning and consistent structure.

2. 2

   Analysis with Excel

   Formulas, pivot tables and charts.

3. 3

   Introduction to SQL

   Select, filter, join and summarise.

4. 4

   Dashboards with Power BI

   Connect data, build visuals and interactive reports.

5. 5

   Capstone project

   Analyse a real dataset and present your findings.

Tools you will use

• Excel
• SQL
• Power BI
• Data cleaning

Who it is for

Graduates, spreadsheet-heavy professionals and anyone aiming for a junior analyst role.

Before you enrol