ADEC 7910 Software Tools for Data Analysis (Fall: 3 )
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 — spreadsheet/Excel and Tableau. In Excel we will cover basic method, tools, charts, with the emphasis on pivot tables. In Tableu students will be introduced to data collection, exploration and visualization methods. The second 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 arrange the data. The third part of the course will cover basic data analysis in statistical software packages Stata and 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.
Last Updated: 14-Jun-17