Prescriptive Analytics: Optimization - Online

PRESCRIPTIVE ANALYTICS: OPTIMIZATION

ONLINE

PRESCRIPTIVE ANALYTICS: OPTIMIZATION In this foundational, hands-on course, you will use Microsoft Excel to build spreadsheet models for any organization.

These models will include key performance indicators linked to variables that are under the decision maker’s control.

By identifying variables, you will be able to use software to craft solutions. We will use Excel’s Solver tool to find the solution that optimizes the key performance indicator. We will apply the techniques to applications in various functions of a business. You will walk away with the skills to use this in your company and identify solutions to organizational problems.

Topics Covered

• •

• •

Analytics Foundations Spreadsheet Modeling

Linear Programming Key Performance Indicators

Certificate Program This course is a part of the MBA Foundations: Your Access to Business Foundations certificate. Participants who complete the MBA Foundations certificate will receive a $1,500 scholarship applicable towards the tuition of any of the four MBA programs at the University of Utah.* Additionally, you will have the opportunity to meet one-on-one with one of our directors to discuss your career goals. *To qualify for the scholarship, participants must apply for the MBA program and be admitted. The scholarship is eligible for up to 18 months after completing the MBA Foundations certificate.

I Need This Program Because: •

I want to learn valuable career skills and tools

•

I need to know how to evaluate data

My Organization Needs This Program Because: •

We want to optimize processes based on data-insights

•

We need to harness data to solve business -related problems

•

We want to identify hidden risks and opportunities

independently •

I aspire to approach difficult decisions

Who Needs This Class • • •

Anyone who wants to adopt data-driven decision-making practices Business professionals who want to find key insights for their organizations and make strategic recommendations, using tools that they already have access to Leaders looking to optimize key performance indicators and identify solutions to organizational issues

Modules Analytics Overview

Types of Linear Programming Problems

• • •

•

Fact-Based Decision-Making Analytics Definition Application Examples

•

Introduction to Spreadsheet Modeling & Linear Programming • • •

Analysis of the Red Brand Case • • •

Describe the Situation and Problem Identify Decision Variables Identify Key Performance Indicators

100% online, led by instructor

Product Mix, Blending, Covering, and Transportation Shortest Path & Maximum Flow Examples

On-demand access, 12 weeks to complete

Determine Relevant Numbers Application on Blending Problem Brief Introduction to Sensitivity Analysis

5-6 hr. of lecture, readings, and self-reflection

Presenting Faculty | Don Wardell, Ph.D. Don G. Wardell is a Francis A. Madsen Scholar and Professor of Operations and Information Systems (OIS) at the University of Utah’s David Eccles School of Business (DESB). He served for several years as the Chair of the OIS Department and, before that, the Management Department. He received BS and MS degrees in Metallurgical Engineering from the University of Utah and a Ph.D. degree from Purdue University’s Krannert Graduate School of Management.

THE ECCLES DIFFERENCE The David Eccles School of Business enrolls about 6,000 students in its eight undergraduate majors, four MBAs, seven other specialized graduate programs, one Ph.D. program, and executive education curricula. It is also home to seven institutes and centers that support an ecosystem of entrepreneurship, technology, and innovation, including the Lassonde Entrepreneur Institute, Ken C. Gardner Policy Institute, Sorenson Impact Center, and more.

Our faculty members boast impressive professional and educational backgrounds and hold Ph.D.s from esteemed universities including the University of Pennsylvania’s Wharton School, Northwestern University’s Kellogg School, Harvard Business School, Stanford Graduate School of Business, and University of California at Berkeley’s Haas School.

TAKE THE NEXT STEP Telephone: (801) 587-7273 Email: ExecEd@Utah.edu Website: ExecEd.Utah.Edu Registration: Eccles.Secure.Force.com/ExecEdApplication 1731 E Campus Center Drive Robert H. and Katharine B. Garff Building, GARFF 4340 Salt Lake City, Utah 84112

042321