Excel & Power BI for Data Analysis

Course Structure

• Duration: 3 Weeks (Onsite | Online) 

• Onsite: Saturdays 10am - 5pm  (GMT+1) 

• Online:  Tuesdays & Fridays 5.30pm - 8.00pm  (GMT+1) | Sundays 4.30pm - 8.00pm (GMT+1) 

• Labs: 10 Hands-On Dashboard Labs

• Projects: 2 — Excel Analytical Report + Power BI Business Dashboard

• Theory vs Practical: 30% / 70%

Ideal For 

• Business analysts, accountants, and finance professionals working with data daily

• Operations and administration staff who produce regular reports for management

• Sales managers and marketing professionals who track performance metrics and KPIs

• HR professionals managing workforce data and performance dashboards

• Anyone who uses Excel regularly and wants to dramatically increase their analytical capability

Course Description

Data is everywhere — the question is whether you can read it, interpret it, and present it compellingly. This course transforms participants from spreadsheet users into confident data analysts, combining the familiarity of Excel with the power of Power BI to turn raw numbers into actionable business insights.

What Participants Will Learn

• Advanced Excel: VLOOKUP, INDEX-MATCH, pivot tables, dynamic arrays, and data cleaning

• Excel data modelling and building automated dashboards

• Introduction to Power BI: the interface, data sources, and core concepts

• Connecting Power BI to Excel, SQL databases, and cloud data sources

• Building interactive reports, charts, slicers, and drill-down dashboards

• DAX (Data Analysis Expressions) fundamentals for calculated fields and measures

• Storytelling with data: choosing the right chart for the right message

• Publishing and sharing reports with stakeholders