IT offers technical training courses to Berkeley Lab employees in partnership with UC Berkeley. Click on the course titles below to learn more, then register through the Berkeley Lab portal.
FAQ: Can I get the recording of the workshop even if I don’t attend it live?
Yes, as long as you register ahead of time, you will automatically receive an email within a few days after the workshop (or workshop series) has completed.
- Berkeley Lab staff may contact Erin Scharfstein at ittraining@lbl.gov for training feedback.
- For trouble registering for courses, Zoom links, etc., contact dlab-frontdesk@berkeley.edu.
- Visit it.lbl.gov/training for more IT learning and consulting opportunities.
Course Listing
Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP
January 31, 2024, 9:00am to 12:00pm
This three-hour workshop will cover charts in more detail, review pivot tables, and the widely-used VLOOKUP function. Excel Data Analysis: Introduction is recommended as a prerequisite but not required.
MaxQDA Fundamentals
February 6, 2024, 1:00pm to 3:00pm
This two-hour introductory workshop will teach you MaxQDA from scratch with clear introductions, concise examples, and support documents. You will learn how to download and install the MaxQDA software, upload multiple forms of data then how to use manual and autocode features.
Python Web APIs
February 8, 2024, 10:00am to 12:00pm
In this workshop, we cover how to extract data from the web with APIs using Python. APIs are often official services offered by companies and other entities, which allow you to directly query their servers in order to retrieve their data. When APIs are not available, one can turn to web scraping.
Covidence: Getting Started
February 8, 2024, 12:00pm to 2: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.
Python Data Wrangling and Manipulation with Pandas
February 8, 2024, 2:00pm to 4: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.
Python Intermediate: Parts 1-3
February 12, 2024, 9:00am to February 21, 2024, 11:00am
This three-part interactive workshop series teaches you intermediate programming Python for people with previous programming experience equivalent to our Python Fundamentals workshop. It covers loops and conditionals, creating your own functions, analysis and visualization in Pandas, and the workflow of a data science project.
R Data Wrangling and Manipulation: Parts 1-2
February 12, 2024, 9:00am to February 14, 2024, 12:00pm
It is said that 80% of data analysis is spent on the process of cleaning and preparing the data for exploration, visualization, and analysis. This R workshop will introduce the dplyr and tidyr packages to make data wrangling and manipulation easier. Participants will learn how to use these packages to subset and reshape data sets, do calculations across groups of data, clean data, and other useful tasks.
Finding Health Statistics and Data
February 12, 2024, 12:00pm to 1:00pm
Participants in this workshop will learn about some of the issues surrounding the collection of health statistics, and will also learn about authoritative sources of health statistics and data. We will look at tools that let you create custom tables of vital statistics (birth, death, etc.), disease statistics, health behavior statistics, and more.
Stata Fundamentals: Parts 1-3
February 13, 2024, 10:00am to February 20, 2024, 1:00pm
This workshop is a three-part introductory series that will teach you Stata from scratch with clear introductions, concise examples, and support documents. You will learn how to download and install the Stata software, understand data and basic manipulations, import and subset data, explore and visualize data, and understand the basics of automation in the form of loops and functions. After completion of this workshop you will have a foundational understanding to create, organize, and utilize workflows for your personal research.
Python Web Scraping
February 15, 2024, 10:00am to 12:00pm
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.Web scraping is typically only done when Web APIs are not available.
Qualtrics Fundamentals
February 20, 2024, 10:00am to 12:00pm
Qualtrics is a powerful online tool available to Berkeley community members that can be used for a range of data collection activities. Primarily, Qualtrics is designed to make web surveys easy to write, test, and implement, but the software can be used for data entry, training, quality control, evaluation, market research, pre/post-event feedback, and other uses with some creativity.
Python Machine Learning Fundamentals: Parts 1-2
February 21, 2024, 9:00am to February 26, 2024, 12:00pm
This workshop introduces students to scikit-learn, the popular machine learning library in Python, as well as the auto-ML library built on top of scikit-learn, TPOT. The focus will be on scikit-learn syntax and available tools to apply machine learning algorithms to datasets. No theory instruction will be provided.
R Data Visualization
February 22, 2024, 10:00am to 1:00pm
This workshop will provide an introduction to graphics in R with ggplot2. Participants will learn how to construct, customize, and export a variety of plot types in order to visualize relationships in data. You will learn how to make histograms, boxplots, scatterplots, lineplots, and heatmaps as well as how to make compound figures.
Excel Data Analysis: Introduction
February 27, 2024, 9:00am to 12: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
February 29, 2024, 9:00am to 12:00pm
This three-hour workshop will cover charts in more detail, review pivot tables, and the widely-used VLOOKUP function. The course, “Excel Data Analysis: Introduction” is recommended as a prerequisite but not required.
in the bottom right or navigate to