A monthly batch of bank statement PDFs used to mean a 4-hour KNIME workflow only I could run. Rebuilding it as a small Python desktop app took 30 minutes — and produced a tool anyone on the team can actually use.

I built a Gemini Gem to run NPV and IRR analysis on investment ideas, then checked its output against a traditional Excel model line by line. The numbers matched — and the Gem gave me things the spreadsheet never did.

A Bloomberg screenshot lands in your inbox and someone has to get those numbers into Excel — by hand, every day. Here's the small AI-assisted tool that turns a screenshot into a clean, exportable table with a paste and a click.

For years, reporting meant a business user explaining logic to an analyst who built it and handed it back. Then a colleague stopped explaining the logic to me and started explaining it to Copilot instead. Here's what changed when efficiency stopped being a specialist skill.

The first two months feel like a success. Then the data changes, the person who built it leaves, and the pipeline quietly breaks. Here's what I've learned about building reporting that survives contact with reality.