Wingdings and Other Symbolic Fonts in Slicers!
Someone planted an idea in my head the other day: “hey can we use the Wingdings font in slicers?”
Category: Page Type
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 […]
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 – Top-Selling Product using FIRSTNONBLANK()
First of all, apologies for being so late. I feel like a total zombie, we got to our house in Ohio 22 hours after we arrived at the airport in Tel Aviv.
DAX – Finding the Top-Selling Date, Product, etc.
Greetings from Israel! I’m over here meeting with Microsoft and my old friend Dany Hoter
Conditional Formatting with Different Thresholds per Test, per Product, per Store, per Division, etc.
After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning
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.
Workarounds for “Canceled Due to Memory Pressure”
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
Datamarket: Quick Followup
“There are people out there whose jobs force them to be the place where two sources of data meet, and they are the ones who integrate and cross-reference that data […]