Student Affairs Data Hub

Building a Flexible Data Integration Platform

Presentation Overview

  1. Introduction to Student Affairs Data Hub
  2. Demonstration of Data Hub Apps
  3. Brainstorming Exercise
  4. Questions & Discussion

Data Hub Introduction


The data hub began with a simple idea:

  • We have a lot of data.
  • If we combined that data, we could:
    • Use it to improve operations.
    • Understand our impact across departments.
    • Get a more complete view of the student experience.
    • Serve our students more effectively.

💡

One System to Rule Them All


This is not a new idea in higher ed. When institutions realize this though, the typical approach goes like this:

  • They find out that they have data scattered everywhere.
  • They then come to the conclusion that if they simply shoved all of their data into one giant system it would solve all of their problems.
  • Let’s think about that approach for a second and consider the work that we do.

Let's put allthe datainto one bigsystem! ...maybe weshould thinkabout that

Student Affairs: What We Do

Creating community — Binghamton residential life

Creating community

Vibrant residential colleges build connections, foster creativity, and nurture Binghamton identity.

Holistic student development — wellness & career services

Holistic student development

Wellness programs, career services, and community-based learning help develop well-rounded graduates.

Empowering individuals — student agency & diversity

Empowering individuals

Diverse perspectives are our strength—students are encouraged to shape campus and the world.

Student Affairs Data & Systems
The work that we do is very complex and it generates a lot of different data.

Student Affairs: The Data We Generate

🎯

Student Engagement

Event tracking,attendance, and organization management

Unique data needs →

🏠

Residential Life

Community data, room assignments, and facility information

Unique data needs →

📘

Academic Support

Tutoring, appointments, and study skills

Unique data needs →

🍽️

Dining Services

Meal plans, dining options, and food service

Unique data needs →

⚖️

Student Conduct

Disciplinary processes, case management, and conduct cases

Unique data needs →

💼

Career Services

Job placement, career counseling, and employer relations

Unique data needs →

The Reality

We generate a lot of different data that lives in a lot of different systems. We need those different systems to do our jobs.

Imagine Your Smartphone

  • Cramming all of student affairs into one big data system would be like having a smartphone with one big app.
  • Your online banking information would live with your doordash orders. Your personal photos would live with your work email. And your iPhone would need a screen the size of a beach towel.
  • This would be an unwieldy, confusing, nightmare and mix all of your data together in a way that no one would want.
📦

Ron's Excellent Rectangle

One app to do everything

Why One System Fails

🏠 Housing
🍽️ Dining
⚖️ Conduct
💼 Career
💚 Mental Health
📘 Academic
🏋️ Recreation
🤝 Involvement
🎓 Admissions
💲 Financial Aid
⬇️

ONE SYSTEM

❌ Too many unique business needs

❌ Data governance/security issues

❌ System performance

Imagine Your Smartphone

  • Instead, think of how your phone actually works.
  • You choose the apps you need and you download them.
  • Each app has a specific purpose and relies on specific data.
  • You wind up with a group of apps that meet your needs collectively.
📧 🎵 🗺️ 📸 💬 📊 🛒 🎮 📘 💼 🛠️ 🌐 🎓 🍽️ 💚 📱 📝 📅 🧭 📡 🧾 📌

Specialized apps for different needs

What is the Data Hub?

The Data Hub is simply an environment that we have built in-house that allows us to:

  • Pull: the data that we need from different systems.
  • Combine: that data in a way that makes sense.
  • Automate: that process so we get the data in real-time
  • Build: a catalog of custom data apps that allow people to use that data they need in a secure way.
🎯️
🏠
📘
⬇️

Data Hub

🔗

Integration

⚙️

Apps

⬇️
App
App
App

Instead of All the Data in One Place

