Skip to main content

How to Tableau

<Still under construction>

Almost every data display I do on this blog is created in Tableau Software.  While you'll probably notice the aesthetic characteristics of the beautiful charts right away, the real power of Tableau is the ability of the viewer to interact, and to create your own view of the data.

Doing some analysis of visitors, though, it seems a lot come for a quick look at the chart and bug out. While there is nothing wrong with that, I think these people are missing a lot.

So, here are a couple of tips to get you going.  Let's take a look at a simple one, first: My post on Endowment Resources and the Enrollment of Low-Income Students.




What you see is 961 dots arranged on two scales, with each dot being one college: The x-axis compares the percentage of students with no financial aid from the institution (so-called "full-pay") to the percentage with Pell Grants (the program for low-income students).  Colleges to the right have more full-pay than Pell students, and colleges to the left have more Pell than full-pay.  The y-axis shows institutional wealth in terms of endowment resources per FTE (full-time equivalent enrollment).  It's not perfect because these colleges represent a wide range of missions and purposes, and not all endowment resources are unrestricted, but it's still a fair proxy.  In general, colleges higher on the chart have more wealth.

Let's start with an easy one.  But before that, a simple tip.  I think people are afraid of breaking things.  No matter what you do; no matter how far down a wormhole you get; you can always find your way out by clicking this little icon at the bottom of the visualization to re-set it.

Click on any of the screenshots below for a larger view.




On the right, there are several filters.  Let's say we want to look at colleges in just one state, Massachusetts.  It's easy.  Click on the dropdown box and first de-select "All."  Then click "Massachusetts," and click "Apply."  And instantly, the view changes to show only colleges in Massachusetts.



OK, but everyone knows there are good colleges outside of Massachusetts, right?  What if we wanted Massachusetts, Connecticut, New York and New Jersey?  Easy.  Boom.


And Boom:


Easy, right? Let's reset the view to all 961 colleges, and use one of the other filters, Mean SAT Score (on the 1600 point CR+M scale.)   Suppose I only wanted to look at colleges with mean SAT scores of 1100 to 1400?  All I need to do is pull the sliders (this one lets you do it in both directions) to change the display.  You can either slide the ends of the sliders, or double click in the box and type the values you want.


Now, all we see is those colleges



Of course, you can combine filters, and look at only colleges on the West Coast with Mean SAT scores between 800 and 1000, or in any combination you want.

Finally, on this view, you notice that the institutions, represented by the dots, are colored.  Each color represents a selectivity band (that is, the percent of freshman applicants offered admission.)  The red dots are the most selective, admitting less than 15% of freshman applicants.  What if we wanted to look at just them?  Tableau gives you two ways to do that:  First, you can see the filter at the top right.  You know by now that you can just click on the dropdown and select "Under 15%" and click apply.



And immediately, a pattern appears.  The most selective institutions have way more full-pay students than Pell students, for the most part.

But Tableau gives us another option.  Go back and reset the view, then hover over the color legend in the top left.  Wait until the pencil appears and the box saying "Highlight Selected Items" pops up. Click on the pencil, then click on the "Under 15%" box.


Now, instead of filtering, Tableau highlights the selection, so you can see it in context.  Now the pattern appears, but you can also see where those institutions compare to other, less selective colleges.



And you can do it for any group, like the 15% to 30% group, too.  




In fact, try clicking through the colors to see if you notice anything.

The lesson here is that you get more from a visualization if you interact with it.  And remember, your "Get out of Jail Free" card is always there, ready to help.




Comments

Popular posts from this blog

So you think you're going back to the SAT and ACT?

Now that almost every university in the nation has gone test-optional for the 2021 cycle out of necessity, a nagging question remains: How many will go back to requiring tests as soon as it's possible?  No one knows, but some of the announcements some colleges made sounded like the kid who only ate his green beans to get his screen time: They did it, but they sure were not happy about it.  So we have some suspicions about the usual suspects. I don't object to colleges requiring tests, of course, even though I think they're not very helpful, intrinsically biased against certain groups, and a tool of the vain.  You be you, though, and don't let me stop you. However, there is a wild card in all of this: The recent court ruling prohibiting the University of California system from even using--let alone requiring--the SAT or ACT in admissions decisions next fall.  If you remember, the Cal State system had already decided to go test blind, and of course community colleges in

Baccalaureate origins of doctoral recipients

Here's a little data for you: 61 years of it, to be precise.  The National Science Foundation publishes its data on US doctoral recipients sliced a variety of ways, including some non-restricted public use files that are aggregated at a high level to protect privacy. The interface is a little quirky, and if you're doing large sets, you need to break it into pieces (this was three extracts of about 20 years each), but it may be worth your time to dive in. I merged the data set with my mega table of IPEDS data, which allows you to look at institutions on a more granular level:  It's not surprising to find that University of Washington graduates have earned more degrees than graduates of Whitman College, for instance.  So, you can filter the data by Carnegie type, region or state, or control, for instance; or you can look at all 61 years, or any range of years between 1958 and 2018 and combine it with broad or specific academic fields using the controls. High school and indep

All Degrees Awarded by US Colleges and Universities, 2019

 The question often asked by high school and independent counselors is something like, "What college offers degrees in <insert major name>.  While this can't help you know what colleges offer a specific degree, it can tell you which colleges awarded those degrees in 2019. It can also help you see the shape of degrees awarded in the US, and even dive deeper into a specific college to see what types of degrees  It's pretty straight-forward, but there are also some features you need to be aware of.  If you know how to Tableau, go ahead and dive right in. The first view  using the tabs across the top shows all degrees awarded by US colleges in 2019.  From there, you can choose any specific combination of student and college characteristics: For instance, if you want to find which institutions award the most bachelor's degrees at public universities in the southwest, just click.  If you then want to find which of those colleges offer the most degrees in History, just