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.
D-Lab Workshops for LBL
Science IT @ LBL has partnered with D-Lab to offer our workshops to you.
Contact Info:
- Your LBL main point of contact for questions is: Carmen Ayala <cayala@lbl.gov>
- Your D-Lab main point of contact for trouble registering, zoom links, etc is: D-Lab Frontdesk <dlab-frontdesk@berkeley.edu>
Troubleshooting: To talk to a live person to troubleshoot a problem accessing a workshop, the fastest way is to drop by our virtual frontdesk between 9am-5pm: https://dlab.berkeley.edu/frontdesk-zoom
Location: All workshops are remote-only via Zoom. Link will be sent on the morning of the event.
Cancellations: If you sign up, but cannot attend, please cancel your registration emailing the contacts list above.
Upcoming events
Feb 03
February 3, 2025, 2:00pm to February 12, 2025, 4:00pm
This workshop is a four-part introductory series that will teach you R from scratch with clear introductions, concise examples, and support documents. You will learn how to download and install the open-sourced R Studio software, understand data and basic manipulations, import and subset data,...
Feb 04
February 4, 2025, 10:00am to 12:00pm
This workshop provides a beginner-friendly introduction to coding with GitHub Copilot, a popular AI coding assistant. We will start from the basics so you can take advantage of AI assistants to improve your coding and avoid common pitfalls. First, we’ll cover how to install and set-up Visual Studio...
Feb 06
February 6, 2025, 5:00pm to 7: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,...
Feb 10
February 10, 2025, 10:00am to February 12, 2025, 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...
Feb 10
February 10, 2025, 2:00pm to 5:00pm
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.
Feb 10
February 10, 2025, 2:00pm to February 12, 2025, 3:30pm
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...
Feb 11
February 11, 2025, 10:00am to 11:30am
In this workshop, we provide a basic introduction to how to interact with your computer via terminal. We are going to focus on Bash (Bourne-Again Shell) or Zsh (Z Shell), which are one of the most commonly used Unix/Linux shells.
Feb 14
February 14, 2025, 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. We will also explore the basic grammar of graphics, including the aesthetics and geometry...
Feb 19
February 19, 2025, 10:00am to February 26, 2025, 12:00pm
For this workshop, we'll provide an introduction to visualization with Python. We'll cover visualization theory and plotting with Matplotlib and Seaborn, working through examples in a Jupyter notebook.
Feb 20
February 20, 2025, 10:00am to 12:00pm
This introductory workshop covers basics of GitHub using GitHub Desktop, a GUI Git client. This workshop is designed for people with no previous experience with Git or GitHub. We will cover key concepts and workflows, including version control, repository creation, branching, merging, and...
Feb 20
February 20, 2025, 10:00am to 12:00pm
This workshop offers a general introduction to the GPT (Generative Pretrained Transformers) model. No technical background is required. We will explore the transformer architecture upon which GPT models are built, how transformer models encode natural language into embeddings, and how GPT predicts...
Feb 24
February 24, 2025, 1:00pm to March 3, 2025, 4: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...
Feb 24
February 24, 2025, 2:00pm to February 26, 2025, 5: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...
Feb 24
February 24, 2025, 3:00pm to February 26, 2025, 5:00pm
Machine learning often evokes images of Skynet, self-driving cars, and computerized homes. However, these ideas are less science fiction as they are tangible phenomena that are predicated on description, classification, prediction, and pattern recognition in data. During this two part workshop, we...
Feb 25
February 25, 2025, 2:00pm to February 27, 2025, 4:00pm
In this 2-part workshop series, we will provide an introduction to spatial analyses in R. We discuss the benefits of the additional ‘location' component that defines spatial data and how spatial data frames organize this information. Using the sf (simple features) and terra packages, we'll navigate...
Feb 25
February 25, 2025, 3:00pm to 5: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. We will review some...
Mar 03
March 3, 2025, 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. Platforms like The New York Times, Twitter and Reddit offer...
Mar 03
March 3, 2025, 1:00pm to 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.
Mar 04
March 4, 2025, 10:00am to March 6, 2025, 12:00pm
Geospatial data are an important component of data visualization and analysis in the social sciences, humanities, and elsewhere. The Python programming language is a great platform for exploring these data and integrating them into your research.
Mar 04
March 4, 2025, 2:00pm to 5:00pm
In this workshop, we will convey the basics of deep learning in Python using keras on image datasets. You will gain a conceptual grasp of deep learning, work with example code that they can modify, and learn about resources for further study.
Mar 05
March 5, 2025, 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.
Mar 05
March 5, 2025, 3:00pm to 5: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,...
Mar 07
March 7, 2025, 1:00pm to 4:00pm
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.
Mar 10
March 10, 2025, 2:00pm to 4:00pm
In this workshop, we provide an overview of conducting U.S. Census data analysis and visualization in R. First, we’ll cover the basic concepts of U.S. Census Data. Then, we’ll demonstrate how to call the census data API directly from R by using the R tidycensus package.
Mar 11
March 11, 2025, 11:30am to March 18, 2025, 1:30pm
This three-part interactive workshop series teaches you intermediate programming Python for people with previous programming experience equivalent to our Python Fundamentals workshop. By the end of the series, you will be able to apply your knowledge of basic principles of programming and data...
Mar 17
March 17, 2025, 2:00pm to March 31, 2025, 4:00pm
This three-part workshop will prepare participants to move forward with research that uses text analysis, with a special focus on social science applications. We explore fundamental approaches to applying computational methods to text in Python. We cover some of the major packages used in natural...
Mar 31
March 31, 2025, 1:00pm to 4: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. We will also explore the basic grammar of graphics, including the aesthetics and geometry...
Apr 01
April 1, 2025, 10:00am to April 3, 2025, 12:00pm
For this workshop, we'll provide an introduction to visualization with Python. We'll cover visualization theory and plotting with Matplotlib and Seaborn, working through examples in a Jupyter notebook.
Apr 07
April 7, 2025, 8:00am to April 9, 2025, 10:00am
For this workshop, we'll provide an introduction to visualization with Python. We'll cover visualization theory and plotting with Matplotlib and Seaborn, working through examples in a Jupyter notebook.
Apr 07
April 7, 2025, 2:00pm to April 9, 2025, 4: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...
Apr 08
April 8, 2025, 12:00pm to April 10, 2025, 3: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...
Apr 22
April 22, 2025, 4:00pm to April 24, 2025, 6: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...
May 05
May 5, 2025, 10:00am to May 8, 2025, 12:00pm
This workshop is a four-part introductory series that will teach you R from scratch with clear introductions, concise examples, and support documents. You will learn how to download and install the open-sourced R Studio software, understand data and basic manipulations, import and subset data,...
NEW! No more Google form, simply click on the links at the left for the workshop you want and then on the workshop detail page click the "Register here" link.