FTA 3100 - Foundations of Data Analytics

Description

This course introduces a variety of modeling and analytic methods using data to describe, diagnose, predict, and prescribe real-world decisions and processes. Students will learn basic skills in Excel and R to prepare data to conduct statistical analyses, such as testing hypotheses and forecasting. Students will know how to import data and conduct regression analysis in Excel and R. They will have experience with Excel and R data visualization tools. They will learn about linear and nonlinear models and how to select a model that best fits the data based on the visual representation of past data and logical intuition. They will also learn about different spreadsheet modeling analyses for business outcomes, linear optimization models for business, and strategy-based decision analysis. Preliminary supplemental materials for Excel and R are available to prepare students for this course.

Learning Objectives

After completing this course, students will be able to:

• Perform basic spreadsheet tasks in Microsoft Excel and R.
• Calculate and assess probabilities from several common probability distributions.
• Describe, analyze and visualize data.
• Make decisions using several decision-making criteria.
• Obtain and interpret linear regression models for decision-making.
• Obtain and interpret forecasting models for decision-making.
• Formulate and solve linear programming models.
• Formulate and solve integer and nonlinear programming models.