...
University Marketing and Communications have set up dashboards to track various metrics around admissions marketing for GSAS & Grad Engineering.
Sananda Ghatak is now working on doing was trying to do the same thing for Nutrition, now that UCM is providing support for them.
Sample data:
...
From: Kell, Rachel Ann <Rachel.Kell@tufts.edu>
Sent: Monday, July 17, 2023 1:14 PM
, but DW no longer uses the process for moving data that NUTR set up:
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 Rachel Kell’s suggestion to Sananda was to use Box; testing proves I we can drop Slate files into Box.
Two files have been created in the GradHlthSci instance of Slate:
NUTR Prospect CJ Feed for Dashboard
NUTR Apps CJ Feed for Dashboard
- 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 , but the hitch was that I needed an account (and a password!) to drop things into Box, and that wasn’t something we could set up.
This percolated for a while, and then DW came back with “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?
-Rachel”
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.
...