Introducing CUBESET() and CUBERANKEDMEMBER()
“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 […]
“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” […]
Up until this point, I’ve just used DAX (PowerPivot’s extension to the Excel formula language) to create calculated columns in the PowerPivot window. There’s a lot of utility in DAX […]
“When you can snatch this pebble from my hand, you will be re- HEY, GIVE THAT BACK!” -Me I promised a guest post, and a guest post I deliver 🙂 […]
(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 […]
So what is Power Pivot? I think a lot of people arriving at this site for the first time already know quite a bit about what Power Pivot is, but […]