CAT4-11 · Information Technology & Digital Skills

Data Analysis with Excel & Power BI

Practical data analysis skills using Microsoft Excel and Power BI — from data cleaning through pivot tables, DAX measures, and interactive dashboard creation for business reporting.

What you will learn

• Clean and organise raw datasets using Excel functions, Power Query, and data validation tools
• Build formulas, pivot tables, and charts to analyse and summarise data effectively
• Import and model data in Power BI and create calculated columns and DAX measures
• Build and publish interactive Power BI dashboards that present data-driven insights clearly

Who it's for

Open to all FET students; basic spreadsheet familiarity is helpful.