Monthly Archives: April 2012

IJF 2012 in Perugia

I have just come back from the International Festival of Journalism in Perugia where I participated in more than 40 discussion panels and workshops in 4 days. I am amazed  how my brain managed to squeeze so much new information about the current and the future state of the media in Europe and not only. A part from really really bad internet connection at the festival, the organization, including very helpful volunteers and staff, was simply great. I will dedicate a few more separate posts about the most interesting workshops and speeches I have attended.  I am already missing Perugia and can’t wait to join the festival next year.

Labour costs per hour in EU Countries in 2011

26 April Eurostat published a news release on estimated hourly labour costs in 27 EU countries in 2011. The highest salary per hour was estimated in Belgium ( 39,3 EURO) and the lowest in Bulgaria with only 3,5 EURO per hour. According to the report, labour costs are made up of costs for wages and salaries, plus employer’s social contributions. The estimated results covered companies with more than 10 employees and are based on the 2008 Labour Cost Survey and the Labour Cost Index.

Labour cost index  is a short-term indicator that shows the development of hourly labour costs received by employers. It is simply calculated dividing the labour cost by the number of hours worked.

Labour Cost Survey  gives structural information on labour costs. The survey is conducted every four years. The
most recent LCS refers to information for the year 2008.

Please not that data for Romania and Spain for 2009 and 2010 were not estimated by Eurostat, but were provided by the Member States. Also the data for Greece and Romania are from 2010, the data for last year is still not available.

Details to the table:

Belgium 39.3 EURO

Bulgaria 3.5

Czech Republic 10.5

Denmark 38.6

Germany 30.1

Estonia 8.1

Ireland 27.4

Greece 17.5

Spain 20.6

France 34.2

Italy 26.8

Cyprus 16.5

Latvia 5.9

Lithuania 5.5

Luxembourg 33.7

Hungary 7.6

Malta 11.9

Netherlands 31.1

Austria 29.2

Poland 7.1

Portugal 12.1

Romania 4.2

Slovenia 14.4

Slovakia 8.4

Finland 29.7

Sweden 39.1

United Kingdom 20.1

Norway 44.2

Journalism 2.0 by Mark Briggs

The book is written by Mark Briggs – a sportswriter who works as an Assistant Managing Editor for Interactive News at the News Tribune in Tacoma, Washington. The book “Journalism 2.0. How to survive and thrive. A digital guide for the information age” gives a good overview of the web 2.0, news reporting methods online and basic ideas on how to blog better or produce basic video editing and script writing. What I liked about the book is that at the end of each chapter there are few practical assignments that help you practice a bit what you have learnt.

Journalism 2.0 is freely available online

INFOgraphics: BRIC in comparison

BRIC often refers to the countries of Brazil, Russia, India and China, which are at a similar stage of newly advanced economic development. It is also called the “Big four” or the “Bric countries”. The data for the infographic was taken from Central Intelligence Agency .

World in Numbers

Created with Creatly, data partly taken from Economist, ITU and World Bank.

My first audio slide show ever made and it is in German.

Thanks go to Gabriel Dominguez – my partner during The Online Project Week.

Mehr als nur Lernen?

Integrationskurse werden seit deren Einführung im Jahr 2005 als die wichtigste integrationspolitische Fördermaßnahme des Bundes bezeichnet. Doch der 600-stündige Kurs, der sich an Menschen mit Migrationshintergrund richtet, bietet mehr als nur Deutschunterricht. Er umfasst auch Fragen der deutschen Rechtsordnung, Geschichte und Kultur. Gabriel Domínguez und Evgenia Belyaeva werfen einen Blick hinter die Kulissen, befragen in der Volkshochschule Köln Verantwortliche und Teilnehmer eines solchen Kurses und kommen auf überraschende Ergebnisse.

Deutsche Welle Fans on Facebook

Deutsche Welle has thousands of fans on Facebook who want to stay up-to-date with DW’s news. The idea behind the graph is to see what DW department has received the biggest number of “likes” on Facebook so far. Click on the map to see the exact figures. If you can not see the visualization, you might need to install the latest Java plug-in or the latest version of Adobe Flash Player on your computer.

The creation of the Treemap Chart, using an open source tool Many Eyes in 4 steps:

1.  First things first. I had chosen my data  by simply searching for “Deutsche Welle” on Facebook. This time I manually added the relevant data set to an excel file.

2.  I uploaded my data set on the Many Eyes website.

3.  I then chose Treemap Chart that I found suitable for the visualization of my data set. On the website there are various visualization options including bar and pie charts, matrix charts, stack and line graphs, tag cloud and world tree etc.

4.  Last but not least. I customized, saved  and published my visualization on the website. You can also easily embed it to your blog or website and what is what you see on my blog.


Open Source Tools for Media people

Here is a short list of open source tools that I, as a beginner data journalist, have been using to create maps, timelines, charts and other exciting stuff since a year or so. Journalists, media experts or just anyone attracted by new freely available online technologies will, hopefully, find this list useful. My list is short because it is impossible to keep track of all the new tools that appear online with a faster-than-light speed and to be equally good at all of them. So I have chosen only 7 tools as a start that have become an important part of my DNA.

Google Refine  – a must-to-know online tool to clean your messy data, to transform your data into different formats and to do much more.

Tableau Public  – another great  tool that helps to create interactive visualizations of your data and publish them online.

ManyEyes  – a good open source visualization tool developed by IBM. All you have to do is upload your own data sets or use a pre-existing one on the site, choose among many options the visualisation and enjoy the results. Similar tools include Factual , Socrata, iCharts, ChartTool and ChartGo.

Wordle  – a free tool that transforms your texts into colorful word clouds. Here is more information from their website on what the tool does:

Wordle is a toy for generating “word clouds” from text that you provide. The clouds give greater prominence to words that appear more frequently in the source text. You can tweak your clouds with different fonts, layouts, and color schemes. The images you create with Wordle are yours to use however you like. You can print them out, or save them to the Wordle gallery to share with your friends.

Dipity  – one of my favorite free tools online that allow you to create timelines and add various links, pictures, text to it. It is very easy to use and edit or embed it to your blog or website, once you have an account.

Youshikoder  – is for those who love  to perform content analysis, including keywords search and count, in various languages.

TextAnalyzer  – a free online tool that helps you to find and count most frequent phrases in different languages

Divorce rate in Europe 2010

The following map, created on TargetMap, shows a divorce rate in Europe in 2010. The Data was taken from ROSSTAT – Russian State Institute of Statistics.

As seen on the map, the divorce rate in Europe, especially in countries like Italy or Ireland is much lower than in Russia. A majority of European countries usually have compulsory waiting periods before the finalization of a divorce. They also have compulsory counseling that must be followed by the divorcing couple prior to finalization of the divorce. These are only two reasons behind the lower divorce rate in Europe. In addition, in countries like Poland or Spain, there is a huge percentage of Christians, who usually do not look to divorce as a solution to a problem in a marriage.

INFOgraphics London 2012