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
Category: PowerPivot Links
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.
Downgrading From PowerPivot v2 to v1
OK, let’s say you already installed v2, whether inadvertently or… advertently. And now you need to downgrade to v1, so that your workbooks function on your server
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.
The Ultimate Date Table
I get a lot of questions from people who are struggling with the time intelligence functions in DAX.
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.
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!
CIMA Part 2 – The Hidden Costs of Traditional BI
I’ve always loved the concept: we know the universe is essentially a lot “heavier” than all the things we can see
PowerPivot V2 CTP3!
CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”
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.
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 […]
- 1
- 2