Skip to main content

Software Tools for Data Analysis

July 15, 2024

This course provides an overview of the popular software packages currently used for data exploration, analysis, and visualization. The first part of the course emphasizes Excel and Tableau. The Excel portion covers basic charts and their use with pivot tables. The Tableau component introduces students to advanced data exploration and visualization methods through a variety of charts and dashboards. The second part of the course examines exploratory data analysis in R. Students learn how to write their own code for importing, cleaning, and exploring large datasets, as well as how to create, modify, and export complex charts and summaries for visual, qualitative, and quantitative analysis. The third part of the course provides an introduction to SQL databases, where students learn how to create SQL queries to select, filter, and manipulate data.