Charlie's Conspiracy Dashboard of All the Crosstabs You Could Ever WantControls titleBubble2024-01-012024-03-01toSu Mo Tu We Th Fr Sa« January 2014 »29 30 312 3 417 8 956101119 20 212223242530129312627282345678Date range 2014-01-01Su Mo Tu We Th Fr Sa« January 2014 »29 30 312 3 417 8 956101119 20 212223242530129312627282345678Date inputSelect boxChoice 1Choice 2Choice 3 Choice 1ActionAction ButtonThemeRiverPolar - Area\Coxcomb (The Florence Nightinglae chart)JanFebMarAprMay100% stacked barSelect boxChoice 1Choice 2Choice 3 Choice 1Waterfallitem 1item 2item 3item 4100% Stacked ColumnSlider0102030405060708090100500100Slider0102030405060708090100500100Slider range250100010203040506070809010050Choice 3Choice 2Choice 1Checkbox groupspeciesislandbill_length_mmbody_mass_g12345678910AdelieAdelieAdelieAdelieAdelieAdelieAdelieAdelieAdelieAdelieTorgersenTorgersenTorgersenTorgersenTorgersenTorgersenTorgersenTorgersenTorgersenTorgersen39.139.540.34036.739.338.939.234.1423750380032503925345036503625467534754250Showing 1 to 10 of 344 entriesShow10entriesSearch:Previous123...35NextDatabaseBrowse... No file selectedFile inputLinePepe SilviaSingle checkboxPepe Silvia 1Numeric inputTree MapActionAction ButtonActionAction ButtonActionAction ButtonOooh astacked bargraphsquiggles!This is usefuldotswhat does thisdo?bubblesKPI...what?impactbump datagame changer!

We Can Pull and Combine Exactly What We Need for Each App

System 1System 2System 3Data App 1Data App 2

Create Custom Data Apps and Make Them Available to Specific Users

Data App 2Data App 3Data App 1

What exactly is a data app?


A data app is a dashboard on steroids:

  • A data app is a fully functioning web application.
  • This means it can have the same capabilities as any web app — forms, simulations, messaging, integrations.
  • This takes us far beyond the typical dashboard that only shows a few summary metrics.
  • It is the most flexible, customizable, and powerful way to share data.

Data App Data App Data AppData Apps?

Data Apps: The Starting Point


Before adding all the bells and whistles, we need to start simple:

  • Think about your day-to-day job — making decisions, planning operations, working with students.
  • What information would be most helpful to have at your fingertips?
  • A data app is just a tool to bring all of that information together into one place so you can use it.

Data App = Cheat SheetFiltersOverviewJanFebMarAprMayKey MetricsContextExploration

The Challenge: A Blank Canvas


  • The Data Hub is extremely flexible.
  • When we design an app, we have a blank canvas that allows us to design anything.
  • To guide our work, we rely on some core principles.

Idea?

Dashboard?

Survey?

App?

Report?

Core Design Principles


  • Identify: concrete problems that we can solve for the university.
  • Understand: the needs of people using the app.
  • Involve: those users in the design process.
  • Evolve: so our offerings continue to improve over time.

📌 Identify

Focus on concrete problems we can solve for the university.

👥 Understand

Consider the needs of people using the app.

🤝 Involve

Engage users directly in the design process.

⚡ Evolve

Ensure our offerings continue to adapt and improve over time.

A New Approach to Assessment


Data Hub Development:

  • These principles shift the traditional process of assessment to a much more active, collaborative approach.
  • We need to work together to generate ideas and solve problems.
  • We’re going to jump into the data hub so we can look at some examples of how this is done.
  • Then, we’re going to brainstorm some ideas of new things that we can create.

Data AppFiltersOverviewJanFebMarAprMayReplace withdifferent dataThis is unclear

Data Hub Demostration


Example Apps:

  1. Decker Advising Leaderboard App: a practical use case.
  2. TSS & B-Healthy Apps: expanding on the framework.
  3. First-Year Advising App: full control and exploration.

Example 1: Decker Advising App


Engagement Leaderboard:

  • Decker advising wanted to create an involvement competition between cohorts.
  • Students get points for their group for checking-in to events.
  • Encourages student participation in B-Engaged.
  • Gamifies student engagement.

Top Groups

🥇 Alpha Club
950 pts
🥈 Beta Society
800 pts
🥉 Gamma Org
700 pts
4 Delta Team
540 pts
5 Epsilon Group
430 pts

Example 1: Decker Advising Leaderboard App


Engagement Leaderboard:

  • The concept is simple, but the execution is complicated.
  • The manual process would be time consuming and inefficient.
  • It would also need to be repeated every time there is new data.

