Category: Analytics
Setup without tears
Set up Python for analytics without the folklore that scares people off. Create a virtual environment, install pandas with pip, and load a tiny CSV so your first…
Why Python for analytics (and when to stay in SQL or Sheets)
Python is optional for many analytics jobs, and that is a feature, not a failure. Learn when Sheets or SQL still win, when a notebook saves real hours,…
Your first table contract
One page that records grain, keys, ownership, columns, exclusions, and allowed use so multiplayer tables stay trustworthy.
Exporting cleanly into SQL or a warehouse
UTF-8 CSVs, honest types, ISO dates, no totals rows, and a handoff note so pipelines and people load what you meant to ship.
Cleaning before you analyze (Sheets edition)
A practical Sheets cleaning pass: trim, dates, splits, nulls, and deduping only after grain is clear. Keep raw copies; log your steps.
