AEM 3030 - Explorations in Analytic Modeling

Fall, Spring. 1.5 credits. Letter grades only (no audit).

Prerequisite: AEM 2010.

D. Haeger.

Explorations in Analytic Modeling is a fully online, asynchronous course offering a deeper exploration of model-based approaches to quantitative decision-making within a spreadsheet platform. Applied decision-making primarily using Microsoft Excel as a business analytics tool will focus on performing descriptive, predictive and prescriptive analytics while addressing a wide range of business cases. Emphasis will be placed on exploration that enhances decision making to improve outcomes. This data-driven course will move the student from intro to the most complex functionality available in the Excel platform. Key topics will include data integrity, data management, visual analytics, text analytics, financial modeling, forecasting, optimization, pivot tables, simulation, and dashboard design. The course spans industries and verticals as we explore reasoning with data to address problems in business enterprises leading to optimal managerial decision-making, effective communication of recommendations, and understanding the world of business analytics.

Outcome 1: Apply spreadsheet modeling analysis and decision-making to different industries in business.

Outcome 2: Design spreadsheet models for a breadth of business situations and problems.

Outcome 3: Demonstrate effective and efficient data display with charts and tables through model design and experimentation.

Outcome 4: Infer and predict outcomes using forecasting and trending with financial impact analysis.