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 […]
Category: Power BI
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
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 […]
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 […]
Review: Prof. PowerPivot for Excel & SharePoint
No more delays! Awhile back I reviewed Mr. Excel’s PowerPivot book and vowed to post a review of the other major PowerPivot book to date, by Denny, Ron, and Siva […]
Two common PowerPivot error messages
Been meaning to post this for awhile now. Here are two error messages I see all the time now, about once per day: UPDATED: I’ve found a third message that […]
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 […]
Using Excel CUBE Functions with PowerPivot
Arriving Here from a Search Engine or via Excel Help? This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of […]
Use slicer values in a calculation with PowerPivot DAX
By Kasper de Jonge, crosspost from PowerPivotblog.nl A while ago i had a question on my ask a question page, Sasha wanted to do the following: How to define the date […]