Data Analytics with Excel, SQL and Power BI

Clean, analyse and visualise business data with Excel, SQL and Power BI, and build dashboards managers actually use.

4.8 (1,280 reviews) 9,800 students 40 lessons 18h 45m Marcus Lee
Printed charts and graphs on a desk

What you will learn

  • Clean messy spreadsheets with formulas and Power Query
  • Write SQL queries to join and summarise data
  • Build interactive Power BI dashboards
  • Choose the right chart for every question
  • Tell a clear story with data
  • Complete a real business case study

Course content

8 lessons · 18h 45m
  1. 01 Welcome and course data files 5:05
  2. 02 Cleaning data with Excel and Power Query 21:30
  3. 03 Formulas, lookups and pivot tables 24:15
  4. 04 SQL basics: SELECT, WHERE, ORDER BY 19:40
  5. 05 Joins and aggregations in SQL 23:10
  6. 06 Building your first Power BI report 26:45
  7. 07 Dashboards and data storytelling 20:30
  8. 08 Final project: business dashboard 28:00

About this course

Clean, analyse and visualise business data with Excel, SQL and Power BI, and build dashboards managers actually use.

Each lesson is short and focused, followed by a quick exercise so you practise straight away. Download the workbook, follow along with the instructor and submit your final project for personal mentor feedback.

Who this course is for

  • Complete beginners who want a structured, practical start
  • Professionals who want to add a new skill to their CV
  • Anyone who prefers learning by doing real projects

What is included

  • 40 on-demand video lessons (18h 45m)
  • Downloadable resources and templates
  • Quizzes and a graded final project
  • Certificate of completion
  • Lifetime access on desktop and mobile

Your instructor

Marcus Lee
Marcus Lee Data Analyst & BI Consultant

Meet all instructors

You Might Also Like

All Courses