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 […]
Interview with JamieMac of Predixion Software
Me: “Can you PLEASE stop answering the question before I even ask it? It’s kinda freaking me out.” Jamie: “I knew you were going to say that.” It is a […]
Cleaner SharePoint pages, and an offer to share
“Dr. A. Heller. Weapons designer.Innovator. Inventor. World changer.” “…why does he live in a deserted amusement park?” Building an Arsenal of PowerPivot Components and Tools In the past six months […]
A few tips on maintainability
Eat This Not That, PowerPivot Edition! Just like normal Excel, PowerPivot requires little or no premeditation – you can just jump right in and build something quite impressive. But if […]
