Data & Donuts

Storing research data in a database can help researchers explore their data with queries, facilitate collaboration, improve data security, and ensure data integrity. This workshop will explore the differences between relational, graph, and document databases to showcase how researchers can make use of the functionality they offer for managing data. These database models will be explored through examples involving queries with SQL and Cypher, use of Google Colab and Python for managing databases, and data visualization with graphs.

Learning and adopting a few good habits can go a long way in managing your data. In this introductory workshop on data management concepts, you will learn about the many resources available at UT to help manage your data as well as best practices and tips for managing data. This workshop will be a lecture with interactive components; come with your questions.

Tableau is a data visualization tool built around the philosophy that users should be able to build useful, beautiful charts quickly and easily. In this workshop we will cover how to connect to data, build several chart types, and publish dashboards to share. Before this session, please request and install a free student license for Tableau Desktop or download and install Tableau Public.

This workshop will provide an introduction to using SQL (Structured Query Language) to store and manage data in a relational database. Gaining familiarity with SQL can help researchers better manage large datasets, construct detailed data queries, and utilize SQL dependent filtering functionality in applications like GIS software.

When you start working with large datasets or need to develop reproducible workflows, the ability to develop scripted processes for data processing and analysis can be essential. Tune in for this workshop to learn the basics of using Python, a popular free and open source scripting language, to process and manage research data. This will be the first in-person workshop since the start of the pandemic and donuts will be provided!

This workshop is a basic introduction to R and RStudio. It assumes no prior knowledge of R or programming. We ask that participants download R and then RStudio prior to the start of this workshop so that you can participate in a few active learning exercises throughout the session. For a more detailed workshop description and software installation instructions please see the following workshop overview document.

In this workshop you will have a chance to gain experience using Python to retrieve data from different online sources that you can utilize in your research. After retrieving data using APIs, you will learn how to process and clean the data for further analysis and visualization using pandas and matplotlib.

This workshop will discuss important considerations for researchers who are looking to preserve and publish their data. It will also highlight specific repositories that you can make use of to satisfy data preservation requirements and support open science. During the workshop we will demonstrate how to use the Texas Data Repository and discuss how to link deposited data to items in Texas ScholarWorks.