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 for the reader, here’s the website, good luck,” I’ll share the workbook I used for cleaning it, and include some explanatory comments so you can follow what I did.

You’ll have to rename this file to be .xlsx, because WordPress doesn’t let me upload Excel files… which is just incredibly poor judgment on their part, as I’m sure you will all agree :)

Click here to download the data

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 2 Comments

  1. Kasper de Jonge

    Thank you very much, I have a PowerPivot demo coming up and will surely use this to show the power of PowerPivot.

  2. powerpivotpro

    My pleasure, happy to help :)

Leave a Comment or Question