Skill 03 · Data Analytics & BI
Questions in, decisions out.
Analytics is the path from a business question to a decision people can act on: model the data, query it, chart it, and say what it means.
One case, start to finish
From 541,909 raw rows to one dashboard.
Every square is real data from the Online Retail file. Scroll and watch it get checked, cleaned, modelled, added up and turned into the dashboard that answers the question.
Explore
Every part of the job, one page each.
Data models
The same business stored in different shapes: flat files, normalised tables, star schemas, event logs, history tables, time series.
Tools
One real file followed through every tool, a map of 28 tools with drawn interfaces, the same question in eight tools, a BI head-to-head and a stack builder.
Chart library
Nearly three hundred charts in 34 families: every kind of bar, line, pie, real map, word cloud and table, each with when to use it.
Dashboards
How a dashboard is built, then five working ones: Online Retail sales, an e-mail A/B test, live Jakarta air quality, customer churn and an FWA base-health case built from raw data.
SQL playground
Write SQL against the datasets in your browser. Coming next.