You are browsing the archive for etl problems.

Data Roundup, 26 March

- March 26, 2014 in Data Roundup

Eowyn_86 – Salvem La Balena / Save The Whale

Tools, Events, Courses

It is true that JSON is increasingly becoming the standard when it comes to API formats, but what if you need to convert it into a much more organized CSV file? Thanks to Eric Mill, now you can do it quickly with this tool. Read more about it in “Making JSON as simple as a spreadsheet”.

Data Stories

Dave Guarino tells us what ETL problems are and how we can succeed in solving them when we have to collect and re-organize datasets lost God-only-knows-where in the Web.

What is the difference between data storytelling and data narratives? Dino Citraro from Periscopic explains it in his short and brilliant post “A Framework for Talking About Data Narration”.

It has not even been a week since the launch of Nate Silver’s FiveThirtyEight, and it is already attracting criticism from influential experts in the field, both journalists and not. If you are interested in reading a roundup of these opinions, take a look at Alberto Cairo’s blog and at Mark Coddington’s article on the Nieman Journalism Lab.

The most honorable use of data collection and analysis is certainly that which helps people improve their life. Katie Fehrenbacher recently posted an article on Gigaom on how data can fight human trafficking around the world which absolutely deserves to be read.

Have you ever wondered how our brain stores information? Do you want to know what is the main task of your hippocampus? Find all the answers in this infographic published on the Daily Infographic.

What prevents the emergence of open data-driven businesses in emerging countries? Is it possible to fuel innovation in these states through the establishment of a new investment fund? According to Prasanna Las Das from the World Bank Data Blog, this is the right time to do it.

Data Sources

Public transportation means are not always easily accessible by anyone. There could be people with difficulties (disabled or injured persons) which do not allow them to move freely on a metro. Mappable recreated an interesting series of maps showing those metro stations in Hamburg, London, and New York which are considered to be wheelchair accessible.

The article also contains a link to Wheelmap, a web app developed to monitor and display wheelchair accessibility around the world.

There are always experts that give useful suggestions on how to deal with open data, but these ones actually come from the father of the Web, Tim Berners-Lee, and you may not to miss them. If you read this 5-star deployment scheme, you will find interesting insights on the costs and benefits of web data.

To celebrate the World Water Day, the US open data portal data.gov released a series of datasets related to American coasts, oceans, and lakes that you can browse in data.gov/ocean.

Credits

Thanks to @jalbertbowdenii @zararah @DataAtCU

Flattr this!