| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
University Marketing and Communications have University Communications and Marketing originally set up dashboards to track various metrics around admissions marketing for GSAS & Grad Engineering.
Sananda Ghatak is now working on doing the same thing for Nutrition, now that UCM is providing support for them.
Sample data:
started building these for Nutrition & Vet in 2023, TUSMGP in 2024, and on 7/12/2024 Fletcher requested one.
| Tip |
|---|
The Fletcher request pushed us to recognize that we cannot build each of these databases as a one-off, but that they are all part of a greater “complex project” of Enrollment Analytics. The dashboard itself is a deliverable; there are multiple deliverables within this project, they cross many units within Tufts, and there is a continuous feedback loop as we refine the process for this individual deliverable, but also revisit previous deliverables for Nutrition and Vet. |
Matt Girard set up the connection between Slate and Denodo in September, 2023 for Nutrition; he even wrote a guide: https://tufts.box.com/s/
...
From: Kell, Rachel Ann <Rachel.Kell@tufts.edu>
Sent: Monday, July 17, 2023 1:14 PM
Going forward we will not be bringing file exports into the oracle data warehouse, so the process will be different. We will be using our data virtualization platform in order to provide users access to scheduled exports.
Her suggestion to Sananda was to use Box; testing proves I can drop Slate files into Box.
Two files have been created in the GradHlthSci instance of Slatepyt4crtp6xq2d0gyrqedr6i7yxntqfxq
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 for each school in each instance of Slate that have this regular export to Denodo:
...
- Get Nutrition approval for sending this data
And, some sort of change of heart:
From: Kell, Rachel Ann <Rachel.Kell@tufts.edu>
Sent: Friday, August 18, 2023 1:00 PM
To: Ghatak, Sananda <Sananda.Ghatak@tufts.edu>; Storrs, Elizabeth <Elizabeth.Storrs@tufts.edu>; Snell, Linda E. <Linda.Snell@tufts.edu>
Cc: Mitchell, Marny <Marny.Mitchell@tufts.edu>; Lin-Huang, Chun-Pi <Chun_Pi.Lin@tufts.edu>
Subject: RE: sample data for UCM dashboard for Nutrition prospect and applicant data
It might just be easiest at this point to use one of the ones the DWBI group has already set up for other purposes. I can set up a sub folder specifically for Slate Reports and then we can publish them as a Tableau data source through Denodo.
Beth, what info would you need from me to send reports to one of our accounts? Client id and secret? Or an upload email address? I assume each report would overwrite the previous one?
VET Prospect CJ Feed for Dashboard (feed to Denodo)
VET Apps CJ Feed for Dashboard (feed to Denodo)suitcase sent to TUSMGP 5/7/2024 b5aa515a-0ba1-46ae-bb34-1ea18c9b87a3:tuh
Matt Girard has access via a direct permissions on the queries themselves.
I also created a spreadsheet, per Matt:
“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?”
https://tufts.box.com/s/lz9rm1y05ycab0op5d6k9igvg78yi27l
This file contains the links to access the queries, the field descriptions, and the tokens for Vet, since they were created at the same time as the spreadsheet.
...
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.
For any updates, send a ticket to bi-service@tufts.edu (which creates a Service-now ticket)
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