Die grössten Waffenexporteure und Importeure 2009-2013

The easiest and cheapest way to learn Tableau

My tips for people who want to learn Tableau without any budget :)

1. Training & Tutorials on Tableau's website

Select 'On Demand', you have to create an account but it's free and you don't need to be a Tableau customer. The tutorials are selected into few groups Intro, Advanced, Chart Types, Server. It's the best place to start learning.

Check 'Live Online' out too.

Tableau's Knowledge Base – hundreds of tutorials are divided by topic.

Each short tutorial gives answer to a problem, it's good to check the titles and do tutorials which can be useful in your work. The list look like a never ending story but no reason to be in stress as most of things you will learn doing 'On Demand' tutorials.

How to get Latitude and Longitude (geographic coordinates)

You need Latitude and Longitude of a place (address, city, etc.).

There is a good tool for each life situation, so let's check the possibilities.

1. You have a few thousands of addresses and you need its geographic coordinates. The answer is Batch Geocoding.

Total % of internet users

Cross-stitching is good for everything also for presenting data. One of the most sophisticated ways of working with data ;)

In 1994 five people out of 1000 had access to the internet, in 2012 36 out of 100.

We are in the point when one third of world's population uses internet, it is symbolised by the person in the pink t-shirt (one out of three).

Bill Gates, poverty and snack

Bill Gates wrote to me to inform how the world has changed since '89. To be honest he just tweeted :) so no reason to keep this confidential: Gates annual letter.

The most interesting to me was the chart showing change in percentage of people living on less than $1.25 per day, so I decided to create my version, check both.

QGIS basic tutorial 2 - merging administrative divisions

Let's analyse a situation, you have a data set and you have something, what looks like the matching shape file, you think cheerfully that the data set will fit to the shape file like a hand to the glove. Unfortunately, life isn't so easy. Some shape files aren't updated regularly, it is common that administrative districts with low population density are joined to the neighbouring districts. It is worth to compare the number of districts in your data sets with the shape file. If you see any gap, try to find information about changes, so you will know which districts should be merged.

QGIS basic tutorial 1 - attribute table, sorting, filtering

I use QGIS to prepare shape files for creation of maps in Tableau. Some shape files demand changes to match my Tableau projects so I decided to share few tips how to work with them.

In the tutorial I work with QGIS 2.0.1. and the shape file of Ukrainian administrative districts from GADM.

Terrorist attacks in Russia since 1991

The researchers at the University of Maryland have created the world's largest database of terrorists attacks.
Between 1991 and 2012, there were 1,895 attacks in Russia.

In my dataviz I used data published by the Guardian.
I would like to add the data for 2013, hope to get them somewhere...

Map of the Netherlands by gemeenten

I have done this map of the Netherlands by municipalities (second level of administrative districts) for http://tableaumapping.bi
Tableau Mapping is a project, where volunteers share their maps produced from shape files, so all Tableau users can use them.
It is a Christmas gift from me :)

How to create map in Tableau with ShapeToTab

Prepare environment for work in ShapeToTab (created by Richard Leeke)

download ShapeToTab from http://dl.dropbox.com/u/59458890/ShapeToTab.zip 

download release-1600-gdal-1-9-0-mapserver-6-0-1 from http://www.gisinternals.com/sdk/PackageList.aspx?file=release-1600-gdal-1-9-0-mapserver-6-0-1.zip
Unzip both and place them on your computer.

ShapeToTab consists of (my system is not in English, sorry):

Migration between prefectures of Japan in 2012

You can check flows of the three streams:

1. In-migration: the Japanese moving into one prefecture from another place within the country.
2. Out-migration: the Japanese moving out of one prefecture to another place within the country.
3. Net internal migration: the difference between in-migration and out-migration.

How to create choropleth maps in Tableau from shape file

Tableau gives the possibility to easily create polygon maps at country and province levels. But what if you want more? Suppose you want to create a map of a city by boroughs or country by counties? There are easy solutions available [that why I am writing this post :) ]

The most cycle friendly European countries

The Netherlands and Denmark have been named the most cycle friendly countries in Europe by the European Cyclist Federation (ECF).

Countries were judge on five criteria:

1. market (bicycle sales per 1000 inhabitants)
2. modal share (cycling as main mode of transport % of population)
3. activists (ECF individual members per million inhabitants)
4. safety (number of death per 100,000 cyclists)
5. tourism (total trips per head)

Points were awarded based on a country's ranking in each category and added to give the overall scores.

Crime in London

This post was created thanks to London's Metropolitan Police, that published crime data for London's boroughs. Their data base consists even such details like number of stolen bicycles.

Crime rates (Rates per thousand population) were calculated according to: (crime / the resident population)*1000. Many boroughs have very high daytime population, so the resident population is only a fraction of the daytime population and that makes the crime rate so high in some boroughs.

Hope to see such data for other cities.

Preliminary result of the elections to the 18th German Bundestag

In German's voting system every voter gets two votes. The first allows voters to select candidate in their district. The second is for the party they support.

Zara comparator

Zara sells its products online in 23 European countries, Japan, China, the United States and Canada. Today online shop has been opened in Russia. I have compared prices of few items.

Immigration map of Berlin's neighbourhoods

The data were published by Statistical Office for Berlin-Brandenburg. There are many detailed data sets about Berlin's neighbourhoods on the website (in German :))

New York City Population by Boroughs

New York is the most populous city in the United States, more than twice the size of the second largest city, Los Angeles.

In the period from 2000 to 2010 all five of New York's boroughs saw growth:

• Staten Island 5.6%
• The Bronx 3.9%
• Manhattan 3.2%
• Brooklyn 1.6%
• Queens 0.1%

Differences in price levels for food, beverages and tobacco across Europe

Eurostat published Comparative price levels for food, beverages and tobacco.

Denmark had the highest price level for food in the EU27 in 2012, at 139% of the EU27 average, followed by Sweden (124%). The lowest price levels were observed in Poland (60%) and Romania.


Abbreviations:
HFCE - total household final consumption expenditure
EA17 - the euro area
EU27 - the European Union

Mysterious Lake Baikal

The Lake Baikal is not so mysterious anymore, one riddle has been solved, how infrastructure for eco-tourism was created.

The Great Baikal Trail was created to develop system of environmental trails around Lake Baikal. The projects are based on work done by volunteers from all over the world; Russia, Australia, Germany, Spain, Italy, France, the Netherlands, United States, Canada, Mongolia, and many more places.

To show the amount of work done in different areas of the lake I used:

• number of volunteers involved,
• man-days (=number of volunteers*number of projects' days).

I encourage you to interact with my visualization and take part in the Baikal's projects.

This data visualization is truly international:
- The data are from The Great Baikal Trail, a Russian interregional community organization.
- I am taking part in Tableau Software contest, which is open to residents of few countries so I am representing Germany :)
- The viz was done with use of American software and Russian Yandex maps :)