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.
Posts about Data Hygiene.
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.
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…
Your Word templates shouldn't fight you on formatting.
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 returns a table of tables, unlocking complex multi-level analysis you can't get anywhere else.
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…
Stop replacing VLOOKUPs. Your workbook deserves XLOOKUP without touching the formula.
It is 2026, and we are still stringing together premium Power Automate connectors just to avoid the Word mail merge wizard.