Exploring relationships and time

Exploratory data analysis with profiles and histograms, relationships between variables and their traps, and time series basics.

About 6 hours of study

Learning objectives

Lessons

  1. 1

    Exploratory data analysis Intermediate

    Getting to know a dataset before modelling it: profiling every column, counting missing values, drawing text histograms with bins, and writing down questions and surprises as you go.

  2. 2

    Relationships between variables Intermediate

    How two columns move together: scatter thinking, Pearson's correlation for every pair of columns, confounders, spurious correlations and Simpson's paradox, where a trend reverses when groups are combined.

  3. 3

    Time series basics Intermediate

    Data measured over time: sorting by date, totals per month, percentage change, moving averages that smooth out noise, seasonality, and flagging unusual days with a rolling mean and standard deviation.

Module practice

Module quiz

1. What does a histogram show?
2. A correlation of 0.9 between two columns means…
3. What does a 7-day moving average remove?
4. A trend holds in every group but reverses in the combined data. This is…
5. Sales grow 50% then fall 50%. Compared with the start they are…
6. Why compute an anomaly threshold from earlier days only?

‹ Summarising and combiningPrediction and practice ›