Book Review: How Charts Lie by Alberto Cairo

I recently had the pleasure of reading Alberto Cairo’s latest book How Charts Lie.  No matter if you are a data visualization expert or only familiar with charts you see on TV and in the media, this book will help you make smarter decisions in reading and interpreting the charts you encounter in your daily life.  I highly recommend reading it.

How Charts Lie provides a captivating mixture of topics touching on philosophy, sociology, and graphical literacy (also known as graphicacy).  Cairo does a masterful job of providing guidelines and guideposts on how to read and analyze not only charts you see but any data that you are presented.  Where this book set itself apart from others in the data visualization genre is the examination of how these charts and data interact with the reader’s mind.  By providing many real-world examples of chart trickery (accidental and otherwise) readers will become more discernible consumers of information.  Additionally, as important as being a responsible information consumer, Cairo delves into the responsibility incumbent upon chart creators and even those that simply pass along charts to others.

One poignant message that Cairo delivers throughout the book is that a chart only shows what it shows.  Beware of inferring causation from a chart because of personal beliefs or the chart creator’s bias.  Make sure to take the time needed to analyze what is being displayed.  If a visualization appears too good to be true, it’s at least worth researching further before solidifying an opinion.

This book has provided me greater cause for thinking about charts that I see and to have conversations around data and news with an open mind.  To be open to persuasion while being mindful of trickery and my own implicit bias.  The book goes on sale on October 15th.  Make sure to add it to your reading list and pre-order it from Amazon here:


The Draft Board Dashboard: Visualize Your Fantasy Football Draft

It’s August and Football is Back!

Like the real world, the world of sports has seasons.  College basketball season ran through March with Virginia winning its first NCAA tournament. The NBA wrapped up in early June with the Raptors winning their first NBA championship.  We’re now currently in the middle of baseball season (Let’s Go Yankees!). 

For many Americans and some international fans, the month of August means the NFL is coming back.  Preseason games have already begun and the regular season is set to kick off on Thursday September 5th.  

I’ve been a huge New York Giants fan my whole life.  More than being a Giants fan though, what makes the NFL even more interesting for me is playing fantasy football.  Since 2007, I’ve been in at least one fantasy football league each year.

If you’re unfamiliar with fantasy football, the traditional type of league is a season long competition where each individual drafts a team made up of real NFL players.  Each fantasy team is awarded points based on the performance of the NFL players. Fantasy teams with more points than their competitors each week are awarded a win. At the end of the season, playoff seeding is determined by number of wins during the season.  A championship match determines the league winner.


Before the season begins though, all of the news, strategy, and speculation that has been studied by each fantasy football player throughout the offseason culminates in the fantasy football draft.  This is the event that kicks off the fantasy season for every league and where each team picks their players to start the year. A typical fantasy football draft is conducted snake style where each team picks one player in the first round and then the order is reversed so that the last player in round one gets the first pick in round two.  The draft continues in this back and forth manner until each team’s roster is full.

This year, I have the good fortune of joining two of my favorite activities together by playing in a 16 team fantasy football league with several other Tableau enthusiasts.  Shout out to my fellow #DataFamtasy leaguemates! 

  • Jesse McConnell @mcconnellj
  • Brian Moore @BMooreWasTaken
  • Jacqui Moore @jaxx084
  • Sean Miller @HipsterVizNinja
  • Alex @databiscuits
  • Tim Cady @tiivn
  • Katy Sandlin @the_worldforgot
  • Vince Baumel @quantum_relic
  • @dataNOTdoctrine
  • Bo McCready @boknowsdata
  • Mark Bradbourne @MarkBradbourne
  • Vinodh kumar V R @VinodhDataArt

Throughout the season, we’re going to be vizzing our fantasy football data.  As soon as I signed up for this fantasy league, I knew that I wanted to viz the draft.  The standard snake style draft board lends itself so well to being visualized in Tableau.  While my league hasn’t drafted yet, I’ve created the following Draft Board Dashboard as a template for anyone to use to visualize your own fantasy football draft!

Draft Board Dashboard Template

Utilizing the top rated fantasy football players from the Fantasy Pros website (link), I created a dataset in excel to build my draft board.  Here is a look at the fields in the dataset:

Draft Template Data Headers.png

