April 1, 2024
#WatchMeViz: Can viral infections be cured with antibiotics?
October 17, 2023
The End of an Era: Watch Me Viz's Decline Unveiled
That's a wrap. Watch Me Viz has retired, for good.
This week's data was about the performance of all of the WMV livestreams. There was some incredible viewer participation, which ultimately led to this viz that explains why WMV should quietly disappear.
Check out the livestream below.
October 9, 2023
Behind the Chart Redesign: Retail Investment Step-by-Step Makeover
Catch up on my latest #MakeoverMonday Watch Me Viz. I dive into a step-by-step redesign of Visual Capitalists "What are Retail Investors Interested in Buying in 2023?" chart.
Starting with an overview of the original visualization, I review the gaps and areas for improvement. Why was a makeover necessary, and what potential did we see?
The livestream walks you through the entire transformation process, from the initial critique to the final touches.
Expect to uncover advanced design techniques and gain insights into the strategic thought process behind each decision.
Whether you're an aspiring designer or a seasoned data analyst, this step-by-step makeover promises valuable takeaways for all.
June 12, 2023
#MakeoverMonday 2023 Week 24 - Cereal and the Green Revolution: Yields vs. Land Use
At the global level, how has crop production changed over the last fifty years?
In this Watch Me Viz live stream, I analyzed how the yield and land use of producing cereal has changed over the last 50 years.
I really liked the original visualization, so I rebuilt it in Tableau. I learned how to use dynamic zone visibility, layout containers, and more. Check it out.
Resources:
1. Data - https://data.world/makeovermonday/2023w24
2. Final Dashboard - https://tabsoft.co/3P3Sdl3
===============
Watch Me Viz is a weekly live stream where I help people become better at #Tableau, #PowerBI and data analysis. I show how I take an existing visualization, critique it, analyze the data, and build several visualizations all the while looking for a "better" visualization than the original.
If you are considering participating in Makeover Monday, you can get started by downloading data sets from the Makeover Monday website. I promise you'll become better at data analysis and data visualization by practicing every week.
Data sets - https://www.makeovermonday.co.uk/data/
===============
LEARN FROM ME
Join my newsletter. Sign up at andykriebel.com.
ARE YOU INTERVIEWING FOR A NEW JOB?
Contact me for more information about how I can help you prepare for that big interview.
===============
CONNECT WITH ME
More Watch Me Viz - https://bit.ly/WatchMeViz2023
February 20, 2023
#MakeoverMonday 2023 Week 8 - The Cost Effectiveness of Protein Sources
This week we explored the cost of 20g of protein in various foods. During Watch Me Viz, I showed how to create toggles to allow the user to filter by vegan and vegetarian foods. I did this with parameter actions; if you want to learn more, watch the video below.
In the end, though, my fancy filtering with parameter actions didn't quite work out. I hadn't account for the option when the user might want to look at all foods. So I ended up using basic filtering. I overcooked the whole process, but I bet you'll learn something anyway.
I then went through the entire dashboard design process using containers, padding, shading and more. Check that out if you're interested in learning how to use layout contains.
Here's the #WatchMeViz recording, followed by the interactive viz. Enjoy and thanks for watching!
January 3, 2023
#MakeoverMonday 2023 Week 1 - The Change in Greenhouse Gases in the Atmosphere
2023 is here and #MakeoverMonday will be here the entire you to help you continue to learn and improve. Come on the journey with us each week. Build your portfolio. Showcase your skills. You just might get that job you've been seeking. It's happened, a lot, by participating every week.
For week 1, we were analyzing greenhouse gases in the atmosphere from 1979-2021. The original visualization is quite simple.
We have CO2 and total gases on the left axis and the variance to 1990 on the right. Overall, the chart is pretty easy to read, with the exception of knowing that the red line is always compared to the 1990 value. That definitely needs to be more clear. It's also missing a title, so without the website it is posted on, you wouldn't necessarily know what it's about.
For my viz, I started by reproducing the original, but it doesn't look as good because the data we have starts at 1979. So you miss the big upward curve. From there, I focused primarily on making good looking sparklines that show comparisons with a parameter action. I also showed how to create an "area chart" with multiple colors. I'm going to create a tip video for it; I like how it turned out.
Here's the livestream and below is the visualization for you to interact with. The viz does not render properly on Tableau Public, but hopefully you get the idea.
I hope you continue to join me throughout the year so that we can learn together.
Have a wonderful 2023!
November 22, 2022
#MakeoverMonday Week 47 - Worldwide Railroad Infrastructure Quality Rankings
- Recreating the original bar chart
- How to create a bump chart
- How to use a diverging color palette and alias country names
- How to create a ranked dot plot
- How to use parameter actions to sort the view
- How to use a filter action to remove the highlighting
November 14, 2022
#MakeoverMonday Week 46 - The Cost of Cocaine & Heroin
Quite the interesting topic this week. I get an email from The Economist regularly and there was an article about the wholesale price of cocaine. That led me down a rabbit whole and I found the data, but also for heroin and also for retail prices.
On Watch Me Viz, I stuck with simple lines charts that compared the price for a country to the overall price for all of the countries in the data set. I allow the user to choose a drug and a country.
I then wanted to show how to Dynamic Zone Visibility feature works (if you haven't seen it, be sure to watch it back). In the end, a simple dashboard that compares the measures in two ways, allows for some filtering, looks good, and that's it.
Check out the dashboard below the video.
November 8, 2022
#MakeoverMonday Week 45 - Who Americans Spend Their Time With
October 24, 2022
#MakeoverMonday Week 43 - How have Major League Baseball Pitch Types Changed?
This week's data set was pretty simple. We had 21 baseball seasons and a column for each pitch type. Pivoting the metrics made it much easier to work with for me as I could then split the view by pitch type.
During #WatchMeViz (below), I create a trellis view, showed how to create groups, sets, set actions, sparklines, LODs, custom number formatting, creating a mobile view, and more.
Thank you for tuning in. Here's the video and below is my visualization.
October 17, 2022
#MakeoverMonday 2022 Week 42 - Food & Drug Administration Inspections in America
Having looked at the original visualization this week (here), it was pretty clear to me that the creators desired to create a KPI style dashboard. In a way it's good that I picked up on it that way. However, it wasn't designed particularly uclarly well to communicate most efficiently.
I decided during Watch Me Viz that I would stick with their idea of a KPI dashboard, but design it in a way that I thought would be easier to understand.
As per normal, it took way too long to faff about with the formatting. I made a couple of small changes after I finished the live stream. Click on the image below the video to check it out. Leave a comment on the video on YouTube if you have any questions. (Comments aren't appearing on the blog for some reason).
Have a wonderful week!
October 11, 2022
#MakeoverMonday 2022 Week 41 - UNDP Human Development Index
From UNDP:
The Human Development Index (HDI) is a summary measure of average achievement in key dimensions of human development: a long and healthy life, being knowledgeable and have a decent standard of living. The HDI is the geometric mean of normalized indices for each of the three dimensions.
This week, I really liked the original visualization, so during #WatchMeViz, I spend the time recreating the visual. I got most of the way there in an hour and finished it off in the evening. The questions on the live stream are super helpful...thank you!
A couple things I learned:
- Hover action interactivity is very, very slow in Tableau. I ended up changing it to a select action.
- Labeling is overly complicated.
- Tables in a tooltip can look really good. And they are very responsive.
October 3, 2022
#MakeoverMonday 2022 Week 40 - Income Inequality Around the World
September 12, 2022
August 29, 2022
#MakeoverMonday 2022 Week 35 - The World's Biggest Military Spenders
Makeover Monday is back! Every Monday I'll be running a #WatchMeViz and every Wednesday, Eva will be running #VizReview. Subscribe to my YouTube channel for reminders of the latest events.
https://youtube.com/andykriebel
This week was a makeover of a visualization by Visual Capitalist about the top 10 military spenders. During Watch Me Viz, I iterated through 15 different charts before settling on a bump chart. If you want to learn about sets, parameters, table calculations, containers and more, watch the video below.
Below the video you can see my viz, or click here. Enjoy! If you need clarifications on anything, please comment on the video here.
August 26, 2022
Workout Wednesday - New York City Tableau User Group Recap
Talk about pressure! I was given a 30 minute slot to see how many Workout Wednesday's I could complete. I was pretty confident I could finish 4, given I had already pre-selected the challenges I thought were easiest.
But...those pesky tooltips!
And the heckler in the audience (ahem Ann Jackson).
So how'd I do? I got the WOW2020 Week 32 100% complete, week 28 about 95% complete (the tooltips), and week 21 about 95% complete. It love trying to solve problems and build vizzes live.
If you missed it, here's the recording from the TUG. My part starts at 38:55. Farther down, you'll find each of the workouts in their completed state.
June 20, 2022
#WatchMeViz - Workout Wednesday 2022 Week 1
May 25, 2022
#WOW2022 Week 20 - Monthly Sales vs. Target
Resources
- Week 20 Challenge
- My Solution (image below)
April 21, 2022
#B2VB - 2022/W4 - Design Some KPIs
Resources:
KPI Samples from Tableau Public:
March 31, 2022
#B2VB 2022/W3 - Olympic Medal Tracker
If you're not participating in the Back to Viz Basics community project yet, you should be. It's all about creating effective, simple charts, which is exactly what you need to be able to do before you build anything fancy. This will definitely help you master data visualization best practices.
For week 3, the objective was to build a text table of Olympic medal counts. Sounds simple, but unfortunately, building good looking tables isn't one of Tableau's strengths.
I also started the #WatchMeViz livestreams again. You can find all of them on this playlist. Thank you to those that attended live and asked good questions and left thoughtful comments. Below is the livestream as well as my final viz.
Until next week...
