This week in #makeovermonday challenge was about UK’s Favorite Chocolate Bar as we are approaching Easter this week

Data was shared by CDA

Here is the original report and how it looks:

Data is share on makeovermonday.co.uk week 13.

In my attempt I tried to use the sigmoid function and tried to create Sankey chart.

Here is my attempt for #makeovermonday for UK’s Favorite Chocolate:

Thanks!!
Do subscribe to keep receiving regular updates

 

#Makeovermonday partnered with Equal Measures 2030 for week 10 as we approach International Women’s day. This week we will be seeing how good or bad policymakers for 5 different countries are and how much awareness they have with women welfare in the country.

Here is the original dashboard:

I started with playing around with the survey data and create dashboard in simplified way to understand the responses and how well policymakers know the state of women in their respective countries. The requirement and data was share on http://www.makeovermonday.co.uk/data/ for week 10.

Below is my dashboard for #makeovermonday:

Thanks!!
Do subscribe to keep receiving regular updates

In today’s blog, we will learn about Bump Chart in Tableau. A Bump chart is used to visualize changes in rank over a period of time. Bump chart have very simple use and application in Tableau:

For this chart, I have used the world economic freedom data shared for #makeovermonday on http://www.makeovermonday.co.uk/data/ for last week makeover.

Step 1: Import the world economic freedom data into Tableau which I transformed into following format:

Step 2: Create a calculated field called rank on the score field using rank() function of Tableau:

Step 3: Drag Year (convert the Year to date format) to column shelf (I filtered the year from 2006 to 2015) and convert Year into discrete form and drag rank twice into rows. Then drag Index type column into filter and filter for “overall” Type and drag countries column into colors under marktype.

Step 4: For both the rank, change the calculation type by clicking on compute by and selecting countries and change the graph type to dual axis and use synchronise axis to have axis in sync

Step 5: Reverse the axis using edit axis option and change the graph type from automatic to circle for second Rank column:

Step 6: I set the filter for countries as well to display top 10 ranks and few changes in formatting then it will look like below:

That’s it our bump chart is ready

Final output is shared on Tableau public path here

Do subscribe on blog to keep receiving updates.

Thanks 🙂