Module · Intermediate · 1h 15m
Module 1: Questions, definitions and data
Getting the question precise, defining the metric so two people compute the same number, and profiling the data before trusting it.
- data
- module
Inside this module
- Write a metric definition
- Profile a table for the problems that corrupt analysis
The full module opens with a membership that covers Data Analysis.
Sign in if you already subscribe.
Sign inLessons
- 01From question to definition
Lesson · 25 min · Most wrong answers come from undefined questions; the fix is a written definition before any query.
- 02Profiling before analysing
Lesson · 25 min · The checks that find nulls, duplicates, inconsistent values and impossible numbers before they corrupt a result.
- 03Aggregating correctly
Lesson · 25 min · Group-bys, conditional sums and the reconciliation check that proves the totals.
