by Matt Allington Over the last 12 months I have engaged with may people from lots of different companies on the topic of Power Pivot. And I have been quite surprised at the low quality of some of the PC equipment people are given to do their job. I am not talking about people that need to do their emails and the odd Power Point presentation here – I am taking about people that are power users and data analysts…
Last week’s two-part series on The Three Big Lies and The World Doesn’t Know Its Own Numbers got me thinking about how all of this is connected. It’s all one big story, and I need to stitch it together. I actually told a big part of that story in one of my sessions at the PASS BA CON earlier this month, and people seemed to genuinely both enjoy and benefit from it. Because of that (and because I spent over…
This spreadsheet-wielding Scrooge was the logo of my fantasy football team (“Mighty Ebenezer”) circa 2001. Yes, I had this art custom commissioned for that purpose.
Yes, that is really, REALLY sick. And simultaneously PURE FREAKING AWESOME.
Let’s start here: Football Season is Spreadsheet Season. Yes, even more spreadsheets than usual, even for me. And football season starts tonight here in the US. So it’s high time I tell you this story.
Even if you don’t care about American Football, or sports in general, I suspect you may still find the story itself to be interesting.
Deep down, this story is actually about a trait shared by probably everyone reading this. And there is a TWIST in this story, a BIG one. So go get another cup of coffee. I will wait.
Scene: Rob Collie, 1996-1997. And Lots of Losing.
I started at Microsoft in July 1996, fresh out of college. I was raw, lazy, and unskilled. I had never really applied myself to anything. I had a computer science degree but had scrupulously avoided learning how to program. I got the job largely because I was decent at logic puzzles, which were the MS interview du jour.
Excel on the Left. Other Data Tools on the Right.
Today I’m going to “get my nerd on” in a big way. Buckle up.
The genesis of this post is an email I’ve been meaning to send to my contacts at Microsoft – one I’ve been thinking about writing for at least a year. But I also figure it’s the sort of thing you folks might find interesting, and I really don’t have time these days to write the same “opus” twice, so here goes – two birds with one stone. And it’s a friendly stone.
Has there ever been a tool as flexible as Excel?
Let’s take a moment and just marvel at Excel’s “range.” (VBA macro programmers – yes the joke is intentional).
But those are just the outliers really – the novelties. The truly valuable examples are much less dramatic and happen hundreds of thousands of times every day. I’ll give some examples in the next section.
Feature A Was NEVER “Intended” to Be Used With Feature B!
“Hey You Got Your Slicer in My Conditional Formatting!”
(And then the whole jar fell into a bucket of DAX)
A “Chuckler” of an Interview Story
My use of “paper or plastic” in today’s post reminded me of a funny story from Microsoft. There was a manager in Office who used to sit across the hall from me in the late 90’s – let’s call him DH. He was famous for being a tough interviewer. And I don’t just mean tough in the “only good candidates got by him” sort of way. He was tough in ways that went above and beyond the call of duty. In fact, on at least one occasion he made a candidate cry. (Not a good thing).
But this isn’t about one of those times. This particular story is about what happened when a particularly eccentric candidate crossed paths with that draconian interviewer.