Spreadsheet Modeling And Decision Analytics

Catalog description

The objective of this course is to prepare students to analyze data and solve real-life business problems, using Microsoft Excel as a tool. This course challenges students to use data analytic and critical thinking techniques to identify key business problems. Students will use case study to articulate business value from analytic results and translate analytics into decisions that improve business performance. Topics include statistical analysis tools, data visualization and manipulation, logics in decision-making, financial analysis, spreadsheet modeling, optimization, and solver model. Prerequisite(s): (MGMT 21100 FOR LEVEL UG WITH MIN. GRADE OF C- OR ISM 21100 FOR LEVEL UG WITH MIN. GRADE OF C- OR BIA 21100 FOR LEVEL UG WITH MIN. GRADE OF C-) AND (BIA 22500 FOR LEVEL UG WITH MIN. GRADE OF C- OR BIZA 22500 FOR LEVEL UG WITH MIN. GRADE OF C-) Course Learning Outcomes 1. Analyze data and solve real-life business problems, using Microsoft Excel as a tool. 2. Use data analytic and critical thinking techniques to identify key business problems. 3. Use case study to articulate business value from analytic results and translate analytics into decisions that improve business performance. Topics include statistical analysis tools, data visualization and manipulation, logics in decision making, financial analys View Class Schedule