Overview So, you’ve created a wonderful collection of survey data dashboards that have innumerable demographic filters so that users can, for example, just see responses from left-handed Los Angeles Lakers fans between the ages of 34 and 39. So, what’s the problem? Actually, there are two problems. The first occurs when extreme filtering reduces the [...]
Updated on September 11, 2018. Note: Special thanks to Joe Mako who suggested this approach. Overview I’m fortunate that when I work with survey data that is not well-coded I can take out my trusty copy of Tableau Prep, EasyMoprh, or Alteryx Designer and get my data “just so.” But what if you don’t have [...]
Overview I’m a big fan of Andy Kriebel’s and Andy Cotgreave’s Makeover Monday challenge. For those of you not familiar with this, each week Kriebel and Cotgreave find an existing visualization / data set and ask the data visualization community to come up with alternative ways to present the same data. As Cotgreave points out [...]
Overview As I’m mentioned before the number one impediment to success with visualizing survey data in Tableau is getting the data in the right format so you can do all the dazzling things you want to do. Up until very recently none of the survey tools vendors had done anything to make things easy so [...]
Overview I spend a lot of time with survey data and much of this data revolves around gauging people’s sentiments and tendencies using either a Likert Scale or a Net Promoter Score (NPS) type of thing. Examples Here’s an example of gauging sentiment using a 5-point Likert scale. Indicate how satisfied you are with the [...]
Overview I received an e-mail inquiry about weighted data recently and realized that while I cover this in my survey data class I had not yet posted anything about it here. Time to remedy that. The good news is that it is not at all difficult to work with weighted survey data in Tableau. And [...]
Overview You can download a trial version of Alteryx here. You can find the Excel source data here. You can download the completed Alteryx module from here. Understanding the workflow Here’s the Alteryx workflow that will get the data in the format we want. Figure 9 -- Alteryx workflow for getting the survey data [...]
Overview In writing about visualizing survey data using Tableau I’ve found that the number one impediment to success is getting the data in the right format. In accompanying posts I'll explain how to get this done using Tableau Prep, Alteryx, Easymorph, and Tableau 10.x. What do I mean by “just so”? When I deal with survey data [...]
Showing Differences between Periods and Statistical Significance in Tableau Overview Addressing this scenario has been the most popular request I’ve received over the past year. Here’s a summary what my clients and students have asked: How do I show the change in Sales, Percentage of Promoters, Number of Visits, etc., between this month / quarter [...]
Much thanks to Susan Ferrari for exposing me to the concept of Net Promoter Score, Susan Baier for encouraging me to blog about it, and Helen Lindsey for providing anonymized NPS data. Overview My wife and I recently went out to a restaurant to celebrate our anniversary. Accompanying the check was a survey card with [...]
