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.
Content Type: Blog Post
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 […]
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 […]