VizWiz

Data Viz Done Right

August 23, 2017

Workout Wednesday: The Waffles of Disney's Domination

No comments
Oh Emma! She thought she could trick me today. Mind games I say! Today's workout is to create waffle charts. Read all of the details here.

The waffle chart bit was pretty straight forward. The trickiest part for me was the calculation to get the % of total.

Fun one! Give it a go!

August 22, 2017

Tableau Tip Tuesday: Using Actions to Highlight on Hover

No comments
During the Makeover Monday Viz Review for week 33, Eva and I were reviewing this viz from Sarah Bartlett.


We recommended that Sarah include a highlight action so that the user can click on a State on the right and highlight the corresponding line on the bottom right. Sarah commented that she wasn't sure how to do this and Eva volunteered me (as she does) to make a video.

This week's tip will show you how to use highlight actions to hover over a State and highlight it in the line chart. I also show how to include a label on the end of the line. Enjoy!

August 21, 2017

Makeover Monday: The Monthly Latitude Range of Solar Eclipses by Century

No comments
I'm not going to lie, I really struggled with the data set this week. It seemed everything I tried either wasn't interesting or didn't show anything particularly good. That happens I suppose and I'm ok with that.

This week we looked at this viz of thousands of years of solar eclipses:


What works well?

  • Fantastic interactivity and drill down capabilities
  • Showing the paths of each eclipse along with the partial eclipse breadth
  • Coloring each eclipse type
  • Leveraging Google Maps so the user can customize the map to their preference
  • Good explanations above and below the chart

What could be improved?

  • Remove the labels on each line to declutter the map
  • Avoid a repeating map
  • Include a more impactful title

My Goals

  • Explore the data to find some interesting analysis per Eva's request
  • Build lots of views to see what pops
  • Simplify the view to reduce complexity and clutter
  • Compare northern to southern hemisphere
  • Use colors that are clearly distinguishable

As I mentioned, I really struggled. I built lots of view and probably hit undo 200 times. I didn't like anything. I sent a few complaining messages to Eva and she essentially told me to suck it up. Tough love indeed!

Finally, I decide to create a calculation to aggregate by century and then created an LOD to return the max and min latitude in any given month within the century. By any given month, I don't mean month/year, I mean month. So what is the average of all Januarys, Februarys, etc. and then what is the max of those values. I then compared that to max to the min to determine the range.

I don't love it, but I'm done. I've struggled enough.

August 16, 2017

Workout Wednesday: How has your home price changed?

2 comments
Inspiration for this week's Workout Wednesday comes from this great post by Curtis Harris. Of course with this being Workout Wednesday, I've added a few twists. In all, this took me about 45 min.


First, you can find the housing index data here. You will need to do some minor data prep. Curtis has some hints in his post if you get stuck.

