PowerPivotPro

Excellent, welcome!  Here are some quick links that catch you up on what’s going on here.  Have fun!

Getting Started

1. What is PowerPivot – Introduction to what it’s all about.
2. Who is PowerPivotPro – Who am I and why this site?
3. PowerPivot Beta – How to get the Beta for yourself (it’s easy!), and tips on installing it

Case Studies and In-Depth Examples

1. 48-Hour Case Study from Bing – one of my friends who works for Bing adopted PowerPivot for internal bug tracking in literally 48 hours.
2. The Great Football Project – where I convert a pre-existing professionally-built BI database to PowerPivot.
3. Temperature/Sales Mashup Demo – where I combine sales data with temperature statistics off of the web to do something truly unexpected.
   1. And part two is here

The FAQ

The Great PowerPivot FAQ is a collaboration by members of Microsoft as well as some of the leading experts in the community.

Observations and Trends

1. SharePoint’s Emergence as Platform – top 5 list that caught me completely by surprise.
   1. Observations #2 and #3 here
   2. #4 and #5 here
2. PowerPivot’s impact on BI Pros – discussion amongst several BI professionals about whether PowerPivot means less or more opportunities for them.
3. Forrester Top 10 – observations from a savvy analyst, and my take on how PowerPivot fits into those.
4. Putting the “Intelligence” in Business Intelligence – how PowerPivot puts the human intellect back into the BI equation without compromising reliability.
   1. Part Two
   2. Part Three
   3. Related:  Microsoft Announces New Programming Language XL#