Using PowerPivot to find out more about you

Here are two fun tutorials you can follow that think outside the box about potential real world PowerPivot applications:


On Kasper de Jonge's blog (the best resource for PowerPivot information, IMO): Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer


On Chris Webb's BI Blog: Using PowerPivot to Analyse Windows Search Results

Tip

If you're working with PowerPivots, don't create relationships on Calculated Columns. I just learned that today, the hard way...

PowerPivot - An Introduction

Chances are you already heard about Excel 2010's main new feature: PowerPivots. Having spent a few days reading about and using PowerPivots, I'm starting to get the hang of it.

If you're a little confused, or just want to know more, this article is for you.

Convert Table To List

This is a code I wrote to convert a table (values and headers) to a list, so it can easily be manipulated using pivot tables or loaded intro a database. I posted this two years ago on the excellent Ozgrid Forums, so it makes sense I share it here too. It was tested on Excel 2003, but it should work in 2007/2010. Let me know if it doesn't.