Research

Tableau Public II: Intermediate

This workshop will cover the following topics:

  • Merge data from different data sheets/datasets
  • Create parameters and calculated fields
  • Understand differences between table calculation and regular calculation
  • Use quick table calculations
  • Create regular calculations on number, string, and date
  • Add analytics objects such as reference line to the view

Advanced Excel

This short workshop will cover techniques for using Excel productively. It will introduce you to functionality such as Advanced Formulas, Data Tables & Conditional Formatting, Charting, Pivot tables and Macros and VBA programming.  Use of these excel features will help you to analyze, visualize and gain insights from your data.

Excel 101

 Introduction to using spreadsheets for beginners or a refresher for the sometime user. Covers basic features and options of Microsoft Excel, including how to organize and navigate tabular data, creating and using simple formulas, formatting worksheets and other helpful tips.

Introduction to Tableau Public

Tableau is a fast rising and award-winning data visualization tool in Business Intelligence (BI) and Analytics Platforms.  It helps people see and understand data. In the presentation part of the workshop, we will introduce some basic BI terms, Tableau products, and some limitations of Tableau Public. 
In the hands-on part of the workshop,  using the DMC equipment circulation data as a sample data set, we will cover:
 • how to connect to data
• how to create charts to visualize data in worksheets

Getting Started with GitHub

Would you like to better manage software versions and collaborate with other researchers? GitHub is a widely-adopted code repository that supports collaboratively developing software and other text-based projects. This hands-on workshop will introduce participants to the basics of GitHub, such as setting up GitHub, creating a branch, and committing changes. We will also look at a few examples of how researchers are using GitHub. Please bring your laptop!

How to Manage Your Data

Please see http://researchdata.rice.edu/training/ for the latest update, 8/23/2017.  

Drowning in data? Not sure how to organize and back it up? This hands-on, interactive workshop will share tips for effectively organizing, documenting and storing research data. Participants will walk away with ideas for completing a data inventory and data storage/ backup plan for their own data, as well as tips for writing data management plans (as required by many grant agencies).