VizWiz

Launch, grow, and unlock your career in data
Showing posts with label pages. Show all posts

September 12, 2023

#MakeoverMonday Week 37 - First time home buyers in the UK are being shut out of the market

No comments
Have you ever heard of the "sunken cost fallacy"? If you haven't, it is where you continue a task based on previously invested resources, such as time, despite new evidence suggesting that the cost, beginning immediately, outweighs the expected benefit.

This is what nearly happened to me during Watch Me Viz. I was convinced I had created the perfect chart. That is, until comments started coming in to the contrary. I had gotten so fixated on this one chart that I thought all other ideas were inferior.

I snapped out of it eventually and turned my attention to another chart that told the story much better.

The lesson learned: be careful of, and attuned to, sunken cost.

With that, here's Watch Me Viz for you to follow along and learn lots about Tableau.


March 22, 2021

#WorkoutWednesday 2021 Week 11 - Gapminder: Income vs. Life Expectancy

No comments

As Lorna mentions in the week 11 challenge, the key is in the data prep. Once you have that, the visualization is really simple.

I did not use the new relationships model; I stuck with the traditional method of unions and a join as that's the most straightforward way to ensure you get the data in the correct shape.

First, you want to union together the three CSV files: life expectancy, population, and income. When you do that, you'll get this strange looking view that is super wide and doesn't have headers that mean anything. 


What you should see, though, is that the headers are in the first row. To fix that, click on the drop down triangle next to the unioned data sources and choose Field names are in first row.


The years are nicely in the headers now. The next step is to select all of the columns with the years and pivot the data. Be sure to ONLY select the years.

I then renamed Pivot Field Names to "Year" and changed the data type to Number (whole) and also renamed Pivot Field Values to "Values".

Next, add the data source with the list of countries and drag it into the data prep area to create a join. You want to join "country" to "name". And now everything should look good. That's it for the data prep.


Now that the data is pivoted, in order to build the view, you need to create a calculated field for each measure: life expectancy, population, and income



All three calculations are the same. All you need to do is swap out the name of the csv. Lastly, build the view.


Note that the x-axis is a logarithmic scale and both axes have the option to start at 0 turned off.  That's it! I hope you found this helpful.

May 23, 2017

Tableau Tip Tuesday: Two Methods for Creating Dashed Lines

9 comments
This week's tip is a demonstration of how Eva Murray created the dashed lines in her Makeover Monday week 21 viz. In this video, I demonstrate Eva's method (via table calcs) as well as the way that I'd always done them with the Pages Shelf.

September 6, 2015

Dear Data Two | Week 15: Compliments

No comments
Just realized this is my 500th post on this blog.  Feels like quite a milestone for some reason.  Anyway, for Dear Data Two | Week 15: Compliments, like Jeffrey, I looked at my content that people liked across social media platforms (assuming that I can take those like, favorites, reshares as compliments).