OpenAIRE Graph Training: Analysing data with Big Query
Join us in a hands-on training session designed to help you learn or refine your skills in analysing OpenAIRE Graph data from the Google Cloud with Biq Query. The workshop will alternate between presentations introducing the subject and queries and hands-on practice with guidance from our trainers. As such, spots are limited so register now!
Who is it for?
- Anyone interested in scientometrics and bibliometrics
Criteria for participating
- Must have a Google account
- Having SQL rudiments is not required, but a bonus
About the Trainers
Dr. Andrea Mannocci is a Research Fellow at the InfraScience Laboratory within the Institute of Information Science and Technologies (ISTI), part of the Italian National Research Council (CNR) in Pisa, Italy. His work focuses on the development and analysis of the OpenAIRE Graph, with research interests at the intersection of Scientometrics and Open Science practices. He holds a PhD in Information Engineering from the University of Pisa. Prior to his current role, he was a Research Associate at the Knowledge Media Institute (KMI) of the Open University in Milton Keynes, UK, where he contributed to the SKM3 research team (Scholarly Knowledge Modelling, Mining, and Sense Making) and specialized in applying data science techniques to scholarly big data and research analytics.
Dr. Alysson Fernandes Mazoni holds a background as a control and automation engineer with a PhD on applications of Machine Learning at the University of Campinas, Brazil. Currently, he conducts research on quantitative methods for Geosciences and scientometrics as applied to innovation economics and scientific information systems for the Global South. Affiliated as a post-doctoral research fellow also at University of Campinas.
Agenda
- Introduction to Google Cloud and Big Query
- Gentle introduction to SQL
- Introduction to the OpenAIRE Graph dataset on Big Query
- Simple queries walkthrough and exercises
- Advanced queries (e.g., with JOINS and Big Query functions) walkthrough and exercises
We look forward to your active participation!