Decker Advising Leaderboard App:

  • Core Data: Attendance data from Decker Advising Events.

Xevent-1.xlsxXevent-2.xlsxXevent-3.xlsxStudent DataPull/Stack IndividuallyJoinCompute ScoresPublishReturn to beginning,repeat forever

Example 2: Scaling for TSS & B-Healthy


Scaling for Other Areas:

  • The shell of one app can be quickly and easily adapted for other areas.
  • Using the events framework, we can remove the leaderboard, add demographic information, and connect this to events from one area or across departments to create new apps.
  • This allows us to scale our work.

Example 2: Scaling for TSS & B-Healthy


Transfer Student Services App:

  • Core Data: Attendance data from Transfer Student Success Events and demographic information from Banner.


B-Healthy App:

  • Core Data: Attendance data from all events hosted, co-hosted, or tagged as B-Healthy events and demographic information from Banner.

DeckerAdvisingLeaderboardTransfer StudentSuccess AppB-Healthy Events AppRemoveleaderboard, Add demographicsScaleacrossunits

Example 3: First-year Advising App


Full Control and Exploration:

  • Apps do not need to be focused on event data.
  • Imagine the needs of an advisor that works with first-year students.
  • They may want to see individual data to guide conversations with students.
  • They also may need data on the entire class for context.

First-Year Advising App:

  • Core Data: I’m not listing them all, look at the app.

First-Year Advising AppIndividualStudent ProfileClass Overview

App Design Exercise


App Design:

  • Now that we have seen a few examples, we’re going to spend some time brainstorming some app designs.
  • Each table is going to come up with a data app design that solves a problem (big or small) for the university.
  • So how do we design a new app? It’s simple, we map it out and draw it.
  • Let’s take a look.

Data Hub Brainstorming💡Data SourcesUser ProfileApp Sketch

Interactive Design Exercise

Data App = Cheat SheetFiltersOverviewJanFebMarAprMayApp DesignUsersData05Radio buttonsChoice 3Choice 2Choice 1What data?What does itlook like?Who's usingit?LightningPitchWhat problemare you solvingwith data?

Begin with First Principles


Return to the core idea:

  • Think about your day-to-day job — making decisions, planning operations, working with students.
  • What information would be most helpful to have at your fingertips?
  • What problem will this solve?
  • Discuss this with your table and pick one idea to focus on.
  • Write your group’s idea at the top of your worksheet.

Data App = Cheat SheetFiltersOverviewJanFebMarAprMayApp Design

Who’s using it?


Think about who will be using your app and create a basic user profile:

  • Who are they?
  • Where do they work?
  • What do they do?
  • Jot down some key characteristics about your users that helps inform your design.

UsersWho's usingit?

What data?


Think about the data that you need for your app:

  • What specific data do you need?
  • What systems or departments have the data?
  • Jot down a list of key data sources. Be specific.

DataWhat data?

What does it look like?


Sketch out the app:

  • What do users need to see? (graph? raw data? individual information or overall trends?)
  • What should they be able to explore?
  • How will they contextualize the data?
  • Use the worksheet to sketch out what your app will look like.

05Radio buttonsChoice 3Choice 2Choice 1What does itlook like?

Lightning Pitch


Sell your app:

  • Come up with a 30 second pitch to convince others why your app will be useful.
  • How will it help the app user?
  • What areas can use it?
  • Who does it benefit?
  • What problem does it solve?

LightningPitch

Data Hub Roadmap

🔑

CAS Authentication

Complete integration with the University’s Identity and Access Management System for secure, seamless login.

📊

Predictive Analytics

Build and deploy predictive models in-house to gain actionable insights for key outcomes like retention.

🔗

New Data Sources

Connect to additional data sources to broaden the Data Hub’s coverage and scope.

Collaboration Opportunities


We are looking to collaborate:

  • We are looking for areas that want to collaborate on designing new apps and helping us refine the process.
  • We need areas that are willing to pilot new apps and explore how to incorporate data more effectively in their daily work.
  • If you have an idea, even if we didn’t discuss it today, please reach out to SAASE.

💡💡💡App Design

Questions Welcome

In conclusion,Mono means 1 andrail means rail...Thanks forListening!