Sunday, June 17, 2012

Using Tree Maps for tracking Personal Consumption Expenditure

Tree Maps are an under-utilised form of data visualization.  I felt compelled to apply another publicly available data-set to a tree map.  So I found suitable the Table 2.3.5U. Personal Consumption Expenditures by Major Type of Product and by Major Function from the US Bureau of Economic Analysis Table 2.3.5U

Data was manipulated in Excel for the Tree Map Excel data file
Expenditure in Q1 2012 is used for the area of blocks which are classified under Services, Goods- Durable and Nondurable. Color of the blocks is derived from the percentage growth in expenditire from Q1 2011 to Q1 2012. Amazingly simple data visualization that you can talk to easily. The color coding gives a heat map of expenditure growth, while the area illustrates the dominant expenditure.



No comments: