Post 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/
Post 2: http://www.dailydoseofexcel.com/archives/2010/02/27/powerpivot-part-2-of-4-prepping-the-census-data/
Post 3: http://www.dailydoseofexcel.com/archives/2010/03/02/powerpivot-part-3-of-4-conditional-shape-colors/
Post 4 is forthcoming.