09 April 2014

How to create polygon map based on image in Tableau

This tutorial is based on the same way of thinking which is used by ShapeToTab. Creating ShapeToTab results without using ShapeToTab lol. In other words it is very easy to do :) 

We will be creating a map of shopping centre.

Gazprom's natural gas export structure to European and FSU countries in 2012

The largest buyers of the Russian gas were Germany (16% of Gazprom's export), Ukraine (15%), Turkey (12%) and Belarus (9%).
Gazprom Group in 2012 sold in total 151 bcm of natural gas to European countries and 66 bcm to FSU countries.

The data have been published by Gazprom in Gazprom in Figures 2008-2012

06 March 2014

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.

21 February 2014

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.

08 February 2014

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).


02 February 2014

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.

23 January 2014

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.

07 January 2014

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...