Sweden: the full videos
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, […]
Content Type: Blog Post
Quick Data Prep Trick: Use a Flat Pivot!
Today I had a huge source table that looked like this: Store Month Payment Type Some Number A Jan Cash 10 A Jan Credit 12 A Jan Debit 13 A […]
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 […]
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
Power BI and Power Pivot DAX: CALCULATE is a supercharged SUMIF
“No [doubt] she’ll freak. I’m just contemplating the =IF()’s…” -Marcellus Wallace, obvious master of the spreadsheet arts CALCULATE is a supercharged SUMIF I can’t believe I didn’t say this last […]
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 3
In Part One I described how standardized corporate BI bummed me out my first time around, then in Part Two described how PowerPivot recharged my batteries and brought me back into the fold.
DAX’s CALCULATE() function – if you’re not using this in Power BI (or Excel), it’s time to start
When I last worked on the football project, I had designed my first report and started the process of better understanding my source data, primarily using the =RELATED() function.
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 […]