Data analysis with spreadsheets and SQL
Starts in Google Sheets, where most African business data lives, and moves into SQL once you can feel the limits of a spreadsheet. You work with sales, customer and operations data throughout and finish by answering a real question from a dataset of your own.
6 modules · 28 lessons · taught with Google Sheets, PostgreSQL, DuckDB
About 10 hours: 9 hours 8 minutes of lessons, including their exercises, plus 60 minutes for the assessment.
What you will be able to do
- Clean a messy export with formulas, not by hand
- Build pivot tables that answer business questions
- Write SELECT, JOIN, GROUP BY and window queries
- Present one finding clearly to a manager
On completion
Codality verified certificate: Data Analysis Foundations, issued to your profile and shareable with one link.
Modules
- 01Free
Spreadsheets as a data tool
5 lessons · 80 min
- 02Plus
Cleaning and reshaping data
5 lessons · 90 min
- 03Plus
SQL from the first query
6 lessons · 130 min
- 04Plus
Joins, groups and windows
6 lessons · 138 min
- 05Plus
From question to finding
5 lessons · 110 min
- 06Plus
Assessment
1 lesson · 60 min
Also on the Data track