Skip to content

Data Analysis with Spreadsheets and SQL

Turn raw numbers into decisions your team can act on

5.0 (1 reviews) 4 learners 1 h 46 min Beginner

Instructor
Dr Amara Okafor

Free Certificate
Sign up to enrol Preview a lesson
  • 7 lessons in 3 modules
  • 1 assessment
  • Verifiable certificate on completion

What you will learn

  • Frame a business question as an analysis task
  • Clean and validate a dataset before analysis
  • Summarise data with lookups and PivotTables
  • Write SQL queries that filter, group and join tables

About this course

A practical first course in data analysis. You will learn how analysts frame questions, clean messy data, summarise it with spreadsheet formulas and PivotTables, and query databases with SQL. Every lesson uses realistic business data from retail, logistics and public services.

Completion criteria

Complete every lesson and pass all required assessments.

Curriculum

Module 1Thinking like an analyst3 lessons
  • What data analysis is forPreview8 min
  • Clean data before you trust it12 min
  • Check your understanding: spotting dirty data4 min
Module 2Spreadsheets that answer questions2 lessons
  • Formulas and lookups15 min
  • Summarising with PivotTables and charts14 min
Module 3First steps in SQL2 lessons
  • SELECT, WHERE and ORDER BY15 min
  • GROUP BY and JOIN18 min
Data analysis fundamentals checkQuiz · pass mark 70% · required