Nutrition

ST-50 - Getting issue details... STATUS

University Marketing and Communications have set up dashboards to track various metrics around admissions marketing for GSAS & Grad Engineering.

Sananda Ghatak was trying to do the same thing for Nutrition, now that UCM is providing support for them.

Matt Girard set up the connection between Slate and Denodo in September, 2023; he even wrote a guide: https://tufts.box.com/s/pyt4crtp6xq2d0gyrqedr6i7yxntqfxq

I ran through the first portion of Creating Web Services for Queries within Slate and then shared the URL with him:

With that URL he created the views; caching is an option, but all rows were taking less than 2 seconds.

Sananda has access to the Denodo views within Tableau for her dashboards.

Two files exist in the GradHlthSci instance of Slate that have this regular export to Denodo:

NUTR Prospect CJ Feed for Dashboard
NUTR Apps CJ Feed for Dashboard

Matt Girard has access via a direct permissions on the queries themselves.

Updating the queries:

As data shifts and new and different fields are required, the queries in Slate just need to be updated, and the Denodo manager(s) informed, so they can update their processes.

Interface Views:

From: Girard, Matthew Matthew.Girard@tufts.edu
Date: Friday, March 15, 2024 at 9:45 AM
To: Storrs, Elizabeth Elizabeth.Storrs@tufts.edu, Ghatak, Sananda Sananda.Ghatak@tufts.edu
Cc: Kell, Rachel Ann Rachel.Kell@tufts.edu
Subject: Re: Friedman Slate Data Question

…

Also, while we’re making updates, I’m going to be making another pair of views that we call “interface views” which are finalized views that we want all folks to be using going forward.

The plan is for users with basic read access to only have read access to these final views to prevent folks from getting lost in the sea of base and intermediate views that aren’t ready for consumption.

On your end, the only change you’ll need to make are the names of the tables you’re using :

Change j_nutrition_applicants_prospects to nutrition_applicants_prospects
Change j_nutrition_prospects_applicants to nutrition_prospects_applicants

Vet

I need to write the queries for vet, and file a ticket with bi-service@tufts.edu when I am ready.

Queries copied from NUTR via suitcase and updated in to the same formats:

List with descriptions

I also created a spreadsheet, per Matt on 3/15

“when you get a chance, can you please send along an excel file that has a description of each query (with the URL to the query in Slate), along with descriptions for each of the fields in the queries?”