Using the WSIF Comparison Tool for Data Analysis

Data analysis is a process of reviewing your data, asking questions, and figuring out which data would best answer your question.

We are using the WSIF, and the WSIF Comparison Tool workbook, as an example of using Tableau to answer your data analysis questions.  Let's navigate to the Comparison Tool to start, under the Secure Data Portal project > Data Tools for All subproject. 

As always, we are going to start with the "About" view.  In this case, it has a ton of information that is really helpful in understanding this complicated workbook.


 

 

 

Let's take a look at the first view - walk through what the display is, how to understand it, and how to manipulate what data are being shown. 

 

 


How would you use this display to find a school that mirrors your school's grade level and demographics?  How would you use it to find a school that is high achieving in a particular data domain to contact and share best practices?

 

 

What about using it to inform continuous improvement within your ESD or district?  Where is your district in comparison to others?

  

 


The next view is very similar - it's the same data and functionality as the histogram, but displayed on a "unibrow".  This shows each school as a dot rather than a bar, and they are stacked next to, rather than on top of, one another. 

Now let's move on to the third view, the "Three Year Score Change Comparisons".  This view shows the change of data from the initial 2017 WSIF run to the data just released in February.  This display can be best understood as how much a school's data changed from the first run to the most recent.  This can be used to find schools that might not have the highest scores/rates, but have made a lot of progress, therefore can be recognized as having implemented some successful improvement strategy.  Let's take a look at a couple of examples:

 
 

Let's see what this display looks like when you are highlighting a district, or trying to tell a story about your school that might not be high achieving but displaying impressive growth over time:

 
 

And one more thing about this display...

 
 

The next view is a dynamic version of the "details" measure breakdown that we have on the Washington State Report Card.  The boxes are color coded by the score each data element is assigned.  The final view is a deeper dive into the "trend" measure breakdown, and shows the trend of each data element over the last two years.

Now it's your turn to play with this comparison tool, and ask questions you want answered!