Blog

Ideas you can check and use

Read about software engineering, data analysis and AI. Start with the question an article answers, then review its examples and assumptions before applying it to your work.

Sep 14, 2026

Histograms Lie by Default: Binning Choices That Change the Story

Ten bins show a healthy bell curve. Fifty bins reveal two separate populations. The data never changed — only the binning. How to stop histograms from lying.

Read the article →
Sep 12, 2026

Duplicate Detection: From Exact Matches to Fuzzy Record Linkage

"Jon Smith" vs "John Smyth" at the same address — same customer or two? Exact matching says two. Your revenue report disagrees. A ladder from dedup to linkage.

Read the article →
Sep 10, 2026

Time Zones, DST and Date Formats: Datetime Hygiene for Analysts

The campaign launched at midnight — in which time zone? Mixed zones, DST gaps and 01/02/03 ambiguity corrupt analysis silently. Rules for datetime hygiene.

Read the article →
Sep 8, 2026

Why Your CSV Opens Wrong: Encodings, BOMs and Delimiter Guessing

"Müller" renders as "Müller", the first column is named "id", and everything sits in one column. Three CSV gremlins, three fixes — none of them "retype it".

Read the article →
Sep 6, 2026

Joins That Silently Multiply Rows: Merge Pitfalls in Practice

Revenue doubled overnight — in the report, not in the bank. A duplicate key in a dimension table fanned out every joined row. How to audit merges before they lie.

Read the article →
Sep 4, 2026

Beyond Deleting Outliers: Winsorization and Honest Treatment

The fastest way to "fix" inconvenient data is deleting it. Winsorization caps extremes instead of erasing them — influence limited, sample intact, method disclosed.

Read the article →