One of the largest source of Public Data Metrics, and making it better. #markets #economics

publicfinancialmetrics

Discovering insights and mining data can be a lot of fun when you have access to good public data.  It has been fun to watch the public data discovery segment grow and grow over the years.   In all my years of doing data analysis and development, public data insights is just a big pain in the butt.  Inaccurate data, data out of date, pay services and limited views of the data makes it very frustrating.  Then you watch and listen to the TV and Radio financial shows and it makes you wonder where they got those numbers.  I always found it a pain and wanted better access to those numbers, so what should I do?  Add it to my app.

metriccatalog

In Atlas Insights, you can browse into the catalog and just click or tap a category.  Quickly you’ll be shown a list of public metrics available at your disposal to view.  Also, at the very top of the app, just type in your search and I’ll quickly show you a list of matching metrics for you to view.  It can’t get more simple than that to find and analyze a public metric.

Below is a list of public metrics that I have loaded and am loading more and more as the days and weeks go on.

  • Advance Monthly Retail Inventory
  • Advance Monthly Wholesale Inventories
  • Agriculture Price Index
  • Architecture Billings Index
  • Baltic Dry Index
  • Case-Shiller Home Price Index
  • Cass Freight Index
  • CEO Economic Survey
  • Chemical Activity Barometer
  • Conference Board Coincident Economic Index
  • Conference Board Lagging Economic Index
  • Conference Board Leading Economic Index
  • Construction Spending
  • Consumer debt service ratio
  • Consumer Price Index
  • Consumer Spending
  • Corporate Profits
  • Debt service ratio
  • Durable Goods
  • Employment Trends Index
  • Existing Home Sales
  • Farm Animals and products
  • Farm Assets
  • Farm Crops stored
  • Farm Real Estate
  • Fear & Greed Index
  • GDP – Gross Domestic Product
  • Home Builder Sentiment
  • Homeownership Rates
  • Industrial Production and Capacity
  • Manufacturers’ Shipments, Inventories
  • Manufacturing and Trade Inventories
  • Manufacturing Wholesale Trade
  • Monthly Wholesale Trade
  • Mortgage Applications
  • Mortgage Delinquencies Rate
  • New Housing Under Construction
  • New Housing Units Completed
  • New Housing Units Started
  • New Residential Sales
  • Personal Consumption Expenditures
  • Quarterly Services Survey
  • Rental Vacancy Rates
  • Retail Trade
  • Sales for Retail and Food Services
  • Trade in Goods and Services Deficit
  • U.S. International Trade in Goods

My goal is to make Atlas Insights a central source for all the leading economic metrics you could ever want to see.  Browse on over to Atlas Insights to download and see all these awesome metrics.  It’s FREE too!  I’ll never charge for access to view public data metrics.

Enjoy, Patrick

Who’s going to win? Trump or Clinton? #PresidentialElection @realDonaldTrump @HillaryClinton

20161101_210040000_ios

7 days left and it is basically a tie with the others breaking the tie. You can download and use Atlas Insights to track the Presidential Polls in real-time. Data comes from the Washington Post and ABC News Presidential Polls. Enjoy!

Download for  Apple iOSApple MacGoogle Android and  Microsoft Windows

 

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

2010 Census Data

The Census department is releasing their data today.   And low and behold they have a pretty nice drill down site to review the data.  I wish the big BI vendors would actually create tools like this so you didn’t have to do custom solutions all the time.  Maybe some day.

Anyway, it is worth a trip over to the government site to check out the data.

Source: http://2010.census.gov/2010census/data/

image

The Capitol’s Age Pyramid: A Graying Congress great InfoGraphic

A buddy of mine (Dave DuVarney) sent me a link to the Wall Street Journal with a great animated infographic that shows the congress men and women by age over time.   Very interesting and a great way of presenting this type of information.   Now I know why everyone get’s a trophy.

 

Source: http://online.wsj.com/public/resources/documents/info-CONGRESS_AGES_1009.html

image

Who Owns Congress? A Campaign Cash Seating Chart. This is a good Infographic

With the elections coming up in just a few short weeks, there is so much money being passed around to control voting and initiatives.  One of my employees forwarded me this Mother Jones article on who owns congress.  This really bugs me and really lays out how big business and special interest control the U.S. Government.   This is a great way to show insight using infographics and data.  These charts really bug me…

Source: http://motherjones.com/politics/2010/09/congress-corporate-sponsors

Enjoy, Patrick

image

image