Surprising Example of Power BI Compression
“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 […]
Category: Power BI
PowerPivot Data in Scatter Charts, etc.
This was going around on the MS-internal discussion list this past weekend: At right is a list of all chart types in Excel. But not all of them are supported […]
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 […]
Parameterizing the report
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 […]
Pulling back the curtain: Intro to Cube Formulas
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 […]
The death of pie charts?
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
Microsoft Unveils New Programming Language: XL#
OK, yeah, that’s not a real story. I just made it up, sorry 🙂
Putting the “Intelligence” in “Business Intelligence,” Pt 2
“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 […]
Putting the “Intelligence” in “Business Intelligence,” Part 1
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” […]
Introducing PowerPivot DAX Measures
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 […]
A 48 hour case study from Bing – Zero to Sixty :)
“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 🙂 […]
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part Two
(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 […]