For week 29, #MakeoverMonday we are visualizing the changing frequency of Americans. Original Article was published by @washingtonpost and data is sourced from General Social Survey. Here is the original chart:

Data is available on data.world

Whats Good

  • Title and subtitle for the chart is precise
  • First and last year is highlighted in bold
  • Labels explaining what chart means

What I did:

  • Continued using original line chart as it was simple and crisp
  • Aggregated the frequency into 3 categories from the data
  • Allowed users to highlight Sex Frequency using parameter actions
  • Inspired from design used by Andy’s viz
  • Tooltip to show % response for all years
  • excluded 2012 data as it appeared to be wrong

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

Click here for Tableau file

Thanks Eva Murray , Sarah Bartlett 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.

Last week on #Workoutwednesday2019 challenge was given by Curtis Harris and it was about trying out one of the material design concept for data visualisation. It was simple line chart with few twists to highlight temperature of the city and highlighting current month of the year.

Requirements:

  • Dashboard size 1000×800
  • All elements should be in a vertical container, except for the filter
  • Provide 150px padding on all sides of the vertical container
  • Make sure values display the degrees symbol as a suffix
  • Axis should display marks every 20 degrees, and should provide context to the reader at the top most mark
  • Add a reference line for the current month, that will update automatically as the year goes on
  • Add a circle over the point in the lines that represents the current month’s average temp
  • Add a label for the hottest city, in the current month, for all of the cities in the view
    • If you filter out Phoenix, the label should move to Salt Lake City
  • Add a simple color legend that updates as the filter changes
  • Turn off tooltips – not necessary for the challenge

Data for the workout can be downloaded from here

Here is my output for the challenge (Click on gif for interactive version):

I will try to provide step by step guide to re-create this dashboard and complete the challenge:

STEP 1: Creating calculated fields

After Importing the file into Tableau, we need to create 2 calculated fields:

First one is to identify the current month (month of the year):

Second one is to calculate average temperature for the current month:

Step 2: Create sheet with city names

Drag City to column and color in marks area then sort by average temperature

Add filter of city and apply for all the sheets (as shown below image)

Step 3: Create sheet with Line chart and reference line:

Drag Month to columns, select to show months and set to continuous by right clicking the month

Drag Average temperature, set to minimum and select line chart from marks area then drag city column to color

Drag our calculated field Today’s month temp to rows, set to minimum and select circle from marks area then drag city column to color and Today’s month column to detail area.

Then select dual axis by right clicking Min(Today’s Month temp) and synchronize the axis.

Add Reference Line to point degrees in Fahrenheit and add reference line for current month

Format the label to display maximum temperature of the selected filters of city

Step 4: Integrate into dashboard

In dashboard select vertical object and drag to dashboard then add inner padding of 150 from each side.

Add the title, Line chart sheet, and city sheet to make dashboard look like below screen shot:

And we are ready with final visualization as show above.

Click here for Tableau file

Thanks Curtis Harris 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.

For this week #MakeoverMonday week 28, we are looking at asylum applications in EU by people outside of EU.

The original viz was published by EASO based on data from Eurostat and it looked like below image:

 

Original
Original Chart

 

Data is available on data.world and source of data was EUROSTATS.

 

Whats good?

 

  • Interactive Map allowing to select countries and year
  • Tooltips providing informative insights
  • Bar charts to show gradual rise on applications
  • Dynamic texts on dashboard

 

Here is what I did:

 

  • Focused on applications received, rejections and positive decisions
  • Chose Donut chart to present data (tried block bar donut but due to lack of time used donut chart) based on country and year
  • Added dynamic text and color to explain the legends

 

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

 

Capture

 

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.

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.

Community #WorkoutWednesday challenge this week was set by Donna Coles and it was about Pareto chart with certain twists. Here, Requirement was to create Pareto chart to see what proportion of customers make up sales with an option of sliding parameter and few tooltips to make it user friendly along with ease of understanding.

Requirements: 

  • Dashboard 800 x 800.
  • Selection of the Sales Percentage slider will adjust the highlighted point.
  • Sales Percentage slider should increment in 10s from 10%-90%.
  • % values displayed to 1 decimal point.
  • The Sales Percentage mark highlighted should be the value that is at least the value selected in the slider (eg when 60% is selected, the mark highlighted is 60.1% as the previous mark is 59.9% which is less than the slider value).
  • The tooltips on the curve differ from that on the highlighted mark.
  • The tooltip on the highlighted mark should also indicate the actual number of customers at that point, as well as the total number of customers.
  • Rebuild everything to be identical, matching titles, tooltips, chart formatting.

Data for the workout can be downloaded from here

Here is my output for the challenge (Click on gif for interactive version):

Here are the steps which I undertook to create this dashboard and complete the challenge

Step 1: Create the Parameter as per requirement to select Sales %

Step 2: Create calculated fields required to create the visualisation and calculations

My attempt was to create the dashboard with minimum steps. I created 6 calculated fields + 2 copies of calc fields

% of customers: On X-axis we need to show the running % for distinct customers

% of Sales: on Y-Axis we need to show running % for sales

Customer Point: This field is to show “% of customers” when “Sales %” is >= “% of Sales” field

Dot: Here we will use lookup function to find previous value of “Customer Point”. This field is to circle the position and highlight % of customers basis of % of sales (if 80% sales is selected then to show point at 49.9%)

Fixed Customers: This field to count the distinct number of customers

Sales Point: This field was more of after thought after re-looking at the requirements. This field we will show “% of sales” when “Sales %” is >= “% of Sales” field (if 80% selected then to show 80.1%)

Then, duplicate the “% of customers” and “% of Sales” Field for the purpose of tooltip and format this with 1 decimal point.

 

Step 3: Create the Sheet for the viz

Drag “% of Customers” and “Dot” field to column shelf then drag “% of sales” to row shelf

Select Customer Name and drag that field to details in Marks area then sort the field descending by sales

Select the graph type as “Area chart” for “% of customers” and “Circle” for “Dot” Field

Now, select “Dual Axis” on Dot field on column shelf then synchronize the axis and remove the “Measure Names” from color shelf

select “Grey” color for the area chart and “Black” color for circle Chart

For the reference lines on sales & customer, drag “Customer point” and “Sales Point” to Marks area

Right click on Y-axis and select add reference line, then select sales point from drop down and set as minimum

Similarly, Right click on X-axis and select add reference line, then select Customer point from drop down and set as minimum

Post this step, your viz is ready and will look like this:

Tooltip: drag “% of sales” , “% of customers”, “Fixed customers” into marks area for “Dot” field and additionally we will have distinct count of customer id on the basis customer name then we will modified the tooltip to see our requirement

Format the sheet and clean it up to meet the requirements and add the sheet into dashboard with few cosmetic changes.

And we are ready with final visualization as show above.

Click here for Tableau file

Thanks Donna Coles 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.