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” […]
Content Type: Blog Post
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 […]
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part One
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 […]
What is Power Pivot?
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 […]