Data Sources

Excel Data Analysis: Introduction

February 14, 2023, 1:00pm
This is a three-hour introductory workshop that will provide an overview of Excel, with no prior experience assumed. Attendees will learn how to use functions for handling data and making calculations, how to build charts and pivot tables, and more.

Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP

September 7, 2023, 10:00am
This three-hour workshop will cover charts in more detail, review pivot tables, and the widely-used VLOOKUP function. We recommend first taking the introductory workshop Excel Data Analysis: Introduction.

Python Data Wrangling and Manipulation with Pandas

November 15, 2021, 2:00pm
Pandas is a Python package that provides fast, flexible, and expressive data structures designed to make working with 'relational' or 'labeled' data both easy and intuitive. It enables doing practical, real world data analysis in Python. In this workshop, we'll work with example data and go through the various steps you might need to prepare data for analysis.

Excel Data Analysis: Introduction

September 7, 2022, 4:00pm
This is a three-hour introductory workshop that will provide an overview of Excel, with no prior experience assumed. Attendees will learn how to use functions for handling data and making calculations, how to build charts and pivot tables, and more.

Python Web Scraping

February 15, 2024, 10:00am
In this workshop, we cover how to scrape data from the web using Python. Web scraping involves downloading a webpage's source code and sifting through the material to extract desired data.

GPT Fundamentals

April 17, 2024, 3:00pm
This workshop offers a general introduction to the GPT (Generative Pretrained Transformers) model. We will explore how they reflect and shape our cultural narratives and social interactions, and which drawbacks and constraints they have.

Python Web Scraping

April 5, 2022, 1:00pm
In this workshop, we cover how to extract data from the web using Python. We focus on two approaches to extracting data from the web: leveraging application programming interfaces (APIs) and web scraping.

Python Web Scraping & APIs

June 29, 2022, 1:00pm
In this workshop, we cover how to extract data from the web using Python. We focus on two approaches to extracting data from the web: leveraging application programming interfaces (APIs) and web scraping.

Python Data Wrangling and Manipulation with Pandas

March 15, 2023, 2:00pm
Pandas is a Python package that provides fast, flexible, and expressive data structures designed to make working with 'relational' or 'labeled' data both easy and intuitive. It enables doing practical, real world data analysis in Python. In this workshop, we'll work with example data and go through the various steps you might need to prepare data for analysis.

Covidence: Getting Started

February 29, 2024, 12:00pm
Covidence, a web-based tool licensed by the UC Berkeley Library, helps with your systematic and other literature reviews, which are popular processes to summarize and synthesize literature in your topic of interest. Covidence helps you organize and track progress on your review, from search results to extraction. This interactive workshop will take you through how to use Covidence. How to add reviewers or make changes mid-review, how to develop exclusion criteria, and how to get help will be covered. There will be plenty of time for Q & A during this session; you are welcome to raise questions about your specific review or review process.