leveraging vivo data: visualizations, queries, and reports
TRANSCRIPT
![Page 1: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/1.jpg)
Leveraging VIVO DataVisualizations, queries and reports
Paul [email protected] Cornell Medical College
![Page 2: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/2.jpg)
Step #1Get good data.
Step #2Create something useful.
exceptional
![Page 3: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/3.jpg)
What can we really learn from bad data?
![Page 4: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/4.jpg)
Administrators: no fansof the error bar are they
![Page 5: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/5.jpg)
Native Visualizations in VIVO
Co-author visualization
Publication sparklines
Co-investigator visualization
Temporalgraphs
Map of Science
![Page 6: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/6.jpg)
DemoTime
![Page 7: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/7.jpg)
Caveats for publication visualizations
• Is the data complete?
• Map of Science looks at the topic of the journal, not necessarily the article
• Agnostic about:- type of publication (e.g., editorial,
academic article)- significance of finding- author contribution
![Page 8: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/8.jpg)
Generating Reports
![Page 9: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/9.jpg)
Westheimer's Law
A few months in the laboratory can save a few hours in the library.
![Page 10: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/10.jpg)
Corollary of Westheimer's Law
A few hours of SPARQL query construction can save you a few seconds of searching.
![Page 11: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/11.jpg)
This does not work.
![Page 12: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/12.jpg)
This does.
![Page 13: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/13.jpg)
Object property should take user to all faculty members
who attended Tufts
![Page 14: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/14.jpg)
Strongly consider linking out your data properties as well.
![Page 15: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/15.jpg)
The tool of choice for fancy questions
SPARQL Query Builder
![Page 16: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/16.jpg)
![Page 17: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/17.jpg)
![Page 18: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/18.jpg)
Most needs for data are not articulated
![Page 19: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/19.jpg)
Articulated question #1Show me a current list of
publications by the following people.
![Page 20: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/20.jpg)
Articulated question #2Which researchers have published the most research articles within a given set of basic science journals
within the last five years?
![Page 21: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/21.jpg)
Articulated question #3How many journal articles have researchers published between October 2011 and March 2012?
![Page 22: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/22.jpg)
Articulated question #4What is my H-index?
![Page 23: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/23.jpg)
Identifying unarticulated research questions
extrapolateinvestigate
hypothesizeinfer
interviewcollaborate
![Page 24: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/24.jpg)
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison Source: Yahoo Answers
![Page 25: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/25.jpg)
We have proposed several research questions that elicited enthusiasm.
Dean’s Representative
![Page 26: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/26.jpg)
Proposed question #1How has the number of publications co-authored with other institutions
changed year to year?
![Page 27: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/27.jpg)
Proposed question #2Publications appearing in journals of
a given impact factor
![Page 28: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/28.jpg)
Proposed question #3In any given year, which paper has
the most incoming citations?
![Page 29: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/29.jpg)
Proposed question #4Which papers that have received
federal funding are not deposited in PubMed Central?
![Page 30: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/30.jpg)
Proposed question #5Who are our institutions’ open
access key opinion leaders?
![Page 31: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/31.jpg)
Proposed question #6Which PIs have the most
collaborations based on grant support?
![Page 32: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/32.jpg)
Proposed question #7Which faculty have dual
appointments?
![Page 33: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/33.jpg)
Modes of Delivery• Emailed attachments
- Spreadsheet - PDF- Word file- Bibliographic tool (e.g., .ris file)
• Link to VIVO web interface
• Third-party “data dashboard”
![Page 34: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/34.jpg)
Goals for Reporting
![Page 35: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/35.jpg)
1. Define the key questions. Goal: a set of fundamental questions
we ask about our researchers.
![Page 36: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/36.jpg)
2. Allow for more key questions to be addressed
via browsing
Ingest more data in key areas and...
In areas where VIVO hasn’t quite figured out how to do something important...
![Page 37: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/37.jpg)
3. Create third-party framework that will ingest
VIVO data and readily answer these questions.
Framework will be open source and could be incorporated into VIVO in future
releases.
![Page 38: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/38.jpg)
Data Dashboard Project for Our Summer CS Students
• build on Miles Worthington’s Drupal/VIVO work
• tackle some of the proposed questions that have not made it into core
• can be customized for di!erent viewers
• collaboration welcome
![Page 39: Leveraging VIVO data: visualizations, queries, and reports](https://reader033.vdocuments.us/reader033/viewer/2022052622/558e2ee21a28ab3b618b45c4/html5/thumbnails/39.jpg)
library.weill.cornell.edu
Is VIVO Facebook for Researchers?
• No Mendeley is… (Ha)
Questions?