How can we show the real difference between ‘white’ and ‘black’?!

WHITE dimension vs. BLACK dimension
Marriage vs. Divorce
Natality vs. Mortality
Woman vs. Man
Emigration vs. Immigration
etc.

Let’s take the case that we have monthly data of migrations, i.e. #Emigrations and #Immigrations. In order to visualize the difference between these dimensions we can use Floating Charts.

These floating bars show the difference between migration dimensions.

How can we create such graphs in Excel and in Tableau Desktop?

EXCEL version

Prepare your data set with two main dimensions

Calculate the difference: Emigration …

On Clearly and Simply, Jen’s Blog, and other sites you might have read about Tableau Software’s great capabilities to visualize data on a map. Tableau Desktop allows the use of background image maps as well as latitude and longitude coordinates. If you are mapping US-data, Tableau Desktop’s built-in features enable you to view data split by states or even ZIP codes in almost no time and requires no additional data. However, what do you do when you have the need to view statistics on e.g. Europe? A lot of times …

The daily research of costumer habits or imperfections is almost exclusively an analytics task. Detecting the different interrelations between customer and sales figures could increase real profit by

stimulating particular product group sales
increasing customers flow to the relevant centers
etc.

In order to identify the key factors we should identify the correlation between each dimension. In Excel we have two types of such implementation:
The column chart

The dot chart

I learned about these two types of correlation graphs from Gene Zelazny’s book ‘Say it With Charts’.
The first way, how to graphically depict dependence between main …