Dynamic TopN Reports via Slicers, Part 2
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]
Search Results for: https://ww
Self Service BI Doesn’t Mean Desktop Standalone BI
A colleague recently pointed me to a blog post on Birst’s website, that says QlikTech has jumped the shark.
Insight as a Service – Your Next Career?
Is Your Brain More Valuable Than You Know? ***Update: May 2015 This article is now three years old. I’ve been gone from my last company now for more than two […]
DAX – Making the “Case” for SWITCH()
Way back during the period of the first CTP of Gemini (which later became PowerPivot), I was working with a data set that included a column of month numbers
Percentile Measures in DAX – Errata
Guest Post by Colin Banfield [LinkedIn] In September of last year, I posted two articles on creating percentile measures in DAX. See Creating Accurate Percentile Measures in DAX – Part I and Creating Accurate Percentile Measures in DAX – Part II.
Excel 5-Calendar Date Table
For some time, I have been looking around for a fairly complete date table in Excel for use with PowerPivot.
Friday Bonus: What is “Stimulus Spending?”
I stumbled into an interesting discussion on Facebook yesterday, and didn’t have room to express my opinion there, so I thought I’d do it here. It’s about the economy, which has been my only real hobby for the past several years.
Beta-Testing the “ROI Quadrant”
If you’ve been around Business Intelligence for the past ten years, you’ve seen a LOT of Gartner’s Magic Quadrant. You can see the 2012 version here on Microstrategy’s web site.
DAX – Weighted Averages: Another Use of SUMX()
Another Question from the Mr. Excel Forums Got a question on the forums the other day. It took some extra twists and turns but the simplest version of the question is worth covering here: how do I perform a weighted average?
Aged Debtors–Dynamic Banding in DAX
Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects. The die-hard “non-accountant” Excel […]
DataMarket Revisited: The Truth is Out There
Yeah, I love quoting movies. And tv shows. And song lyrics. But it’s not the quoting that I enjoy – it’s the connection.
VLOOKUP Week: Who Needs VLOOKUP Anymore?
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel