Today we have access to more information than ever before, but how do you use the information you have to make the best decision? This course teaches you how to put information and data to work when making business decisions.

BENEFITS:

At work, you have access to more information than you know what to do with. You probably realize the information is valuable, but have no idea how to take advantage of it to make more profitable decisions. Learn to put to use information using common business applications to model the outcomes of different decisions and make better choices.

The class will detail the different methods of business modeling and demonstrate practical examples from numerous functional areas of business.

DESIGNED FOR:

You cannot afford to miss this class if you're in production, marketing, finance, business analysis, management, accounting, engineering and R & D. You'll learn the basics of using information you already have to make business decisions that lead to success. You need to have a very basic understanding of Microsoft Excel to participate in this course.

OVERVIEW:

You'll learn the practical steps to analyzing business data, which will help you optimize current operations and determine the outcomes of your decisions. Why continue making decisions in the dark, this course will give you the tools to make better decisions, use more information and have better support for the decisions you make.

OUTLINE:

1. Spreadsheet Modeling
   1. The seven-step modeling process
   2. Review of the basic concepts
   3. Tips to improve your efficiency
   4. Introduction to macros
   5. Breakeven analysis - example
2. Basic Optimization Modeling
   1. Optimization versus what-if models
   2. Benefits of optimization modeling
   3. The basic optimization model
   4. Excel: solver and solver table
   5. Product mix - example
3. Advanced Optimization Modeling
   1. Human Resource - example
   2. Finance - example
   3. Marketing - example
   4. Operations - example
4. Decision Tree Modeling
   1. When do we use decision trees?
   2. Types of decision tress
   3. Excel add-in: decision trees
   4. Contract bidding - example
5. Simulation Modeling
   1. When do we use simulation?
   2. Benefits of simulation
   3. Excel add-in: simulation
   4. Demand versus supply - example

LOCATION:

Business Modeling & Data Analysis:Using Data to Make Better Decisions will be held in the CMD Training Center in the Woodman Alumni Building on the Wichita State University campus in Wichita, Kansas.   

General Information for Nearby Accommodations

Candlewood Suites
3141 N Webb Rd
Wichita, Kansas 67226
(316) 634-6070

Courtyard by Marriott
2975 N Webb Rd
Wichita, Kansas 67226
(316) 636-4600

Hilton Garden Inn
2041 N Bradley Fair Pkwy
Wichita, Kansas 67206
(316) 219-4444

Residence Inn
1212 N Greenwich Rd
Wichita, Kansas 67206
(316) 682-7300