Page Comparison

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 [Nutrition as model].

• Meeting with UCM on expectations.

• 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

by Christmas
20 Dec 2024

• Applicants who straddle multiple terms (defers, early admits, dual programs): Develop 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

• Initial dataset built in TUSMGP with first-priority fields

• complete Connecting and Combining Data with Denodo course

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]

• Meet with Vet and Fletcher to understand their

• 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

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

v2grade 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