Page Comparison

“Sprint” Schedule by Data Grouping Deliverable

Sprint date	Application/Person v1 (Beth)	Engagement v1 (Helen)	Programs v1	General
Completed	Slate queries finalized and connected to Denodo for Vet, GSBS, and Nutrition.
by Thanksgiving 27 Nov 2024	Slate queries finalized and connected to Denodo for TUSMGP and Fletcher.	Query/data structure draft created for [Nutrition as model]. Meeting with UCM on expectations. Sample spreadsheet of data provided to UCM.		Start technical conversation series with Matt Finalize next data priorities
by Christmas 20 Dec 2024		Query finalized and connected to Denodo for NutritionDraft queries created in Fletcher, Vet, GSBS, and TUSMGP. Business process guide for Slate users providing engagement data through Denodo finalized.	Initial dataset built in TUSMGP with first-priority fields
January 2-18, 2025		Query finalized and connected to Denodo for Nutrition. [I would be leery of build engagement data business process guide until you have done the initial data exploration in all of the instances--there is a lot of iteration in that initial build out]
January 21- February 7
February 10 - March 1
March 4 - March 21

...

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)	1
Schools	v2	grade point average and major for primary institution
Program Details	v1	Cycle dates, basic program details	1
Program Details	v2	Application review process details
Program Details	v3

...