At the very least this viz requires the following fields:

  • Round Number: Draft round number.  Dictated by the number of roster positions that each team has available.
  • Round Pick: Determined by the number of teams.  If you have 12 teams, there will be picks from 1 through 12 in each round
  • Fantasy Team Number: The numerical position that the team will be drafting in the odd numbered rounds.  Used to order the teams on the board
  • Player Name: Name of the NFL player.

To capture more detail in the viz, I’ve also included the following fields in the template:

  • Fantasy Team Name – Name of the teams in the fantasy league.  This is pulling from the “Team Names” tab in the excel datasource so you only have to enter the team names once
  • Player Position: Position of the player for their team e.g. QB, RB, WR
  • Player Team: Current team of the NFL player
  • Overall Pick: Overall pick number that a player was selected in the draft

Note that I created this template for a 16 team league.  If you have less teams in your league you can delete the extra teams from the dataset.  For example, if you only have 10 teams, filter the Fantasy Team Number column in the spreadsheet for teams 11 through 16 and delete those rows.   As your draft will have its own set of picks and teams, be sure to update the player data as well as the pick numbers.

Here is a copy of the dataset: Fantasy Football Draft Template

To create the Draft Board Dashboard in Tableau, I put the Fantasy Team Number and Fantasy Team Name on the columns shelf.  I hid the header on the Team Number but left it in the viz because it keeps the team names in order. On the rows shelf I put the Round Number.  By changing the viz to use Square mark types and adjusting the size of the squares, the main grid for the draft board was ready.

Draft Board Grid.png

Player Name and Position were then added to each square.  A custom tooltip is also included that details the Players Team and which number they were picked, both in the round and overall in the draft.  Here is the final version:

Draft Board.png
Draft Board Dashboard

Tableau Public Link

The Player Position field is used on the color shelf.  After a real fantasy football draft, the colors can be used to see how various Player Positions were drafted throughout.  The Draft Board can be analyzed to answer questions like “was a kicker drafted too early?”, “which fantasy team started the run on quarterbacks in Round 7”, and “which position was drafted the most overall?”.

Draft Board Dashboard In Action

The most fun I had in creating this viz was animating the whole fantasy draft to see what it looks like as each pick is put on the board.  I placed the Overall Pick field on the Pages shelf in Tableau to create the Fantasy Football Draft animation. Unfortunately, Tableau Public doesn’t support animation for published vizzes.  However if you download the viz into Tableau Desktop, you too can create your own fantasy draft gif just like this!  

Draft In Action2.gif

The #DataFamtasy league draft will happen within the next month.  Once it does, I’ll create an updated viz and gif of our actual draft.  Good luck to all my fellow fantasy football players out there on your upcoming season!  If you create your own Draft Board Dashboard, be sure to tag me so I can check it out.

TC19 Resolutions: How To Stay Accountable To Your Data Viz Goals

For many, the end of the year is a time for reflection.  Even though the actual day of January 1st isn’t much different from December 31st or February 8th or June 16th, it marks the beginning of the new year, and with that comes a host of expectations, promises, and resolutions.  

At the end of the year, we take stock of the previous 12 months.  We relive our accomplishments, think about what we left unaccomplished.  We ponder what we’ve lost or what might have been.  And for so many, in the US and around the world, we create a list of resolutions for the coming year. These resolutions are milestones that we set for ourselves, usually with the goal of improving our lives or the lives of others.

Resolutions often focus on improving physical health, quitting bad habits, becoming more charitable, or learning new skills.  And while most resolutions are created right before the new year, there are other annual events that may also bring resolutions to mind.

For the data viz community, and specifically the Tableau community, the Tableau Conference holds much of the same wonder and excitement as New Year’s Eve.  It comes once a year. It’s celebrated by thousands of others in our community (our data community in this case). It brings a whole host of expectations, new experiences, learning opportunities, and lots and lots of personal reflection.  

#TC19 Resolutions

After this year’s conference in New Orleans, I saw this tweet from Vince Baumel inspiring the community to share some resolutions for the year before 2019’s Tableau Conference.

Vince Baumel tweet

The end of TC18, along with Vince’s tweet, got me thinking about my personal Tableau and data viz growth over 2018.  All in all, 2018 was a great Tableau year for me. I attended my second Tableau Conference. I passed the Certified Professional exam.  At the time of the conference, I’d posted 38 vizzes on Tableau Public for the year.

