Data Visualization Tool Tips and Tricks from our Business Intelligence Specialist - Sept 2018

Here are some tips and tricks for getting the most out of our Looker Ad-Hoc Reporting data visualization tools from Dave Hoy, our Business Intelligence Specialist.


Student Scorecard updates.  As we head into the second academic year for Looker, we have added another “Scorecard” view to the Candidate explores.    As a reminder, the Candidate Scorecard views are very useful for determining counts for nearly every aspect of student activity in the system. 

  • Candidate Scorecard Summary – This view gives “career” totals per student, there are no timeframe constraints at all.  if a student has been in school one, two or six years, it will give you activity totals for the entire time.
  • Candidate Scorecard Current Year – All of the same categories as the above, but this view is for the current year only.  Just recently this view was reset to show tallies of activity since 7/1/2018 forward.
  • Candidate Scorecard Prior Year – This is a brand new view that is exactly like the other two in terms of data fields, but the activity is from 7/1/2017 through 6/30/2018. 

Communication Preferences Data is now modeled in Looker.  This is found in the Candidate Master views, and allows you to filter and do metrics so that you can understand what notifications your students are requesting from the system.

School Samples – Use Them! – A reminder that the School Samples folder is in the Shared space that you all have access too.  I’ve put several new Looks there, and you can copy any of these report templates to your own Space and make them your own.  Most recent addition is a Year-over-year monthly comparison of Advising/Coaching notes, called “Notes by Month, YOY”.  There are a few tricks you can learn by reviewing this Look.

Advising Blocks are now modeled in Looker.  For those of you that have adopted the new way of setting up advising / coaching appointments, this is accessible in Looker under the Advising Block explore in Looker.  With regard to how this impacts any existing Looks you have for student advising activity, filled appointment reports, etc., there is no change in those areas.


Dave Hoy

Dave, Business Intelligence Specialist, is a co-founder and minority shareholder of GradLeaders. Dave has been immersed in the MBA recruiting business since 1990, and helped pioneer the first MBA resume database products that were distributed to recruiters. Dave graduated magna cum laude from Franklin University with a major in computer management.

To enable comments sign up for a Disqus account and enter your Disqus shortname in the Articulate node settings.