ADEC 7900 Software Tools for Data Analysis
The course provides students with an overview of popular software packages used today for data exploration, analysis and visualization. The first part of the course will offer an overview of the non-programming tools Excel and Tableau. In Excel we will cover basic charts with the emphasis on their use with pivot tables. In Tableau students will be introduced to more advanced data exploration and visualization methods via a variety of advanced charts and dashboards. The second part of the course will cover exploratory data analysis in R. Here students will 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 of the data. The third part of the course will provide an intro to using SQL databases, where students will learn how to create SQL queries to select, filter and manipulate the data.
Course overview
- Department
- Advancing Studies
- School
- ADV
- Credits
- 3
- Level
- Graduate
- Offered
- Periodically in the Fall
Course evaluations
- Course rating
- 4.35 / 5 · Very Good
- Instructor rating
- 4.46 / 5 · Very Good
- Terms evaluated
- 8
| Term | Instructor | Course overall | Instructor overall | Well organized | Clear learning objectives | Intellectually challenging | Helpful assignments | Applicable beyond course | Attendance necessary | Weekly effort | Responses |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Spring 2026 | Marc Chale | 4.0 | 4.5 | 4.0 | 4.5 | 4.5 | 4.8 | 4.8 | 4.0 | 10+ hrs/week | 4 of 9 |
| Fall 2025 | Marc Chale | 4.4 | 4.6 | 4.7 | 4.7 | 4.9 | 4.6 | 4.6 | 3.5 | 7–9 hrs/week | 7 of 12 |
| Fall 2025 | Stefano Parravano | 4.6 | 4.6 | 4.8 | 4.6 | 4.6 | 4.8 | 4.8 | 4.8 | 7–9 hrs/week | 5 of 7 |
| Summer 2025 | Stefano Parravano | 4.5 | 4.5 | 4.6 | 4.6 | 4.8 | 4.6 | 4.6 | 4.2 | — | 8 of 12 |
| Spring 2025 | Marc Chale | 3.9 | 4.1 | 4.3 | 4.6 | 4.3 | 4.0 | 4.6 | 3.6 | 7–9 hrs/week | 7 of 10 |
| Spring 2025 | Stefano Parravano | 4.3 | 4.0 | 4.0 | 4.0 | 4.3 | 4.3 | 4.3 | 4.3 | 7–9 hrs/week | 3 of 6 |
| Fall 2024 | Marc Chale | 4.4 | 4.7 | 4.5 | 4.8 | 4.6 | 4.8 | 4.7 | 4.4 | 4–6 hrs/week | 12 of 15 |
| Fall 2024 | Stefano Parravano | 4.9 | 4.9 | 4.7 | 4.7 | 4.3 | 4.9 | 4.9 | 4.9 | 7–9 hrs/week | 7 of 15 |
| Summer 2024 | Stefano Parravano | 4.3 | 4.6 | 4.5 | 4.3 | 4.6 | 4.6 | 4.3 | 3.7 | 7–9 hrs/week | 8 of 11 |
| Spring 2024 | Marc Chale | 4.4 | 4.3 | 4.4 | 4.8 | 4.3 | 4.6 | 4.6 | 4.7 | 4–6 hrs/week | 8 of 10 |
| Spring 2024 | Stefano Parravano | 4.8 | 4.8 | 4.6 | 4.7 | 4.8 | 4.9 | 4.8 | 4.9 | — | 10 of 13 |
| Fall 2023 | Arvind Sharma | — | — | — | — | — | — | — | — | — | 11 of 21 |
| Fall 2023 | Stefano Parravano | — | — | — | — | — | — | — | — | — | 9 of 12 |