REQUIREMENTS:


  1. The data is displayed as the monthly percent change in the house price index based on the date chosen above the chart.
  2. The State selected must be highlighted in the greenish color (#3B6F84).
  3. The US average must be highlighted in black.
  4. The most recent value should be shown on the end of the selected State and the US average.
  5. All States must be in the view. All States that are NOT selected should be thin and grey.
  6. Include a reference line for the month selected and include a dot at that point.
  7. Match all of my titles and formatting. Note that the chart title is dynamic.
  8. Match my axes.
  9. Match the footer (except replace my name with yours).
  10. Be sure to tag Curtis (@Harris7Curtis) so he gets credit when you publish it to Twitter.

Good luck!!

August 15, 2017

Tableau Tip Tuesday: How to Create a Trend Line for a Single Dimension Member

2 comments
This week's tip comes from Eva's Makeover Monday week 33 in which she created a trend line for a single member of a dimension. She asked me how to do this and encouraged me to share it with all of you as well.

Enjoy!

August 13, 2017

Makeover Monday: How Has the Number of Births Changed Since Your Baby Was Born?

No comments

If this data set and viz look familiar, it's because I highlighted it a few weeks ago on DataVizDoneRight and it was also the source for Workout Wednesday Week 31.

What works well?

  • Incredible interactivity
  • Amazing storytelling as your scroll down the page
  • Great use of minimal colors for highlighting
  • Great use of context
  • Nice example of stepped lines
  • Including a link to the source
  • Good placement of the filters at the top to encourage the user to use them first
  • Including event icons which update the viz based on the year you're viewing
  • Great annotations

What could be improved?

  • Could use a more impactful title

This is such an amazing viz and a pretty interesting data set. I'm curious to see what else the Makeover Monday community can come up with.

My Viz

I also recently highlighted a viz by Curtis Harris (my review / his viz) that I have been wanting to try to recreate. While this data set isn't the same, it's the technique and design by Curtis that I wanted to mimic. Thanks Curtis for the inspiration!

With that, here's my Makeover Monday week 33, in which I look at the number of babies born by State since your baby was born.

August 9, 2017

Workout Wednesday: Continuous Dates are Tricky

4 comments
Emma sure can be devious! Don't let that smile of hers trick you. Today her challenge was to create this chart:


Her requirements are pretty straightforward. I was able to get everything quickly with the exception of the month labels on the x-axis.

FIRST ATTEMPT

To do the line chart, I created a Day of Year calc and plotted that on the x-axis. Notice this results in the day number on the scale.



SECOND ATTEMPT

To format the scale, I first changed the number format to mmm to give me month abbreviations. That gets me close, but some months are missing and the months are labeled at the middle of the month whereas Emma's are labeled at the start of the month.


THIRD ATTEMPT

I sent Emma a message with a few questions, basically because I was stuck. All she said was:
You'll have to re-think the date you have on the x-axis so you can also colour by year.


What does that even mean? I'm beginning to get a sense for the sort of torture I put people through. Ok, so I somehow need to get my x-axis to act like a date, yet still be able to show every day for each year in the view. I also need it to only be month and day. Hmmm: Hey Google, can you help?

Yes indeed! I searched for "tableau month and day of year" and the second search result took me to the Forums which had exactly the question I was asking. The brilliant Jonathan Drummey came up with this formula:

DATE(DATEADD('day',DATEPART('day',[Date]),DATEADD('month',DATEPART('month',[Date])-1,#1903-12-31#)))

Sweet! All I needed to do was swap out [Date] for [Order Date] and I was good to go. Now I have the exact result I needed.

Awesome challenge! I love learning something new! Here's my final product.

August 7, 2017

Makeover Monday: How has access to toilets changed for girls in India?

No comments
Eva picked quite an interesting and important topic this week for Makeover Monday week 32 - access to toilets for school girls in India. Coming from a western country, girls and boys have always had equivalent access to restroom facilities, so the topic itself has been a good learning experience for me. I hope this week the Community can make some really impactful vizzes.

Let's have a look at the original:


What works well?

  • The filled map helps you easily identify which States fall into which categories.
  • The colors work well together.

What could be improved?

  • The title doesn't make sense. What does access over sanitation mean?
  • Sanitation is spelled wrong in the title.
  • The legend is cut off.
  • Making comparisons across the maps is nearly impossible.
  • Making comparisons across years IS impossible.
  • There's a lack of explanation as to what the data means.
  • There's a lack of insight.
  • Labelling each State makes the maps look very cluttered.
  • There's no call to action.

My Goals

  • Provide insight as to which States have gotten better
  • Use a more meaningful metric rather than separating the two metrics
  • Simplify and declutter the visualisation
  • Highlight what's important
  • Emphasize the inequality of access to toilets for girls

With those goals in mind, here's my Makeover Monday week 32.

August 2, 2017

Workout Wednesday: The Timing of Baby Making

No comments
WARNING: This weeks workout won't be as easy as it may look. If you're anything like me, by the end you'll be saying stepped lines can't come into Tableau soon enough! It's good practice to know how to actually make this chart without that feature though. Anyone know when stepped lines are actually coming BTW?

This data set first caught my eye a few weeks ago and I highlighted it on my Data Viz Done Right site. Your task this week it to more or less replicate the stepped line chart in Tableau as I've done. Here are the requirements:

  1. Create the stepped line chart (HINT: I didn't do this only with lines).
  2. Match the dynamically updating title. It changed when you pick a single county vs. all counties.
  3. Each stepped line represents a year.
  4. Allow the user to pick a year to highlight in black. All others should be grey.
  5. Match my tooltip (easy peasy).
  6. Label only the end of the line that is highlighted.
  7. Match my axis lines.
  8. Match the month formatting.
  9. Final dashboard should be 800x500 and should be all tiled (no floating elements)
  10. Optional: Match my font throughout (Avenir)

If I missed anything, let me know and I'll update the requirements. This will likely be a fiddly little beast. Download the data here. Leave a comment when you finish and/or tag @VizWizBI and @EmmaWhyte on Twitter with a picture and a link.

Good luck! 

July 31, 2017

Makeover Monday: The 28th SEA Games

No comments
I'm currently on holiday in Tuscany, Italy, so please excuse my brevity this week. In fact, I'm going to admit that I cheated. I reused a viz I did for Makeover Monday last year. I liked it then, I like it now. I don't see any harm in doing this when pressed for time.

Let's have a look at the original viz:


What works well?

  • The different backgrounds for the sections help split apart the viz and inform you that they are to be read independently.
  • It's very informative about the games overall.

What could be improved?

  • The parts are all disjointed.
  • There's no overall story.
  • When I ask "so what?", I can't answer it.

Again, sorry for the brevity this week; I really need to be spending time with my family. Here's my Makeover Monday submission.