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.

Aug 2, 2026

Grading Your Data: A Practical Data-Quality Scorecard

A data-quality grade turns vague unease about your spreadsheet into a number you can act on. Here is the measurement framework: completeness, uniqueness and validity, scored per column.

Read the article →
Jul 31, 2026

Beyond Counting: What Categorical Columns Actually Say

Counts of categories hide the interesting part: concentration. A Herfindahl index and a top-share number reveal whether one category dominates or everything is fragmented.

Read the article →
Jul 29, 2026

The Floating-Point Problem: Why Your Sums Are Wrong

0.1 + 0.2 is not 0.3 in any language. Floating-point arithmetic drifts, cancellation destroys precision, and your grand totals quietly inherit the damage. Here is how it works and what to do.

Read the article →
Jul 27, 2026

Measuring Your Forecast: MAPE, RMSE, and the Holdout

A forecast is only as good as its error metric — and every popular error metric lies in a different way. Here is how to evaluate forecasts with a holdout and pick the right measure.

Read the article →
Jul 25, 2026

Missing Data: When to Drop, When to Impute, When to Worry

Missing values are not one problem — they are three, with different remedies. The pattern of missingness decides whether you can drop, impute, or must investigate before doing anything.

Read the article →
Jul 23, 2026

Anomalies in Time Series: Spikes, Level Shifts, and Seasonal Surprises

A spike is not a level shift, and neither is a seasonal dip. Anomaly detection on time series fails when it treats all three the same. Here is the residual-based approach that tells them apart.

Read the article →