“AGAIN!” -Pai Mei SUMX() – the great iterator Have you ever written an array formula in Excel?  (Don’t worry, most people haven’t).  Have you ever written a FOR loop in […]

Mmmm! Daaaamn, Jimmie! This is some serious gourmet DAX! Usually, me and Vince would be happy with some freeze-dried Taster’s Choice right, but he springs this serious GOURMET DAX on […]

In case you missed them, the full videos of my presentation in Sweden were posted last week. They are long – I was on stage for over two hours combined, […]

“Best not analyze too deeply on this one, huh?” A long time ago I promised a guy named Sam that I would dig up some examples of PowerPivot compression.  I […]

“Where does he get such WONDERFUL toys???” -Kasper de Jonge (To be honest, Kasper probably looks nothing like this.  I’ve never been to the Netherlands, but based on the fashions […]

In the Parameterized Report, how do I get the “Fan Pts” column on the far right of the cube formula report to respond to those parameter cells in the top […]

OK, last week I showed you a parameterized PowerPivot report that contained no pivots anywhere.  How did I build it? Best Tutorial:  Start with a Pivot The easiest way to […]

A few weeks back, a BI analyst posted a list of factors to consider when selecting a new BI tool.  Shortly thereafter, a BI blogger posted a scathing critique of that article

OK, yeah, that’s not a real story.  I just made it up, sorry 🙂

“I’ve always believed that the mind was the most dangerous weapon.” -John Rambo        …which explains the huge muscles and machine gun, right John? A View of BI that Henry […]

I remember the first time I heard the term “Business Intelligence.”  I had been working on Excel for awhile at that point and loved crunching data, but boy, “Business Intelligence” […]

(Continuing the series on the Great Football Project…) OK, remember in the previous step, we saw how a relationship between Plays and CleanPlayers suddenly let me use a single PivotTable […]