Fiscal Cliff Analysis with Microsoft Excel 2013 – Insight we didn’t Expect

With the launch of Microsoft Office 365, we thought it would be a great idea to showcase some powerful features.  As most of you know, we are all about analytics and insights, so what better scenario than looking at the United States budget?!

image

We got all our data from the http://data.gov site, which has a wealth of data sets on the federal government.  They are not the best data sources, but at least we can get to them.  We pulled the actuals vs. budgets dataset going back to 1940.  We mashed up that data using Excel 2013 and the built in feature called PowerPivot. That is a pretty rich set of actual vs. budget spending and gives some pretty amazing insights into the spending issue our government is faced with.

image

This chart allows you to see spending year over year.   Look at the last 10 years and you can really begin to see the spike in spending.  The neat thing about our analytics in Excel, is you have the ability to filter the data by President, Time in Office and Party.

image

When you look at the top 10 spending categories, you can see that entitlements are really the bulk of spending.  Sure, national defense is in there, but entitlements grow the fastest year over year.

image

One of my favorites is to see spending by Presidential parties.  You can see 2/3 of the entitlement spending is done by Democratic leadership, rather than Republican.  That is a pretty interesting fact that I didn’t know before.  See, some brand new insights we all didn’t know.

image

If you have some interesting examples you would like to share, contact me and tell me about it.

Enjoy, Patrick

One thought on “Fiscal Cliff Analysis with Microsoft Excel 2013 – Insight we didn’t Expect

  1. How can i find the data you worked from? I am on the data.gov site, what search terms will get me the actual vs. budget data you used?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s