Auckland New Zealand Population with Excel Power View
- SharePoint
- Posted by: Hayden Sinclair
- font size decrease font size increase font size
I have recently been analysing New Zealand Census data in Excel with Power Pivot, Power Map and Power View.
You can download the latest New Zealand Census Data in Excel and add the stats into your own Power Pivot, Power View and Power Map sheets.
To plot the statistics in Power Map, I downloaded each Meshblock’s co-ordinates from Koordinates. I stripped out the Polygon co-ordinates and just used the first location point for each Meshblock.
Being, based in Auckland, New Zealand, I have concentrated on the Auckland dataset.
The Power Map video shows population growth by suburb (meshblock) between 1991 and 2007. To Aucklanders it will be no surprise to see that the suburbs have grown progressively from Census to Census.
Not all cities are seeing their populations rise year on year. Detriot for example has lost 25% of their residents in the last ten years.