This post was inspired by a question on the Tableau forums. Basically the goal was to display a combination of measures in a single table. Some measures were percentages and others whole numbers. Added to this was a desire to highlight change (up or down) for percentages but not for the whole number values. The highlight table seemed to be the best solution, but by default it applies the highlight to all values. So, it took some tweaking to get to trick Tableau into not highlighting the changes in whole numbers.
Continue reading Highlighting change for a subset of measures
After a year of playing around and developing things in Tableau, we have finally been approved to release the new tools we’ve developed at work. Of course, by “we” I really mean “me”. To be fair, other people in the office have been responsible for gathering most of the data up to this point, and a few offered comments and suggestions on layout and colors. Still, it feels like I’ve been the lead on getting these tools developed in Tableau up to this point.
One thing I should mention is that Tableau is really designed as a way to visualize data (hence the term data visualization). In these cases we are actually using it as a tool to develop an interface to university data. The goal with many of these tools, especially the University Enrollment Explorer, is to allow people to find the information they are after, and at the same time provide ways of drilling down to answer additional questions once they have that information at hand. So far Tableau has proven to be very useful for doing this and considerably more user friendly than the pivot tables in MS Excel that we were using. One nice feature is that with Tableau you can export the data behind the tables, graphs, charts, etc. to create a pivot table if someone wants to do more with the data than the visualization allows. Anyway, here’s a link to the “Self-Service Tools” on our website.
IR Self-Service Tools
I should also mention that we’ve moved our “Facts and Highlights” into Tableau as well. It doesn’t allow for the interactivity provided by the other tools, but it’s more convenient than creating all the graphs and charts in Excel or Powerpoint like we were doing. That section of our website can be found here:
Texas State University Facts and Highlights
UPDATE 3/10/2016 – Coming soon there will be a link from the “Facts and Highlights” pages which will take you to the appropriate self-service tool in case you want to drill down and explore the data further. Well, most of them will have the link since we don’t have tools that deal with everything.
One of the many things I find myself doing at work is looking at enrollment trends at colleges and universities in Texas. Most of this data is pulled from the Accountability System produced by the Texas Higher Education Coordinating Board. Anyone has used that system knows that it isn’t the most user-friendly tool. So, one of the first things I did with Tableau was put together a visualization looking at demographic characteristics of students in the state over the past several years. It’s pretty basic, but it does show a picture of how things have changed as enrollment has increased. By default it shows total enrollment at all colleges and universities, but you do have the option of drilling down to an individual institution. The visualization appears after the break…
Continue reading University Demographics in Texas
By default Tableau uses a sequential color scheme to display the full range of values (e.g. from white to green) for a measure. But a problem comes up when the data is highly skewed (e.g. when displaying the states that students come from with over 97% being from one state and the next closest value being less than 0.5% of students). The end result of this skew in the data is that the dominate category appears in one color and all the other states show up in the same color. The trick to getting around this is to re-define how the colors are scaled across the distribution. Steps on how to do this and an example of the trick in action is available after the break… (I use a map in the example, but the same principle can be applied to any situation where color shading is used to represent values.)
Continue reading Skewed Data and Heat Maps in Tableau
In one of the data visualizations I was working on I encountered a situation where I wanted to be able to switch between a display of the headcount and the percentage of people in categories. In researching the issue, I discovered that what I wanted to achieve could be done with the use of a parameter. The trick to get this to work was the use of custom formatting a measure to display positive and negative values differently, and then using a parameter to set the value being displayed.
Continue on to see the steps and an example of the feature in use…
Continue reading Switching between Count and Percent with Parameter in Tableau