Tag Archives: excel error

0-100-episodes-dear-analyst

Dear Analyst #100: Hitting a hunned! A look back at the top 5 episodes of Dear Analyst

Holy cannoli. Somehow we’ve hit 100 hundred episodes of the Dear Analyst podcast. This podcast started off as an experiment because I was lazy and got tired of writing. I figured speaking about Excel and data analytics would be easier than coming up with prose. Ironically, I’m still writing because all the show notes for […]

Dear Analyst #38: Breaking down an Excel error that led to a $6.2B loss at JPMorgan Chase

You blink a few times at the screen and realize what you’re seeing is not a typo. $6.2B has left your bank due to some rogue trader making untimely bets on the market. That’s B as in billion. You call up the modeler who was supposed to make sure this never happens to your bank. […]