Category: Analytics

UTF-8 CSVs, honest types, ISO dates, no totals rows, and a handoff note so pipelines and people load what you meant to ship.

A practical Sheets cleaning pass: trim, dates, splits, nulls, and deduping only after grain is clear. Keep raw copies; log your steps.

Why customer_id beats matching on names. Primary keys, foreign keys, one-to-many joins, and sheet habits that keep IDs stable.

Headers once, one value per cell, tidy vs wide. Turn pretty spreadsheet layouts into analysis tables that filter, join, and export without drama.

Spreadsheets start handy and can end as multiplayer systems of record with no owner. Learn the liability ladder, red flags, and Monday fixes before you trust a file…