#MakeoverMonday | Data Visualization | Tableau

#Makeover Monday wk 26 – 2019 – Alcohol Consumption per Capita

This is my first post after a long time, was busy with migration to new country with finding new job, to find house and settling into routine. Here we are with Week 26 for #MakeoverMonday. Today’s viz is about Alcohol consumption per capita by Countries which was shared here.

Original Chart

Data is available on data.world and source of data was World Atlas.

Whats good?

  • Clear Axis label on Y-Axis
  • Simple bar chart with one color
  • Clear Title of the chart

Here is what I did:

  • Filtered this to top 5 countries with highest Alcohol consumption
  • Used Image of bottle in the chart
  • Used Bar chart to show top 5 countries with label

Here is the Image of the visualisation I created (Click on image to get interactive version):

Click here for Tableau file

Thanks Eva Murray and Andy Kriebel for this workout.

Happy Data Visualisation!!!!

Thanks for visiting this post. Please do let me know your feedback or if you have any questions about the blog do not hesitate to contact me on twitter (@Desaimithun)

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

#MakeoverMonday | Data Visualization | Tableau

#Makeover Monday wk 32 – How Much Countries Spends on R&D

For #MakeoverMonday week 32, The makeover viz was about how much countries spends on Research & Development and the original viz was shared on HowMuch.net

Here is the original viz :

Original Image

Data is available on data.world and source of data was UNESCO Institute for Statistics

Whats good?

  • Clear Legends on specifying what color in the circle means in terms of spends
  • Design is eye-catching with too much of information for an individual to understand
  • Source of data is mentioned
  • Title which is self explanatory about the viz

Here is what I did:

  • After trying various methods to visualize this data, I finalize one approach of showing Top 10 countries by spends
  • Additionally I wanted show trend on spends by this countries and also compare 2 years i.e. 2015 vs 2014 to show the increase in spends by countries on R&D (Exception was India as dataset didn’t have 2012 to 2014 data)
  • While building the viz and trying to figure out visualization I came across this viz from Rody Zakovich and tried to replicate the similar design.

Here is the Image of the visualisation I created (Click on image to get interactive version):

Click here for Tableau file

Thanks Eva Murray and Andy Kriebel for this workout.

Happy Data Visualisation!!!!

Thanks for visiting this post. Please do let me know your feedback or if you have any questions about the blog do not hesitate to contact me on twitter (@Desaimithun)

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

#MakeoverMonday | Data Visualization | Tableau

#Makeover Monday wk 29 – NBA Team Salaries vs Cap

For #MakeoverMonday week 29, Andy shared the viz from What’s the Cap? and it was designed by whatsthecap. It was about NBA Team salaries and Salary cap since 1985-86. 

Here is the original viz :

Screen Shot 2018-07-15 at 12.46.55 pm.png

Data is available on data.world and source of data was Celtics Hub

Whats good?

  • Interactive tooltips to know the max, min and average salaries and actual salary cap
  • Clean time-series data with 3 distinct lines for highest, average and lowest payroll with bar chart to plot the salary cap which depicts the trend over last 32 seasons
  • Clear Y-axis labeling
  • Use of different colors for each line and bar with legend to distinguish each other

Here is what I did:

  • First of all I used the Andy’s Franchise mapping, since the teams have moved cities and changed their names over last 30 years.
  • I wanted to show all the teams which helps in comparisons and I finalized on bar chart.
  • Added indicator line for salary cap to see how many franchises adhere to salary cap and how many spent above salary cap
  • I wanted to compare franchises salary vs salary cap each season hence I introduced the filter for season
  • Added tooltip and text label to show the variance in Teams salary vs salary cap

Here is the Image of the visualisation I created (Click on image to get 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.