PowerPivot - census data

Written by Tushar Mehta

Friday, 19 March 2010 21:27

After the MVP Summit I was motivated to further explore a Microsoft add-in for Excel 2010 called PowerPivot. I don’t know all its capabilities but at the very least it can analyze millions of rows of data. If you are using Excel 2010 you can download the add-in from http://www.microsoft.com/downloads/details.aspx?FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca&displaylang=en

Do keep one thing in mind. The Community Technical Preview (CTP) version of the PowerPivot addin that is currently available is incompatible with the currently available version of Office 2010, i.e., the Release Candidate (RC). The problem seems to lie in that the data in the PowerPivot tables are not stored in the Excel file as they should be. So, on reopening the file, there is no database for PP to use! I assume (hope?) Microsoft will fix this incompatibility soon.

PowerPivot - Part 1 of 4...
PowerPivot - Part 2 of 4: Prepping the census data...
PowerPivot - Part 3 of 4: Conditional Shape Colors...
PowerPivot – Part 4 of 4: A geographic visual display of 18 million US Census records...

Tags: excel, load