Eight detailed revision chapters for practical data analysis: trustworthy KPIs, spreadsheet cleaning, SQL filtering and aggregation, joins, lookup formulas, pivot summaries, charts and communicating limitations. Uses portable spreadsheet concepts and SQLite examples. Original synthetic examples; no programming prerequisite. Lifetime online access; study notes only, no internship certificate.
What you’ll study
4 sections · 8 detailed chapters · about 40 minutes of reading · lifetime access. Chapter text is available online and as a downloadable PDF after purchase.
01 · Trustworthy Data and Spreadsheet Basics
Define the question, row grain and KPI5 min read
Clean spreadsheet data without hiding evidence5 min read
02 · SQL Queries and Relational Thinking
SELECT, filtering, sorting and NULL5 min read
Joins, grouping and reconciliation5 min read
03 · Formulas, Pivots and Communication
Lookups and conditional formulas5 min read
Pivot summaries, charts and decision notes5 min read
04 · Practice and Review
Guided lab: reconcile orders and payments5 min read
Mini project: a refreshable monthly analysis5 min read