Google’s Public Data Explorer is an awesome tool. I spent a little bit of time trying it out and decided to make this post to show how easy it is to extract data and embed graphs. The data set I picked is minimum wage in Europe over the past 13 years.
Simply copy the “Paste HTML to embed in website” and paste away. For wordpress users, an easy way to manage the html is with HTML snippets plugin (XYZ Html) or Post Snippets and simply browse and click on the snippets you’ve uploaded.
Here is the key for the following graph, which was embedded with HTML snippets. I followed up with some insights and key findings. This was all done in ~20 minutes, showing just how simple it is to extract data and embed Google’s data graph.
Time Frame: 2000 – 2013
Currency: Euro (per month)
Number of Countries: 22
Key Findings and Insights
- UK experienced a middle-class squeeze during the years 2007 – 2009, resulting in a decline, followed by choppy increases, bringing them just 50 shy from the 2006 high.
- Ireland has had the most stabilized rate for the past six years.
- Belgium, Netherlands, France, Ireland, and the U.K. have the offer the highest wages, while countries in the east are less by an average of 697.
- Luxembourg has the highest min. wage
- Romania and Bulgaria are tied for the lowest min. wage
The Public Data Explorer can be customized with dozens of filters such as source type, countries, categories, gender, and age. With Google’s data we can make our content more resourceful, reliable, and colorful. Try it out for yourself!
Thanks for reading – have a question or comment? Post them below!
Written by Jesse Aaron; a professional blogger with a passion for homebrewing. Follow Jesse on Google Plus.