Category: Analytics
Standardizing categories and names
Category chaos turns dashboards into spelling bees. Learn canonical values, mapping tables, alias lists, and how to escape Other hell so groupbys stay honest and unmapped rates stay…
Deduping without destroying history
Duplicates are identity problems, not a delete button. Learn natural versus surrogate keys, soft deletes, merge lineage, and validation checks so you collapse false twins without shredding history,…
Profile before you polish
Cleaning before you look is how silent bias sneaks into dashboards. Learn a lightweight profile of counts, nulls, ranges, and weird categories with SQL and Python so every…
What bad data actually means
Bad data is a shrug, not a diagnosis. Learn five practical quality dimensions (completeness, accuracy, consistency, timeliness, uniqueness) with workplace examples so you name the failure mode before…
Notebooks vs scripts for teammates
Notebooks help you explore. Scripts help you repeat. Learn when to stay in a notebook, when to graduate to a .py file, and how to hand work to…
