Monthly Archives: October 2013

Using Power Query to combine files from Hadoop into a single table (part 1)

Hadoop | HDInsight | Power Query Preview For today’s post, I’m showing a scenario where I want to load some text files from my Hadoop cluster into a single Excel Power Pivot table. For this purpose I created some files … Continue reading

Posted in Allgemein | Leave a comment

OECD PIAAC Study 2013 data available for analysis

Data Analysis | R | Tableau The recent PIAAC study of OECD covers skills of adults in 24 countries. You can find the study results together with background information here: http://www.oecd.org/site/piaac/. The study is very interesting as it is the … Continue reading

Posted in Allgemein | Tagged , , | Leave a comment

OECD PIAAC Study 2013 data available for analysis

Data Analysis | R | Tableau The recent PIAAC study of OECD covers skills of adults in 24 countries. You can find the study results together with background information here: http://www.oecd.org/site/piaac/. The study is very interesting as it is the … Continue reading

Posted in Allgemein | Leave a comment

Power Query: How to unpivot a dynamic number of columns

Power Query A powerful function in Power Query is to unpivot a given data set which means to rotate data in columns to rows. This is useful for a lot of statistical data sets that you will find on the … Continue reading

Posted in Allgemein | Leave a comment