Past Data & Donuts Workshops
Links to presentation files, materials for hands-on exercises, Zoom recordings of past workshops are available below. Workshops are listed in chronological order with the most recent workshops listed towards the top of the page. Please note that any Zoom recording links for workshops that took place more than one year from the current date will no longer work.
Spring 2023
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.
Instructors: |
Meryl Brodsky & Hannah Chapman Tripp |
Date: |
1/20/2023 (Fri.) |
Time: |
12:00 - 1:15p.m. |
Location: |
Zoom (Virtual Workshop) |
Recording: |
Watch in Zoom |
Downloads: |
Presentation Slides |
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.
Instructor: |
Andrea Cato |
Date: |
1/27/2023 (Fri.) |
Time: |
12:00 - 1:15p.m. |
Location: |
Zoom (Virtual Workshop) |
Recording: |
Watch in Zoom |
Downloads: |
Tableau Dashboard |
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.
Fall 2022
Instructor: |
Michael Shensky |
Date: |
9/2/2022 (Fri.) |
Time: |
12:00 - 1:15p.m. |
Location: |
Zoom (Virtual Workshop) |
Recording: |
Watch in Zoom |
Downloads: |
Presentation Slides |
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.
Instructors: |
Ian Goodale & Michael Shensky |
Date: |
10/14/2022 (Fri.) |
Time: |
12:00 - 1:15p.m. |
Location: |
Zoom (Virtual Workshop) |
Recording: |
Watch in Zoom |
Downloads: |
Presentation Slides |
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.
Instructors: |
Meryl Brodsky and Michael Shensky |
Date: |
10/28/2022 (Fri.) |
Time: |
12:00 - 1:15p.m. |
Location: |
Zoom (Virtual Workshop) |
Recording: |
Watch in Zoom |
Downloads: |
Presentation Slides |
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.
Spring 2022
Recipes for Successful Research Data Management
Instructor: | Katherine Strickland & Michael Shensky |
Date: | 1/28/2022 (Fri.) |
Time: | 12:00 - 1:15p.m. |
Location: | Zoom (Virtual Workshop) |
Downloads: | Workshop Slides
Zoom Recording |
This workshop will provide you with hands-on opportunities to apply effective data management practices as we explore the parallels between research and cooking. Together, we will look at similarities including the importance of quality inputs, the necessity of carefully documenting workflows, and other factors critical to success.
Introduction to Tableau
Instructor: | Andrea Cato |
Date: | 2/11/2022 (Fri.) |
Time: | 12:00 - 1:15p.m. |
Location: | Zoom (Virtual Workshop) |
Downloads: |
Zoom Recording
Useful Links
|
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.
GIS and Digital Elevation Model (DEM) Data
Instructor: | Michael Shensky |
Date: | 2/18/2022 (Fri.) |
Time: | 12:00 - 1:15p.m. |
Location: | Zoom (Virtual Workshop) |
Downloads: | Workshop Slides
Zoom Recording |
High resolution digital elevation model (DEM) data can now be found online for many areas of the world. GIS software and Python can be used to visualize elevation data in both 2D and 3D, and to analyze digital elevation models in a variety of different ways that are of relevance to researchers in many different fields. Attend this workshop to learn about how you can make use of DEM data in your work.
Spreadsheets and OpenRefine
Instructor: | Hannah Chapman Tripp & Meryl Brodsky |
Date: | 2/25/2022 (Fri.) |
Time: | 12:00 - 1:30p.m. |
Location: | Zoom (Virtual Workshop) |
Downloads: | Workshop Slides
Zoom Recording |
During this extended 90 minute interactive workshop, participants will learn best practices for working with spreadsheet data. After a brief presentation, the instructors will guide participants in cleaning a pre-provided dataset using the open-source tool OpenRefine. Topics covered in OpenRefine will include: sorting and filtering, saving scripts, and exporting the final cleaned data file. We ask that registrants download
OpenRefine 3.5.1 and make sure they can open it prior to attending the workshop. Please contact
Meryl Brodsky or
Hannah Chapman Tripp if you are experiencing difficulty downloading or opening the software.
Data Ethics in the Era of Social Justice
Instructor: | Meryl Brodsky |
Date: | 3/4/2022 (Fri.) |
Time: | 12:00 - 1:15p.m. |
Location: | Zoom (Virtual Workshop) |
Downloads: | Presentation Slides |
In this discussion-focused session, we will consider who the data belongs to when researchers generate data, how the data collection process works and who is impacted, what happens to the data post data collection, who is responsible for maintaining/stewarding the data, and who corrects data when errors are uncovered.
Fall 2021
Introduction to Python for Data Management
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 work with data.
Managing Research Data: UT
Resources & Best Practices
Instructors: | Hannah Chapman Tripp & Anna Dabrowski |
Date: | 9/17/2021 (Fri.) |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PPTX) Zoom Recording (Video) |
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.
Historical Maps as Data
Instructor: | Kat Strickland |
Date: | 10/1/2021 (Fri.) |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides Zoom Recording (Video) |
The UT Libraries is steadily migrating scanned maps from the online Perry-Castañeda Library (PCL) Map Collection to the Texas GeoData and UT Collections portal. Learn about finding georeferenced maps in the Texas GeoData portal, using them with GIS software, and the metadata and image enhancements to maps in the UT Collections portal.
Drone Imagery as Data
Drones have become a powerful research tool because of their ability to collect very high resolution geospatial imagery. This workshop will discuss how imagery collected with drones can be processed, visualized, and analyzed to study vegetation, topography, and geomorphology. It will provide an introduction to the use of photogrammetry software, GIS, and Python for image analysis.
US Census Data in Context and Practice
Instructors: | Meryl Brodsky, Janelle Hedstrom, Bill Kopplin, Michael Shensky |
Date: | 10/22/2021 |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides Zoom Recording (Video) |
This workshop will provide an introduction to US census data, explore the information collected by the Census Bureau and cover how it has evolved over time. It will address uses and limitations of data access and management. Tools for working with census data like GIS software and SimplyAnalytics will be introduced.
Spring 2021
Managing Research Data: UT
Resources & Best Practices
Instructor: | Hannah Chapman Tripp & Anna Dabrowski |
Date: | 1/29/2021 (Fri.) |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) Zoom Recording (Video) |
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.
Geocoding Historical Data to Revive the Social Memory of Wheatville
Instructor: | Julia Bordelon & Isaac Womack |
Date: | 3/26/2021 (Fri.) |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Zoom Recording (Video) |
Wheatville was a freedmen’s community in the area now known as West Campus. This project maps the racial demographic changes in this neighborhood from the late 1800s to the mid-twentieth century. In this workshop, we will follow the paths of several Wheatville residents to showcase the complexities of geocoding historical data, and explore how this process can revive the social memory of communities.
Data Discovery and Access (RESCHEDULED FROM 2/26)
This workshop is intended to outline a process for finding existing datasets. We’ll cover statistics vs data, how to search for subject-specific data repositories, searching literature for data, and identifying agencies or institutions that collect data. Participants will get a chance to search for data in their field and assess a dataset.
Historical Maps as Data
Instructor: | Kat Strickland |
Status: | CANCELLED |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
The UT Libraries is steadily migrating scanned maps from the online Perry-Castañeda Library (PCL) Map Collection to the Texas GeoData and UT Collections portal. Learn about finding georeferenced maps in the Texas GeoData portal, using them with GIS software, and the metadata and image enhancements to maps in the UT Collections portal.
Fall 2020
Introduction to Python for Data Management
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 work with data.
Mapping COVID Data with R
R is a free and open source programming language and robust software environment that allows for development of scripted reproducible data science workflows. Join us for this workshop which illustrates the power of R through a demonstration which will show how it can be used to map publicly available COVID data.
Python for Data Visualization
This workshop will go beyond the basics of Python to introduce attendees to the data visualization capabilities provided by packages like the Plotly graphing library. It will cover the process of installing new packages to extend the functionality of your Python installation and demonstrate the advantages of scripted data visualization.
Texas Land History in GIS
Instructor: | Josh Conrad |
Date: | 10/23/2020 (Fri.) |
Time: | 12:00 p.m. |
Location: | Zoom (Virtual Workshop) |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads | Maps & Data Zoom Recording (Video) |
Using Texas original land survey data, digitized historic maps, and current land parcel data, this workshop will show how GIS can be used to construct a historical model of land use in Texas. The workshop will introduce several GIS operations, including georeferencing and spatial querying, that can help us connect the present with the past.
Spring 2020
Automating GIS Processes with Python
Instructor: | Michael Shensky |
Date: | 3/6/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Python is a powerful, widely used, scripting language that can be used to automate GIS processes in both QGIS and ArcGIS environments. This workshop will show you how to get started using Python to turn complex, tedious geospatial workflows into simple, documented, and reproducible scripted routines.
Designing ArcGIS Online Story Maps
Instructor: | Albert Palacios |
Date: | 2/28/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Downloads: | Workshop Materials |
Using georeferenced data from an Augustinian Order’s book of professions (Mexico, 1537-1620) and other related archival materials held at the Benson, this workshop will introduce you to ArcGIS StoryMaps, a web-based presentation tool for geospatial research. We will show you how to create and incorporate a map into an ArcGIS's StoryMap.
Analyzing Census Demographic Data with GIS
Instructor: | Michael Shensky |
Date: | 2/21/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Demographic data collected by the U.S. Census Bureau and other similar agencies in other countries is often freely shared online in GIS compatible formats, but can often be difficult to utilize effectively. This workshop will showcase how these datasets can be excellent resources for supporting insightful geospatial analysis and discuss data processing strategies that are important for obtaining valid results.
Using GIS to Work with Historical Imagery & Maps
Instructor: | Josh Conrad |
Date: | 2/14/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Historical maps and aerial photos can be valuable resources for geospatial analysis but often require georeferencing with GIS software before they can be effectively utilized. This workshop will demonstrate how to make the most of these historical raster based datasets.
Finding Geospatial Data Online
Instructor: | Michael Shensky |
Date: | 2/7/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will provide instruction on browsing for geospatial data, cover how to search for specific datasets to download, and will discuss how to process downloaded data using GIS software to enhance its usability.
Getting Started with ArcGIS Pro
Instructor: | Michael Shensky |
Date: | 1/31/2020 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
ArcGIS Pro is now 5 years old and it is a great time to get acquainted with all of the new functionality that Esri's most powerful GIS software offers. This workshop will provide a walk through of all major ArcGIS Pro functionality and cover important things to know for transitioning successfully from ArcMap.
Fall 2019
Managing Research Data: A Guide to Good Practice
Instructor: | Jessica Trelogan |
Date: | 9/13/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Dealing with the mountains of digital data that accumulate in the course of a research project can seem like a daunting process, especially if your work is collaborative or stretches over several years. Adopting a few key good habits early on can save you huge amounts of time, money, and frustration searching for things and recovering lost files. This workshop will provide a general introduction to core data management concepts, practical tips for things like backups and file formats, and a wealth of information about tools and resources available to UT faculty, staff, and students.
Intro to GIS & Geospatial Data
Instructor: | Michael Shensky |
Date: | 10/18/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will provide an explanation of key geospatial terms and concepts and an introduction to geographic information system (GIS) software for visualizing, analyzing, storing, processing, and managing geospatial data. By the end of this session you should have the core knowledge required to start working effectively with geospatial datasets.
Spring 2019
Map Making with GIS Software
Instructor: |
Michael Shensky |
Date: |
3/8/2019 (Fri.) |
Time: |
3:00 p.m. |
Location: |
PCL Learning Lab 1 |
Event Type: |
Workshop |
Event Series: |
Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will cover the essentials of cartographic design and teach you how to design a custom map using QGIS software and openly available data that you can download online. Laptops preloaded with QGIS software will be available for attendees to use in the interactive portion of this work, but you are welcome to bring your own laptop if you would like so that you can work on your personal computer.
Designing ArcGIS Online Web Maps
Instructors: | Michael Shensky Albert Palacios |
Date: | 3/1/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
ArcGIS Online is a cloud GIS platform which supports data hosting and provides an easy to use web interface for designing interactive web maps without having to write any code. This workshop will cover the process of uploading geospatial data to ArcGIS Online, publishing it as a web service that can call be called by web applications, and creating a customized Story Map web application that presents the data in a narrated fashion through an interactive map interface.
R for Geospatial Analysis
Instructor: | Emily Beagle |
Date: | 2/22/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will provide an introduction into the use of R and the RStudio integrated development environment for geoprocessing and geospatial analysis. Importing, manipulating, and visualizing geospatial data in R will be discussed in addition to demonstrations of common cases where geospatial analysis in R might be beneficial. Laptops with RStudio will be available so that you can follow along. No previous R experience is required.
Managing Data with GIS Software
Instructors: | Michael Shensky Jessica Trelogan |
Date: | 2/15/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 2 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will cover the essentials of working with geospatial data along with a review of data management best practices so that you can learn how to avoid the pitfalls that often ensnare researchers who are new to working with geospatial information.
Finding Geospatial Data Online
Instructor: | Michael Shensky |
Date: | 2/8/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will provide instruction on browsing for geospatial data, cover how to search for specific datasets to download, and will discuss how to process downloaded data using GIS software to enhance its usability.
Introduction to GIS and Geospatial Data
Instructor: | Michael Shensky |
Date: | 2/1/2019 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
This workshop will provide an explanation of key geospatial terms and concepts and an introduction to geographic information system (GIS) software for visualizing, analyzing, storing, processing, and managing geospatial data. By the end of this session you should have the core knowledge required to start working effectively with geospatial datasets.
Fall 2018
Metadata Basics
Instructor: | Melanie Cofield |
Date: | 9/21/2018 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
The importance of metadata is often misunderstood or underestimated. Metadata helps people find resources and determine their value. Learning basic concepts and understanding the purpose of standards can help you streamline your research and data management methods. If you've ever had difficulty finding relevant and reliable resources, or sifting through your own research data, you'll appreciate this session.
Designing Surveys with Qualtrics
Instructor: | Krystal Wyatt-Baxter |
Date: | 9/28/2018 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Learn how to use Qualtrics, a powerful survey tool available to UT faculty, staff, and students, to administer surveys. This workshop will touch on the basics of survey design while teaching you how to use Qualtrics to administer online surveys ranging in complexity. We will discuss question types and their ideal uses, how to avoid common survey pitfalls, and how to design survey flow. By the end of the workshop, you should be able to design, send, and perform basic analysis on a survey using Qualtrics.
Organizing Data in Spreadsheets
Instructor: | Jessica Trelogan |
Date: | 10/5/2018 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Spreadsheets can be a powerful tool for entering, analyzing, and managing data, but it’s crucial to ensure that they are well-formatted from the outset, before you even start entering data. This 1.5 hour hands-on* workshop will teach you how to think about data organization to increase your efficiency and help ensure that your data are reusable. We will discuss good data entry practices, how to avoid common formatting mistakes, basic quality control, data manipulation, and exporting.
Visualizing Spatial Data
Instructor: | Michael Shensky |
Date: | 10/5/2018 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
There’s more than one way to skin a cat make a map. This new take on an old adage speaks to the recent proliferation of software tools and online platforms for visualizing data spatially. This workshop will provide a broad overview of commonly used tools, from powerful open source GIS software like QGIS to new online web mapping platforms like ArcGIS Online. If you have ever wondered how to make a map from a table of geospatial coordinates or a list of addresses – this session is for you. Live demonstrations will showcase the diverse array of mapping tools that are available to UT faculty, staff, and students for creating engaging visualizations from a variety of geospatial datasets.
Qualitative Data Sharing
Instructors: | Janelle Hedstrom & Jessica Trelogan |
Date: | 10/19/2018 (Fri.) |
Time: | 3:00 p.m. |
Location: | PCL Learning Lab 1 |
Event Type: | Workshop |
Event Series: | Data & Donuts |
Downloads: | Workshop Slides (PDF) |
Qualitative data is no longer exempt from data sharing policies, although the sensitive nature of these data can pose special challenges to achieving real transparency. This workshop addresses several critical concerns and offers a few practical solutions that may make it easier to avoid unintended consequences. We will touch on basic issues of consent and IRB, secure storage, de-identification, data use agreements, and how to share and publish while adhering to ethical standards.