Grad Hlth Sci Trainings/Notes

Direct link to folder with trainings: https://tufts.box.com/s/0ffmpphevy7na0zi1mi89py8nwyhl53f

2025-02-24 Query Training #1

0.0 Building out the differences between old local prospects base and the new CJ persons

4:45 ref id/Slate ID are now names the something (ref) in both exports and filters

6:50 why are the person numbers different from the prospect numbers?

10:30 one tag versus many tags/

14:30 exists/not in looks for records with a tag on the record, and that tag is NOT the filtered

32:30 sorting

39:00 ranking

We covered some differences between the local Prospects base and the CJs Person base, spending some time exploring tags like opt-out and the behavior of EXISTS/NOT EXISTS with IN/NOT IN for a subquery. We compared the subquery behavior to that of base joins and talked about the importance of including sorts or filters when pulling in one specific row from the related table. 

Ahead of the next session, try building out some queries with EXISTS/NOT EXISTS and IN/NOT IN joining to other tables in Slate and bring any examples where you're surprised by the results (not seeing a record you expect, seeing records you don't expect). We'll plan to dig further into the example of applications that have specific decisions and talk about how to build queries for active applicants that don't have a deny decision for another application (including what this might look like on a Person base vs. an Application base and why one or the other might be preferable).

2025-03-10 Query Training #2

Dependent Subquery

2025-03-17 Query Training #3

Independent Subqueries

using the results of an entirely new query to inform the current one

filter recreation of last week’s query: comparison on person GUIDs (matching) and app GUIDS (not matching) gets the same

Demo: invite people from particular state to an event in that state.

Independent sq: Related events>forms>region compared to person region to find the target group

15:00 build to find twins

41:00 brainstorming other use cases for independent subquery comparisons

48:00 discussion of faculty data sets

Thanks for a great discussion today about independent subqueries! We compared this approach to last week's dependent subquery for finding applicants with other apps that had a deny, and then went looking for twins.