What I Wish Someone Had Told Me About Working With Data in a Small Team
In a small team, you're the analyst, the engineer, the dashboard designer, and the person who explains what a p-value is at the all-hands.
Data Hygiene
// 8 postsPosts about Data Hygiene.
Data Hygiene posts
-
-
LAMBDA: How to Write the Excel Functions Microsoft Didn't
Before LAMBDA, every Excel function that existed was one Microsoft decided to write. After LAMBDA, you can write them yourself — naming the logic, hiding the complexity, and calling your custom fun…
-
Build a Word template that holds its formatting
Your Word templates shouldn't fight you on formatting.
-
Power Query Is Not the Right Tool for Every Data Problem
Power Query is a brilliant transformation tool. Most of the M code in production is doing things that belong in DAX, SQL, or Python - and the models are slow and the code is unmaintainable.
-
Table.Group in Power Query: The Aggregation That Hands You Back a Table
Table.Group in Power Query returns a table of tables, unlocking complex multi-level analysis you can't get anywhere else.
-
The Flow Ran Perfectly for Two Months. Then It Didn't.
You built the flow. It ran perfectly for two months. Then a colleague renamed a SharePoint column, or moved a file, or changed a dropdown value - and everything stopped. This isn't bad luck. It's…
-
Build a Drop-In XLOOKUP Upgrade for Every VLOOKUP in Your Workbook
Stop replacing VLOOKUPs. Your workbook deserves XLOOKUP without touching the formula.
-
The state of email merge in 2026
It is 2026, and we are still stringing together premium Power Automate connectors just to avoid the Word mail merge wizard.