Tag Archives: analysis tools

Data Cleaning with R Bootcamp

Please join A2DataDive on Tuesday, November 8th from 12-1 in NQ 2185 for a bootcamp on statistical analysis using R.

Data Cleaning with R
Tuesday, November 8, 12-1 pm in NQ 2185

In this session, we will explore a “cookbook” of “recipes” for common data cleaning and wrangling tasks, specifically geared toward preparing your client’s raw data for the data dive. We will specifically focus on using R/RStudio and a variety of common R libraries to execute recipes for merging datasets, cleaning and rearranging text fields, pivoting/reshaping data, summarizing by groups, handling categorical data, creating indicator variables, scaling quantitative variables, and other tasks requested in the pre-bootcamp survey. If we have time, we will also look at some quick, useful exploratory data analysis tools in R.

If you are attending this session, please share what your needs are by filling out this 30-second survey. Please also download RStudio before the session.

Tableau bootcamp

Please join A2DataDive on Wednesday, November 2, 12-1pm in NQ 1255 for a bootcamp on Tableau.

Visualization with Tableau 
Wednesday, November 2, 12-1pm in NQ 1255
This bootcamp is hosted by MSI student Josh Gardner. We’ll cover the process of loading, analyzing, and visualizing data in Tableau, introducing the Tableau interface and how to connect it to data, with guidance and suggestions on preparing high-impact visualizations and dashboards with Tableau. Following this are topics that might be of special interest to Data Divers, including dealing with different data types/formats, summarizing data within Tableau, filtering, using categorical data, and replicating the same visualization/dashboard for multiple datasets. There will be sample data to get everyone started, but participants should also feel free to bring their own data and explore that if they prefer. For download instructions, visit Installing Tableau.

Excel Bootcamp

Our first bootcamp, presented in partnership with SOIAR, covered Excel.

MS Excel 

Wednesday, October 26, 12-1pm in NQ 1255
This first session is on the many wonders of Excel, starting from the ground up. We’ll cover everything from sorting to pivot tables and all that’s in between and then give you a chance to work with some data sets while we are there to answer questions.  (presented in partnership with SOIAR)