27 April 2014

Russian text in Excel lost when saved as a CSV file

This problem could happen to everyone, even to you, maybe not to everyone as not everyone works with Russian text in Excel lol
The problem appears only when you're trying to save the text in a language other than your system's language, so if your system is in Russian and the file consists Russian text, you don't need to worry, this tutorial is not for you.

22 April 2014

Ethnic groups in Russia

Russia is home to over 185 ethnic groups, population of these groups vary from millions to few thousands. In some regions Russians are in the minority.

This topic is rich in data so later I will post more works.

17 April 2014

How to create polygon map based on image in Tableau - plan B

This tutorial is devoted to creating polygon map in Tableau based on image, I've done the tutorial giving similar results here.
Maybe you will find this way easier.

It's a good way of mapping places that aren't strongly connected to Longitude/Latitude. Shops in shopping centres have their geographical coordinates but of course nobody uses them, so map consisting general shapes without details is fine in such situation.

Top 30 countries with the highest military expenditure in 2013

Stockholm International Peace Research Institute (SIPRI) has published military expenditure for 2013. Global military expenditure totalled $1.75 trillion.

Just two states, USA and China, made nearly half of all military spending.


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