/
Using the Student Journey Sankey Diagram

Using the Student Journey Sankey Diagram

Overview

A Sankey diagram is a data visualization tool that demonstrates the flow of values from one state to the next. In the Student Journey Sankey Diagram, you can see these data elements for a specific student:

  • which course was completed

  • date when the course was completed

  • college where the course was completed

  • degree earned

  • date when degree was earned

  • college from where the degree was earned

The example below demonstrates the interactive part of the diagram. Hover over each course to see where the course was completed and when. The diagram is organized with the oldest course/degree at the bottom of the page and the newest completed course/degree at the top of the page.

Animation of the diagram showing when you point to a course, it shows the date and college.
Student Journey Sankey Diagram Animation

To learn more about Sankey diagrams and experiment with an interactive diagram, see the Sankey Diagram Overview page, authored by the company Data to Viz.

Setup

Requirements

  • A Business Intelligence (BI) tool such as Quicksite, PowerBI, or Tableau. The Sankey Diagram cannot be accessed via direct SQL queries.

  • The BI tool must be connected to the Data Warehouse and be used while connected via VPN. If your college already uses a BI tool with the Data Warehouse, no additional permissions are required.

    • New BI users must follow existing Data Warehouse credential onboarding processes.

Request Access

Submit a request for access to the Student Journey Sankey Diagram using this Request Form.

Using the Diagram

  1. Using your BI tool, filter on sx_student_id for the student you want to learn about.

  2. The Sankey Diagram will open with the student data over time:

    • A college name indicates the course was completed at the home college.

    • “Other College ###” indicates the course was not completed at the home college.

    • The semester and year next to the college name indicates when the course was completed.

    • The course identifier and degree is listed on the right side of the diagram.

Sankey diagram with these features highlighted - college where course was completed, date when course was completed, course identifier and degree earned.
Sample Student Diagram

  1. To view details of a course, hover over the course to blur out the rest of the courses.

    Pointer hovering over a course to better see the college name, course date, and course identifier.
    Course Detail

  2. If the student has earned a degree, this will also show in the timeline. Hover over the degree to see details:

associates-date.png
Associate’s Degree Details