I have my work cut out for me…

PowerPivot is going to be put to the test perhaps even more than I had thought.  And um, it looks like I will be, too. I spent a good chunk of today taking inventory of what the MSN football cube could do, as well as what the underlying data tables look like. Oh my goodness.  It looks daunting from the aerial view.  But I’m optimistic that it won’t be so bad when I start working on the individual pieces, akin…

Read the Rest

SharePoint Conf 2009: Five Observations

Allow me to let you in on a little secret:  when Microsoft employees attend Microsoft conferences, we are often learning just as much as everyone else.  The company is just too big, and we’re all just too busy, to really keep tabs on everything that’s going on, even with our immediate partner teams. Last week’s SharePoint conference in Vegas was no exception, and was in fact the most eye-opening yet for me.  The moments where I sat/stood there thinking “Really? …

Read the Rest

US Meteorological Data

Kasper asked me to share a pointer to the US weather data I used in the mashup example I posted last night (when I revised the “What is PowerPivot” post – sorry if you only saw v1).  I figure others may be curious too, so I’ll share here rather than in comments. I did quite a bit of cleaning/shaping (in Excel) on that data before I was able to use it.  Rather than be cruel and say “that’s an exercise…

Read the Rest

What is PowerPivot?

I think a lot of people arriving at this site for the first time already know quite a bit about what PowerPivot is, but a few people have expressed curiosity:  it would be easier to understand why the site is called PowerPivotPro if we knew what PowerPivot was in the first place. There are a lot of good places to read about PowerPivot, so I won’t go super deep here.  Instead I’ll give you a summary in my own words,…

Read the Rest