Data @ Rice

Excel Pivot Tables

Excel pivot tables help you to quickly summarize, report and find patterns in your datasets. This short course will cover how to setup a pivot table from scratch and special techniques to make the most of this feature. The use of Excel Pivot Tables will help you to organize, visualize and gain insights from your data.

Note: This is part II of the Using Excel to Manage and Analyze Data workshops. Part I is not required to attend this class.

Introduction to SQL

Introduction to relational databases and how SQL queries are utilized to manipulate and store data from a relational database. We will cover the basic syntax of SQL queries as well as discuss its cross-application with various other data analysis tools.

 

R visualization with ggplot2

In this class I will give an introductory lesson to the functionality and application of the ggplot2 package in R. The purpose of this class is to add a data visualization component to the data manipulation tools developed in the previous class thereby giving a more comprehensive understanding of data analysis.

 

Introduction to GitHub

GitHub is a place where millions of developers gather every day to collaborate on open source software. It hosts billions of lines of code. This course will give a step-by-step tutorial for beginners to get started with git and Github. Learn all the important pieces of GitHub that you should know.

Colors in Data Visualization

This workshop will discuss how to select colors that complement the message of your data visualization without sacrificing readability. We will also review best practices for using color to encode numerical values and explore how color can be used to accent information and establish a clear visual hierarchy.

Please contact dataworkshop@rice.edu if you need to cancel your registration or have any questions.

Introduction to Effective Data Visualization

This workshop will review research in visual perception and explore how different visual forms impact a viewer’s understanding of the data. We will also discuss general guidelines for visualization design. Participants will have the opportunity to apply what they learned during a hands-on visualization exercise.

Please contact dataworkshop@rice.edu if you need to cancel your registration or have any questions.