My Experiences with Hosted PowerPivot, Part One
Almost exactly six months ago, after being a long time reader of this blog, I emailed Rob and asked him a question regarding something that I just couldn’t get my head around in DAX – Banding!
Search Results for: https://ww
Converting from Peaks to Frequencies Using DAX
Folks I just can’t resist a quick followup on the Rat Sniffing Project. I… just… can’t. Plus I am absolutely worn down and don’t have the energy tonight for anything that isn’t inherently entertaining.
More Live PowerPivot Web Apps!
I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the entire thing here ahead of time.
Lookups based on date ranges
Another one from the Mr. XL Forum!
…and the word “forum” gives me an excuse for a blast from the past…
DAX – Tracking Performance After an Event or Treatment
The Mr. Excel PowerPivot Forum has inspired me to change gears a little bit and focus more time on simple techniques that don’t break the DAX Spicy Scale
DAX – Comparing scientific and other data across trials
Enjoying the new forum! I’ve been spending some time on the Mr. Excel PowerPivot forum over the past few days and I must say I am enjoying the experience.
Mini Post #2: Mr. XL Launches PowerPivot Forum
The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on MrExcel.com. I wasn’t sure what he would say, to be honest.
Sales/Budget: Integrating Data of Different “Grains”
Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA
In the Browser, Aesthetics Yield a Greater Return
I thought today was going to be a “handful of mini posts” kind of day but then this post blossomed into a bit more than I thought it would, which is a good thing.
Six Observations from the 2011 PASS Keynote
The PASS Summit tends to be one of Microsoft’s favorite venues for unveiling big news in the BI space. As you may recall, the 2010 Summit revealed some amazing things for the PowerPivot world.
What if spreadsheets were invented today?
Here’s a story I find myself telling a lot these days: imagine a world in which all of today’s technology exists except spreadsheets
PowerPivot ROI Comparison: CIMA Part Three
It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!