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 […]

Recall that in yesterday’s post I linked my FactEvent table to the CleanPlayers table via a relationship.  Time for the payoff. But you know what?  I’m tired of calling it […]