For Makeovermonday week 24, it was about Tourism density index i.e. how many tourists come to country compare to population.

Here is the original viz by Intrepid Travel:

Data is available on data.world week 24:

Here is what I did:

  • Got the idea of ratio from Eva’s Blog and tried to show number of tourists per 100 local people
  • Used rows and columns method using groups in dataset (inspired by Andy’s output)
  • Make it easier to see for each country given in dataset

Click on the viz to use the interactive version.

Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.

Do subscribe to Tabvizexplorer.com to keep receive regular updates.

This week in #makeovermonday, it was tough and sensitive topic on Gender pay gap in UK.

Data was shared by Gov.uk

Here is the original report and how it looks:

Graphic displaying the mean bonus pay gap for HMRC

 

Data is available on data.world week 23.

Here is what I did:

  • First attempt I tried to create few calculations and pivot the data within Tableau to create bar charts which did not yield any productive output
  • I tried working with scatter plots and various other form of visualisation but was missing something
  • Final attempt was to create a gantt chart to show difference in male to female ratio in different pay scale quartile.

Below is the screenshot of Tableau file (click on Image for interactive version):

Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.

Do subscribe to Tabvizexplorer.com to keep receive regular updates.

This week in #makeovermonday, we are looking at real estate’s price data to see World’s most expensive prime property.

Data was shared by The world Economic Forum (weforum)

Here is the original report and how it looks:

 

Data is available on data.world week 22.

Here is what I did:

  • Use of simple chart to show the how big a place can be acquired in $1 million USD. I thought to display data in rather simple way then to complicate things.

Below is the Tableau file:

Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.

Do subscribe to Tabvizexplorer.com to keep receive regular updates.

This week in #makeovermonday challenge was Sports data i.e. English Premier League data which looks into predictions and actual outcomes of the season 17-18.

Data was shared by the Guardian

Here is the original report and how it looks:

 

Data is available on data.world week 21.

Here is what I tried to do:

  • Used gann and circle chart from tableau to display the results of actual vs prediction and highlighted both of them using different colors to make it self explanatory.
  • This will help to make inference about how many prediction were on target and how many off target.

Below is the Tableau file:

Thanks!!
Do subscribe to receive regular updates