Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Key:

Nutrition/GSBS (TUH)
TUSMGP (TUP)
Vet (TUV)
Fletcher (TUF)

  • Bold are external deliverables

  • Items in Dark grey text have been delivered

  • [brackets] identify dependencies

“Sprint” Schedule by Data Grouping Deliverable

Sprint date

Application/Person v1 (Beth)

Engagement v1 (Helen)

Schools v1 (Beth)

Programs v1

General

Completed

  • Slate queries finalized and connected to Denodo forVet, GSBS, and Nutrition.

by Thanksgiving

  • Slate queries finalized and connected to Denodo for TUSMGP and Fletcher.

  • Query/data structure draft created [Nutrition as model].

  • Sample spreadsheet of data provided to UCM.

  • feed of NUTR 2025 cycle primary undergraduate school and major

  • develop prospectus for cleaning school data

  • Start technical conversation series with Matt

  • Finalize next data priorities

  • Build out interim marketing report for Nutrition

by Christmas

  • Applicants who straddle multiple terms (defers, early admits, dual programs): Develop start conversation @ data definitions and establish standard business practices [IR]

  • Draft queries created in Fletcher, Vet, GSBS, and TUSMGP.

  • Meeting with UCM on expectations.

  • Business process guide for Slate users providing engagement data through Denodo finalized.

  • determine path for schools data quality initiative

  • feed of NUTR 2025 cycle primary undergraduate school and major

  • Initial dataset built in TUSMGP with first-priority fields

  • complete Connecting and Combining Data with Denodo course

January 2-18, 2025

  • identify all of the types of applicants who straddle multiple terms; draft standard business practices for handling/counting them

  • Query finalized and connected to Denodo for Nutrition.

  • Meet with Vet and Fletcher to understand their

  • [funding]

  • Populate data in TUSMGP

  • Demonstrate dataset to stakeholders

  • Copy dataset model to Fletcher, Vet, GSBS, and Nutrition

  • Tableau training

January 21- February 7

  • Query finalized and connected to Denodo for TUSMGP and GSBS

  • Ask stakeholders to populate their datasets.

  • Build query to send data to Denodo for TUSMGP

February 10 - March 1

  • Copy query to Fletcher, Vet, GSBS, and Nutrition

March 4 - March 21

  • Query finalized and connected to Denodo for TUSMGP, Fletcher, Vet, GSBS, and Nutrition

Data Grouping Deliverables

Data Grouping

Version/Phase

Description

Priority (1 - critical, 5 - nice to have)

Person

v1

Basic bio/demo data, record created date, Tufts EMPLID, Hubspot flag

COMPLETE

Person

v2

Most recent program of interest, lead status flags/field?

1

Person

v3

Socioeconomic indicators

2

Person

v4

Application

v1

Basic application details, SIS program codes, basic status flags, basic funnel dates

COMPLETE

Application

v2

Advanced funnel dates, advanced status flags

Engagement

v1

RMI form submission, event registration, source import

1

Engagement

v2

Engagement

v3

Schools

v1

Primary US institution attended (bachelor’s degree awarded or expected) and major

1

Schools

v2

Program Details

v1

Cycle dates, basic program details, enrollment targets

1

Program Details

v2

Application review process details

Program Details

v3

...