Guest Post: Catalog Your Measures with a Nifty Macro
UPDATE: Uploaded a new version of the macro file that David provided that fixed a couple of small problems. Also, I fixed a typo (I had it as XSLM, not […]
Content Type: Blog Post
DAX – More Fun With IF(VALUES())
“I mean, IF() I’m paying top dollar, I want a little production VALUE()” I bet you thought I was out of movie quotes for IF(VALUES()) didn’t you! If I had […]
DAX – The Magic of IF(VALUES())
“I’m Dan Marino, and IF() anyone knows the VALUE() of protection, it’s me.” Boom! An Ace Ventura quote finally graces the blog. Yes folks, that fine work of American cinema […]
PowerPivot Accelerators: The Story (And Announcing: the Private Beta)
We’ve received a lot of exciting interest and have identified about 15 great
Campaign Analysis: Seasonally-Adjusted Measures
“We sure sold a lot of toilet paper around Halloween this year. That promotion we were running must’ve been REALLY effective!” -Retail Manager Extraordinaire Halloween Mischief Has Nothing to […]
Hardware/Capacity Planning: From the Trenches
So How Many Servers Do I Need in My PowerPivot SharePoint Farm?
As people increasingly move up from just dabbling with the addin, and decide to start leveraging the publish/schedule/share/secure benefits of the PowerPivot for SharePoint infrastructure, I am getting this question more frequently.
Time to Rename Traditional BI?
You keep using that word, ‘Intelligence.’ I do not think it means what you think it means.-Average BI Consumer
Learning DAX Measures – the “Spicy Function” Scale
“I will start with the calculate curry. And a green tea.”
-Wise first time DAX customer
Is There a Preferred Way To Learn DAX Measures?
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.
More PowerPivot Consulting Observations
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.
Illustrated guide to Excel Services Chart Rendering
COMMON QUESTION: “Hey, will this chart render unchanged in Excel Services, or will it look different?” MY STOCK ANSWER: “Hmm, I forget, let’s try it out” I hate giving that […]