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 […]
Content Type: Blog Post
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 […]
Visualizing SQL Indices with Power BI or Power Pivot
Hey folks, got another special guest post for you. Today we are honored by the presence of the SillyBoy himself, Scott Senkeresty.
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 […]