• Call us: 1-800-992-6345 or 316-978-3118
  • Log in to My Records

Search Courses

Business Modeling and Data Analysis: Using Data to Make Better Decisions

Search Courses

Print This

Business Modeling and Data Analysis: Using Data to Make Better Decisions

This class will change how you analyze your data, make your decisions and gauge your profitability.

Register button

This class meets two consecutive days. April 8 & 9, 2021

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.

This is a hands-on class.  Every participant will be assigned a CMD laptop to work on during the class.  You need to understand how to use Microsoft Excel to participate in this course.  CMD offers “Excel Essentials – Basic to Advanced”.

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.

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, when this course will give you the tools to make better decisions, use more information and have better support for the decisions you make.

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

Spreadsheet modeling

  • Review of the basic concepts
  • The seven-step modeling process
  • Tips to improve your efficiency
  • Goal seek and data tables
  • Introduction to macros
  • Breakeven analysis – example


Basic optimization modeling

  • Optimization versus what-if models
  • Benefits of optimization modeling
  • The basic optimization model
  • Excel add-ins: solver and solver table
  • Product mix – example


Advanced optimization modeling

  • Study the assumptions
  • Capital budgeting- example
  • Workforce scheduling – example
  • Other examples of optimization models


Network optimization modeling

  • What is a network model?
  • Transportation / supply chain – example
  • Job or machine assignment – example


Decision tree modeling with specialized software

  • Palisade software suite of Excel add – add ins
  • When do we use decision trees?
  • Types of decision trees
  • Palisade Excel add-in: precision trees
  • Contract bidding – example

“Dr. Sue was very professional and knowledgeable. Very informative and enlightening. I will be able to take what I’ve learned and apply it to my job.”

Grant Waters, Project Controls Analyst, Evergy, Topeka, Kansas

“This class opened the realm of possibility that has evolved with the use of Microsoft Excel. The capability of Excel has allowed an individual/company to explore and make informed decisions without having to wait weeks or months for the information. Dr. Sue is very knowledgeable of the subject she teaches & has worked to stay current in this field. Thank you for making the 2 days fun and full of information & learning.”

Steve Roach,  Textron Aviation, Wichita, Kansas

“Vital information/tools/tips for any Analyst, new and seasoned professional alike!

“Daniel Kautz, Project Manager, Wichita Kansas

“Great program. Very impressed with the structure of the classroom, lunch, etc. The subject matter was very useful in our day-to-day job functions. Dr. Sue is an excellent instructor! I thoroughly enjoyed the small class and the one-on-one assistance. Great learning experience and I look forward to returning in September for another class with Dr. Sue.”

Linda Holleman, Retail Sales Administrator, Great Plains Industries, Inc., Wichita, Kansas

“Great program. Excellent service overall.  It was clear to me that CMD operates like a business and understand customer satisfaction and responding to the needs of customers. Dr. Sue was a great instructor. Very easy to work with and truly wants to help people learn the material. The real world examples are the best, these aren’t just made up out of the blue, but real world problems that you could see.   I enjoyed “testing what I’ve learned” the most by building our own model from a paragraph.” 

Brad Jones, Flint Hills Resources, Wichita, Kansas

Business analyst, financial analyst, estimators, directors, and anyone who works with data, finances, or estimating.  This class is an excellent class working with Excel.

A Guide to the Project Management Body of Knowledge, (PMBOK® Guide) – Sixth Edition, Project Management Institute, Inc., 2018.

Copyright and all rights reserved. Material from this publication has been reproduced with permission of PMI.

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.


Talent Triangle values:

  • PMP/PgMP: 9 Technical  0 Leadership  3 Strategic
  • PMI-ACP: 0 Technical  0 Leadership  3 Strategic
  • PMI-SP: 0 Technical  0 Leadership  3 Strategic
  • PMI-RMP: 0 Technical  0 Leadership  3 Strategic
  • PfMP: 0 Technical  0 Leadership  3 Strategic
  • PMI-PBA: 3 Technical  0 Leadership  3 Strategic

Substitutions are free and must be done prior to the start of the class or certificate program.

Cancellations or rescheduling must be received in writing and full refunds will be given up to four business days prior to the start of class.

Any cancellation or reschedule submitted with three or less business days notice is subject to a $35 charge on 1 or 2 day classes and a $75 charge on certificate programs.  

No refunds after the first day of the class or certificate program.

Let’s explore the possibilities of having this program at your facility.  Paula.Seiwert@wichita.edu

Sign up for