Category: Analytics
This shelf is the job, not a tool manual. You are here if someone expects a number, a chart, or a “what should we do,” and the spreadsheet is starting to argue with itself. The articles cover the question before the query, a metric with a written definition, a chart that answers something, data that is fit to ship, and the messy middle of pipelines and stewardship.
It is not the SQL category. SQL is how you ask a table. Analytics is what you are trying to decide, and whether the number is even the right one. It is not the AI category either. A model can draft the email about the metric. It does not pick the metric.
Where to start: Analytics foundations if you do not yet have a clear question. Metrics if the team is arguing about a definition. Charts if the picture is pretty and the decision is still fuzzy. The SQL series when you are ready to ask the table yourself. Learn groups these as a track so you do not have to guess an order from a flat list.
How to standardize messy category names in your data
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…
How to remove duplicate customer records without losing their 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,…
How to profile a messy data table before you clean it
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 does bad data mean? How to name the problem so you can fix it
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…
Jupyter notebooks or Python scripts: which to share with your 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…