Now was the chance to create my #TC19 resolutions, or more specifically, the resolutions that would continue to grow my personal Tableau and data viz skillset and grow my online persona, while also making sure that I was giving back to the wonderful community.  With those goals in mind, here was my original #TC19Resolutions tweet:

To make sure they were all clear and quantifiable, I revised them into the following list:

  1. Write 5 blog posts
  2. Attend at least 6 TUG meetings
  3. Create 3 original vizzes where I source or create the data
  4. Reach Level 15 on the Tableau Forums

Blog Posts

I had wanted to write a blog for over a year.  I’d even registered this domain right after TC17 ( but never actually wrote a personal (non-work related) blog post.  I had a few ideas of what I wanted to write. However I had been prioritizing creating new vizzes and participating in data viz challenges over sharing my written knowledge with the community.

There are so many wonderful blogs out there that it was easy to feel like I may not have much to contribute.  However, every time I’ve shared my knowledge and experience with the Tableau community (whether talking to people in person, sharing my knowledge at work, presenting at the Tableau Fringe Festival), the feedback has always been positive.  After TC18 I was determined to start writing, and more importantly publishing and sharing, original written content with the community.  5 blog posts sounded like a good start.  Though I’m hopeful that the initial 5 will lead to many more.

TUG Meetings

Tableau User Group (TUGs) exist all over the world and hold meetups on a semi-regular basis (both in-person and virtual).  TUGs offer the incredible experience of meeting and networking with other Tableau and data viz minded individuals, as a space for learning and sharing knowledge with others, and a great place to learn about the latest Tableau news or upcoming announcements.  

While I hate to admit this, before this year’s Tableau Conference, I’d only ever attended one Tableau User Group (TUG) meetup.  I knew that I was missing out on a great opportunity to interact with the community by not attending more. Therefore I am making it a point to attend at least 6 meetings before the next Tableau Conference.

Original Vizzes

If you’ve followed me on Twitter or seen my Tableau Public profile, you’ll know that I love to participate in data viz challenges.  If you’d like to learn more about these challenges, I encourage you to read my previous blog post: Are You Up To The Challenge?

I credit much of my personal data visualization growth, especially over the last year and a half, to the number and breadth of challenges that I’ve participated in.  Each one has provided me with an experience for improvement that I would not have had otherwise.

As most of the challenges focus on viz creation, they tend to provide a nice clean dataset at the start.  However, for anyone that works with data visualization in a professional environment, you’ll know that you are almost never handed clean and organized data.  More often than not the data is in disparate sources and formats. You may not even know where all of it is at first. This data generally requires cleaning and manipulation before you can even start to create a viz.

So, as a way of continuing to step outside my data viz comfort zone, and wholly inspired by the wonderful original work put out by the community, I resolve to create at least three original data visualizations in which I’ve either sourced the data myself or created it directly.

Tableau Forums

The forums are the most underrated and under-appreciated feature of the Tableau community.  Almost every time you search for a Tableau answer online, you are directed to a link on the forums.  If you use Tableau regularly, you will inevitably find yourself at some point researching an answer on the forums.  

Not only can you research a question there, but you can post an original question as well.  There are a host of other Tableau users in the community who regularly monitor the forums and are committed to helping others answer their questions.

Prior to TC18, I had really taken the forums for granted.  I’d searched for answers on it many times, but never posted myself, nor had I taken the time to help others answer their questions.  I’ve often been the Tableau and data viz resource for others at work, and am always happy to help with whatever questions my co-workers have.  I only made a minimal effort to expand my help beyond my office though.

I wanted to change that going forward.  To set a quantifiable goal for participating in the Tableau forums, I decided to use the point system that the forums have in place.  They have a point system (a somewhat addicting point system) that allows you to level up as you help others on the site. The highest level you can currently achieve is Level 15 – Data Monarch, which requires 7,900 points.  

My original goal was to reach Level 7 – Data Rockstar, but after I started participating in the forums and helping answer others questions, I quickly realized how much I enjoyed it.  It is very gratifying to help others in the community.  Not only that, but I have been learning a lot from my time on the forums as well.  I’m more engaged with answers posted by others.  I’ve also had the opportunity to answer questions that have really had me stretch my Tableau knowledge and have caused me to learn more in the process.

Level 7 requires 1,100 points but I quickly blew past that.  My current goal is to reach Level 15. Along the way, I’ll be helping many others with their Tableau questions and will continue learning myself as well.

PUBLIC SERVICE ANNOUNCEMENT: If you have not done so yet, start participating in the forums, even just a little bit.  It will greatly improve your skills, while you give back to the community, and it’s free.  You can’t beat all of that.


What really struck me about Vince’s #TC19Resolutions tweet was the accountability piece.  So many times we create and maybe even share resolutions, only for them to be forgotten by the end of the coming year.  How could I improve my ability to keep myself accountable? The best answer I could think of, especially for data viz related resolutions, was to create a viz about it.

Here’s my #TC19 Resolutions tracker:!/vizhome/TC19ResolutionTracking/TC19ResolutionTracker

#TC19 Resolution Tracker

Between writing this blog post and creating this resolution tracker, I plan to keep myself publicly accountable to my resolutions.

For any of you that posted your own TC19 Resolutions, or would like to do so now, I encourage you to share them with the community as a means of keeping yourself accountable.  Go ahead and tag me too. I’d love to see your resolutions for the coming year, and am more than happy to be your accountability partner for fulfilling your own resolutions!

Happy Holidays and Happy New Year to all of you!  Wishing you all the best in 2019. Never stop learning, never stop reaching, never stop giving back.  I hope that you accomplish everything you set out to do this coming year.

Are You Up To The Challenge? My Creative Process for Data Viz Challenges

Have you heard of #MakeoverMonday or #WorkoutWednesday?  I’m sure many of you have, but if not, they are two of the many free and publicly available challenges offered by the Data Visualization community.

Some challenges are offered weekly while others are monthly.  Some focus on creation of new visualizations while others focus on challenging you to recreate existing ones – with the goal of teaching new visualization techniques.

For me, there are three main reasons why I have become a regular participant in these challenges over the last year and a half:

1. Practice

As with any art form, to get better at data visualization you need to practice. The more that you create, the more scenarios that you encounter, the more functionality that you’ll be able to understand and use, and the better your skills will become.  You can never stop learning or get enough practice with data visualization.  Even Tableau Zen Masters are constantly learning and working to expand their knowledge.

2. Accountability

While it’s easy for me to set goals for myself, if I don’t have a means of staying accountable to those goals, I have a much harder time of staying on track. Creating these challenge visualizations, publishing them to Tableau Public, and then posting them on social media has been a great way for me to stay accountable to my progress.

3. Building a Portfolio

Along with accountability, as I continue to publish my work on Tableau Public, I’ve amassed a nice portfolio of non-job related data visualizations. This has been especially useful when I’ve applied for new positions in the past.  You usually cannot show potential employers visualizations you have done at work, but if you have worked on things on your own time, and have them published on Tableau Public, you have a portfolio of your work in reverse chronological order.

My Creative Process

I just recently participated in #ProjectHealthViz, a monthly challenge by Lindsay Betzendahl focused on publicly available health data.  Health data is fun to visualize as there are many different stories to be found within the data and many different ways of presenting them.

This month’s dataset was from the CDC and focused on disease outbreaks across the US.  The data was in an excel file with over 400 thousand rows.  Each row contained information on a single outbreak.

Let’s walk through how I got from the raw data to my final viz.


Norovirus Outbreaks!/vizhome/ProjectHealthVizNovemberNorovirus/NorovirusOutbreaks

Process, Not Rules

While each challenge is different, when I’m creating something new there is a general process I follow.  By no means are any of the following points meant to be seen as rules (very few of those exist in data visualization).  Rather my intent in sharing these guidelines is to provide a spark to those who are just getting started with these data viz challenges and provide a possible structure for doing so.

Reviewing Data Structure

The first thing I do when presented with a new dataset is to look at which data fields are available.  In this data from the CDC, there were:

  • date fields for when an outbreak occurred
  • state location information
  • an Etiology field that listed the name of the disease
  • some descriptor fields (like mode of transmission and outbreak setting)
  • several measures including the number of illnesses, hospitalizations, and deaths.

When reviewing the structure of the data, you want to get a general understanding of what your main dimensions and measures will be for your visualization.

Exploration and Choosing a Topic

This CDC dataset is a little on the heavier side as far as content goes but it’s rich with stories to be told.  To decide which story I wanted to tell, I needed to explore the data.  While I could have done this in Excel, I like to bring the data into Tableau to start exploring.  I start by reviewing overall statistics with the goal of finding a topic that stands out in the data.

For this dataset, that included the following:

Number of Outbreaks Per Year

Outbreaks per Year


Total Outbreaks by Location

Outbreaks by Location


Outbreaks by Location 2


Number of Outbreaks by Disease Type

Outbreaks by Type

It was clear from my exploration that Norovirus had the most outbreaks of all the diseases in the dataset.  I decided at this point to use Norovirus as the focus for my viz.  While I don’t always create visualizations based on the highest or lowest numbers in a dataset, once I have found a good topic I like to start creating my viz in Tableau.

Although you can and should take as long as you’d like when creating your own visualizations, I try to keep some structure around the amount of time I spend on any single viz.  Some take longer than others, but I have a family and friends that I like to spend time with so I make sure my viz time does not take away too much from my personal time.

Telling a Story

Sometimes you have a dataset and you know exactly the story you want to tell right away.  In those cases, you may start by creating the overall design of your dashboard and filling it in with your data later.

I tend to start with the data before I create a dashboard.  I create several different charts, and iterations on those charts, before I put them all together.  For the #ProjectHealthViz challenge, I created several different views.  However, not all of them made the final version of my dashboard.

It’s up to you how many charts you want to create before combining them into a dashboard, but don’t feel like everything you create needs to be included.  Sometimes your best ideas don’t come till after several iterations or a few times stepping away from your computer and coming back to it.  More importantly, even if you really like one of the several charts that you have created, if it doesn’t fit with your overall story, you do not need to include it in your final viz.

Putting It All Together

Once I have a few different views to choose from, I start putting them together.  My dashboards usually are not the same shape or size, and I often resize my dashboards as I’m working on them.

The one actual rule I stick to though is using fixed dashboards.  You never know what size screen your viewers will have and if you do not fix the size of your dashboard, it may stretch or shrink in ways that make it unreadable.

Alignment and Chart Selection

There are many different ways to layout your dashboard.  I often like to make a rough sketch with a pencil and paper of what I want my dashboard to look like.  This helps me visualize what I want to do before I start creating in Tableau.

For my ProjectHealthViz I decided that I wanted to make it look like a long and narrow infographic – something where the story builds as you go from top to bottom.  While I had several charts to choose from, I decided on these three to present the data:

  • Bar Chart
  • Hex Map
  • BANs (Big Ass Numbers)

I’ve used bar charts and BANs many times in the past.  They’re both great ways to highlight simple information.  The bar chart I created clearly shows that Norovirus is the top cause of outbreaks in the US.  The BANs at the bottom deliver raw numbers for how many have been affected by Norovirus.

As for the hex map, while I could have used a traditional map instead, there are two reasons I chose the hexagon style.

  1. It makes it easier to see the number of outbreaks per state when each state is the same size.
  2. I’ve always wanted to create a hexagon map and hadn’t done so before.

While some charts are more effective than others for different scenarios, sometimes stretching your ability by trying something new is fun too.  And data viz should be fun!

Font and Color

I’m no expert on fonts.  However, Tableau Public has a limited number of fonts it can render.  Since the options are limited, it’s not too difficult to choose a font.

Jennifer VonHagel put together this great resource on which fonts are supported by Tableau Public and how they look:

I personally like the look of the Georgia font but sometimes stick with Tableau Regular (and use Tableau Bold or Tableau Semibold for bold characters).  For my ProjectHealthViz, I stuck with Tableau Regular and Tableau Semibold.  The bold function does not work well with Tableau Regular so I used Tableau Semibold for making certain text and numbers stand out.

When it comes to color selection, I try not to be too flashy.  You don’t want extra color taking away from what you are presenting with your data.  You also don’t want to use color that doesn’t have meaning.  Color can be a great asset in your viz, but it is also very easy to overuse.  My recommendation is that less color (and a fewer number of overall colors) tends to work better for visualizing data. In my viz, I used red to highlight the outbreaks while keeping everything else black or white.

Custom Fonts in Tableau

For my title at the top, to give it a little something more than the standard font look, I turned to PowerPoint.  You can create a title in PowerPoint using any font available, save it as an image, and import it into your viz as an image.  This way it looks like you’re using custom fonts, even though they’re actually image files.

At the end of last year, Zen Master Ken Flerlage tweeted about a tool called that lets you type in a word or phrase and see how it looks in all of the fonts installed on your machine.

I’ve used on several of my visualizations. It’s an easy way to find a font for a custom title, especially if you do not want to go through each font in PowerPoint one at a time.


The footer is where I place information to tag my viz as my own.  I put the name of the challenge I’m participating in and my Twitter handle.

This is also where two very important pieces of information should go:

  1. Link To Your Datasource:  If the data is publicly available, make sure to cite where it came from.
  2. Attribution: If you were inspired by someone else, or took a similar approach to a visualization as someone else, make sure to note that in the footer. Attribution in data visualization is as important as attribution in a book or research paper.

Be Deliberate About Difference

Once your viz is done, make sure to review it.  Check for consistency in both your font usage and your colors.  If you decide to make something a different font or color or shape than other items in your viz, do it intentionally and know that you did it. Do not do it because you overlooked it.  Be deliberate about difference in your viz.

Check your tooltips too!  They’re often overlooked and can be a useful feature for including additional information.

Pro tip: It never hurts to have someone else review your viz.  The Data Viz community can be a great resource for this, but sometimes it helps to have someone from outside the field review it as well.  If they have trouble interpreting your viz or understanding your data, you may need to make it clearer.

Get Started!

Sometimes getting started can be the hardest part.  Regardless of the process you use, the most important part of getting started with these challenges is to create something.  Import your data into Tableau and start making charts.

I’d say the second most important part is sharing your finished viz online.  For me, sharing my work online has been the best way to stay accountable to my progress and to elicit feedback from the community.

Here’s a list of challenges that I have had the pleasure of participating in (in no particular order):

 I challenge you all to participate in more challenges.  And if you ever would like any feedback on your visualizations, I’m more than happy to help!

Searching for My Inner Artist

Inspiration at Tableau Conference 2018

TC18 left me inspired, empowered, wanting to do everything, and also a bit tired.  Like many others I wanted to rush to complete a blog as soon as I left New Orleans.  However, as often happens, we start out with great intentions but life intervenes.  I started writing in fits and spurts, finding it difficult to get an opportunity to sit down and get my thoughts out.  At the very least though, I knew what my blog topic would be.

On the last day of the conference, I had the great fortune of attending Giorgia Lupi’s talk on Data Humanism.  A month or so before the conference I had seen a wave of people in the Tableau Community tweet about her Observe, Collect, Draw book and start creating wonderful artistic imagery, outside the realm of our normal day to day data viz.  They weren’t just creating charts or reports – they were exploring their own creative ability.

My Data Viz Background

I have to admit that the artistic aspect of data visualization does not come naturally to me, and it’s the piece that I want to improve upon the most.  I’ve never been artistic.  My ability to draw by hand didn’t progress much beyond elementary school.  I can be creative poetically and occasionally musically but visual creativity has always been hard for me.

I did not come to Tableau for its artistic capabilities.  I began my career in business analysis type positions where I used a ton of Excel and looked at a lot of numbers.  Most of my professional Tableau use has been more on the data analysis side.

Ask a question > find an answer > use the visualization as a means of finding the answer.

In the data viz community, especially in professional environments, visualizations that don’t provide quick and obvious impact are sometimes scoffed at and considered “data viz as art”.

Seriously, You Should Watch This

While I had begun to appreciate the artistic side of data visualization from connecting to the Tableau community on Twitter, Giorgia’s talk at TC18 was the type of experience that would change the mind of any data viz purist.

If you want an example of the experience, read about her work with Kaki King called “Bruises: The Data We Don’t See” in this Medium article (link) then watch the video they created here:

I’ve never been that moved by data visualization before.  Bar and line charts can’t convey that type of emotion (don’t @ me).  The feeling that her worked evoked in me was encapsulated in her definition of data humanism – “using data to become more human instead of more efficient.“   That sentiment had not crossed my mind before that point.

Additionally, her Dear Data Project with Stefanie Posavec showed me that inspiration for artistic data viz can come from anywhere and does not need to follow standard conventions. My top takeaway quote from her session was, “it’s much more interesting to see how we can expand definitions of data viz instead of constricting them”.

Find Inspiration Everywhere

As I was procrastinating from writing this blog by perusing Twitter, I found that Tableau Zen Master Neil Richards had already included a great tribute to Giorgia’s talk at TC in his post TC recap.  While I highly recommend reading it (link), it also took me to the recording of his TC talk “Design Driven Data”.  Unfortunately, I had been unable to see it live, but I’m so glad I watched it later.

In it, Neil discusses his own non-artistic background and how he’s been able to use Tableau to explore his creative ability.  Instead of the typical approach of data driving the design of a visualization, he implores his audience to find data that fits an original design that you create.  Doing so may lead to better results, and possibly have more impact than a traditional data driven approach.  His response to those that say that “data art isn’t proper visualization”?  “Good data art still visualizes the data.”

After watching both Giorgia and Neil espouse the beauty of design and captivation in data visualization, and in admiration of Neil’s ability to find inspiration anywhere, I was ready to create my own piece of design driven data art.


While I was searching for inspiration, I noticed a dreamcatcher at the Airbnb in Austin I was staying in the week after TC.  I appreciated it’s design and colors, and most importantly I believed that I could create something like it in PowerPoint.  I used Kevin Flerlage’s method of creating polygon-like vizzes without polygons (link) to get to work.

Before I had any data, I created a Dreamcatcher design with some random colors in PowerPoint.  Each piece of the dreamcatcher is an individual shape.  I saved individual png images of each of the 32 shapes so that I could use them later in Tableau.

Dreamcatcher Shape

Embracing the design driven data approach, I now had my design but did not yet have data to go with it.  I focused on the 32 shape image files I now had.  The only two things I could think of that have the number 32 are the number of teams in the National Football League and the number of teams in the World Cup.  As I’m a big fan of the NFL and know much more about American Football than Everywhere Else Football, I decided to use NFL data.

For the color, I utilized this fantastic list of 100 different color palettes from Canva (link).  It was both a blessing and a curse as I tried out many, many, different color combinations before deciding on one I liked.

Now that I had the design part down, my traditional data viz and analysis background kicked in.  I needed to find some data that worked with my design.

Data Behind The Design

While Kevin’s blog shows a method for using size to differentiate each shape, since I have 32 shapes (each representing one of the 32 NFL teams) and they are in very specific positions, making each a different size would cause them to overlap each other.  Instead, I decided to find some binary, yes/no type data, where a shape would appear if its value in my dataset was “yes” and would disappear if its value was “no”.

There are many sites that have NFL statistics.  On, I saw they had data on each team’s Passing Play Ratio – the percentage of a team’s plays that are passes versus those that are runs.  I decided to use this for my binary data.  More than or equal to 50% passing equals “yes”, below 50% passing equals “no”.

To decide how to position each team’s shape, I started at the very top.  The shape at position 12 o’clock is the top ranked team for that year.  The teams then decrease in rank clockwise around the circle.

Dreamcatcher - original

Over a period of 16 years (starting at the top left and working to the bottom right, if a team passed 50% or more of the time, their shape appeared on that season’s dreamcatcher.  If they passed less than 50%, their shape is hidden.  The viz shows that passing is becoming more common (less shapes disappearing over time).  In fact, over the last 4 seasons, only the 2018 Seattle Seahawks have run more than they’ve passed – and the season’s not yet over.  I’ve included viz in tooltips to show more traditional data on each team’s Passing Play Ratio.

Honestly, the hardest part of creating this viz, more so than creating the shapes in PowerPoint, or gathering my data, was creating the legend to go along with it.  An often overlooked and under-appreciated aspect of artistic data representation is the legend that explains what you’re seeing.  This is the piece that differentiates data-based art from non-data art.  Since my viz is built off of NFL data, I need to inform the viewers of what they are seeing and how to read it.  I’ve also leveraged viz in tooltips in my legend.  My intention in doing so was to save space and maintain the height of the original Dreamcatcher viz.

Dreamcatcher with legend

And here is my final piece (Tableau Public link).  This is not something I would have considered creating before TC.  Having done it though, I’m eager to see what other types of artistic data viz I can create.  Not everything I create is or ever will be the most artistic or most visually appealing, but at this point I feel like my artistic exploration is more important than the outcome.