The “Ferrari” of PowerPivot Books

Update: My Book is Ready ***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. Click here for reviews and ordering options. Original Post… A Respected Authority A little background that is relevant: …

Read the Rest

PowerPivot Mind Meld: To Consult is to Train

  “When you wake, you will know how to use the EARLIER() function.” Last time, I trailed off and promised some heresy in this, my next post. But I realized in the meantime that I left out some other important observations, and I don’t want those lost in the smoke if I start tossing grenades.  So, let’s get those out of the way first. Does your org need PowerPivot Training, or do you need Consulting? Traditionally, the role of consultant…

Read the Rest

More PowerPivot Consulting Observations

  “I’ve…  SEEN THINGS… you wouldn’t believe.” -Roy Batty Do you experience “lightning bolt” moments?  Instants where something just hits you so clearly that your perspective changes permanently? Personally, I live for those moments.  They are rare, of course, but oh so worth it. I recently spent a couple days in San Diego, setting up a client with a self-service BI system based around PowerPivot.  I came away with several new (or newly-strengthened) observations, a couple of which were delivered…

Read the Rest

Congratulations Kasper!

    “You wanna switch seats?” OK, I’ve been slow to post about this with everything going on, but some of you have already heard that Kasper has some exciting news. You know that job at MS that I vacated back in February?  Kasper is filling it.   When I met Kasper in person for the first time this summer, down at TechEd, I already knew how sharp and enthusiastic he was.  But in person, surrounded by all the hints…

Read the Rest

Illustrated guide to Excel Services Chart Rendering

  COMMON QUESTION:  “Hey, will this chart render unchanged in Excel Services, or will it look different?” MY STOCK ANSWER:  “Hmm, I forget, let’s try it out” I hate giving that answer.  So today, I ran a little test.  Simple workbook, 12 charts that are all flavors of fancy.  Not an exhaustive test, but a reasonable sample.  Here are the 12 charts in Excel client (desktop).  Click for a larger version.   12 Charts in Desktop Excel Green Circle =…

Read the Rest

Top 5 Ways PowerPivot Helps Excel Pros

Sorry for the zero posts so far this week.  I have many things to catch up on after a couple days of consulting in San Diego (which was a FABULOUS experience). I have a lot to talk about next week here on the blog: Something big and amazing is happening in Kasper’s world – many of you have already heard but I think it deserves some special highlighting :) Recent observations from the PowerPivot consulting front Screenshots and video of…

Read the Rest