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