Comparing Access to PowerPivot
Here’s a question that comes up with increasing frequency: “PowerPivot seems kinda similar to Access in many ways, what’s the difference?” Why Does the Question Come Up? Some of you […]
Tag: PowerPivot Power Pivot Microsoft SharePoint BI Excel Business Intelligence Denali Beta
The Ultimate Date Table
I get a lot of questions from people who are struggling with the time intelligence functions in DAX.
Profit & Loss–The Art of the Cascading Subtotal
I occasionally look through the logs of what people were Googling (or Binging etc.) when they found their way to the blog.
The Incredible “Iffer-Blanker-Filter” Measure
I’ve had this on my list to share for a long time, but David Churchward’s recent guest post bubbled it to the top
PowerPivot V2 CTP3!
CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”
DAX – A/B Campaign Analysis with Start & End Date Slicers
“Because every good story has a beginning, a middle, and an end.”
Awhile back I posted about promotional campaign analysis factoring in seasonal trends. Now let’s look at another flavor of campaign analysis: comparing results when a campaign is active versus when it was not. Sometimes this is referred to as “A/B Testing.
PowerPivot Accelerators: The Story (And Announcing: the Private Beta)
We’ve received a lot of exciting interest and have identified about 15 great
Five Observations From SQL PASS
Wow, what a trip. I barely slept. Let’s get right down to it: summary of my thoughts on the whole thing. 1) The Future of MS BI is (Basically) PowerPivot […]
The “Ferrari” of PowerPivot Books
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.
Slicers and pivot update performance
-Posted by Rob Collie OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodies we can […]
Welcome Query designers!
-Guest Post by the one and only Dany Hoter! We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years? Suffice to […]
Quick Tip: Don’t Over-Use DAX FILTER() function in Power BI
The other day I was working on an updated version of my Team Playcalling report, which, by the way, look FABULOUS with Slicers: Only problem with it was that it […]
- 1
- 2