Graduate Business Analytics Certificate Program

  • Program & Professors

    Leverage the terabytes of data that bombard your organization to drive efficiency, maximize your tech-nology investment and strengthen your customer relationships. In a knowledge-intensive economy, success depends on your company’s ability to exploit its available knowledge resources and you can gain those skills with this program.

  • Descriptive Statistics

    This session provides an introduction to the statistical methods used in decision modeling, including: (1) review of the mean, median, mode, standard deviation, normal curve, graphs and charts; (2) sampling - why sample, uses of sampling, comparison of sample survey methods on 10 dimensions, sample design and choosing random samples; (3) making estimates from samples - central limit theorem, confidence intervals for means and proportions; and (4) computing sample size for estimating means and proportions.

  • Regression Models

    Once we are familiar with the basic concepts of descriptive statistics we can take on more complex tasks. In this session students investigate how to implement these concepts in Excel and how to use statistics to generate conclusions. The first topic covered here is hypothesis tests; the primary decision-making tool in statistics. We begin by applying hypothesis tests to one-variable problems. More realistic models require multiple variables. In working with multiple variables we build regression models. The objective is to develop a model where the dependent variable is explained by one or more independent variables. This allows identification of the factors that determine the outcome of the dependent variable. Students will become familiar with implementing regression in Excel and interpreting the Excel output.

  • Business Forecasting

    Forecasting is an essential step in almost making any business plan. For example, without good sales forecasts, inventory management and capacity planning can go badly wrong. And almost any reliable budget depends on a reliable forecast of the variables influencing cost. As a consequence, analysts have developed a number of different forecasting techniques. This session explores several different methods most commonly used to forecast. A special emphasis is placed on how to integrate forecasting into the business planning process. Exercises will be presented using both excel and specialized forecasting software.

  • Linear Programming and Optimization

    Linear programming (LP) is a tool for the mathematical optimization of complex decision problems.This session begins with a fun, hands-on, interactive problem-solving exercise drawn from production planning. This example is used to introduce the basic concepts behind LP as a mathematical model of the exercise is developed and then solved using the Solver in Microsoft Excel. The session concludes with students building small models in Excel using examples drawn from distribution planning and financial management.

  • Decision Analysis and Decision Trees

    In this class meeting, the focus is on decision-making under uncertainty. For a large class of decision problems, the outcome of a decision is uncertain, but the decision-maker is able to list the possible outcomes of a decision and assign a probability to each of them. Sources of uncertainty include such factors as consumer demand, competitors' behavior, and acts of nature. To address these uncertainties in a decision-making context, decision trees have proved to be a powerful graphical tool. Decision trees allow a decision-maker to consider the possible outcomes of his decisions in a systematic way and to draw correct conclusions with respect to the best course of action. Spreadsheet implementation of decision trees further extend to the decision-maker the ability to perform sensitivity analysis to gain a deeper understanding of how sensitive the optimal solution is to changes or inaccuracies in model assumptions.

  • Project Planning Management

    Whatever industry you and your team are focused on - be it manufacturing, financial services, life sciences or electronics - projects are key vehicles for innovation, productivity improvement, and growth. The ability to manage the crisp and consistent execution of projects is becoming a crucial capability for the success of most ventures. In fact, as a firms offerings become more digitally driven and/or service-oriented, the manufacturing and assembly component of work declines, and project planning and execution play a vital role. This session discusses the essentials of project management, covering broadly the technical and social aspects of project execution.

  • Simulation Models

    Some real world problems cannot be modeled using pure optimization techniques, particularly those that involve an element of chance. In these situations we often resort to simulation, a methodology that combines decisions (e.g., how many service representatives to hire) and uncertainties (e.g., the demand for service). Simulation involves building a computer model that generates probabilistic outcomes based on the decisions we make and the uncertainties we face. One can use simulation models to determine how specific decisions will perform in practice without experiencing their effects firsthand. In this lecture, we will demonstrate how many complicated problems can be analyzed using simulation models built in spreadsheets.

  • Revenue Management

    This lecture is designed to introduce you to some of the models and methods used in the emerging field of revenue management (RM). The problem that motivates RM is ancient: how does a company manage its capacity and/or prices to extract the greatest possible revenue from the marketplace? The RM approach is to exploit differences in customer segments and their willingness to pay. For example, a person who books a room in an upscale hotel three days in advance is typically willing to pay much more than someone booking the same room three months in advance. RM focuses on how to manage these different types of customer demands to maximize revenues.

  • Working with Databases

    This session will discuss overviews of Database Management Systems, including Relational and On-Line Analytical Processing Systems. A real world example will show managing data for a web site; from online ordering to Pick and Pack. The class will also look at basic Structured Query Language (SQL) statements. The class lab will take a series of flat files and turn them into a database.

    Almost every company spends time retrieving data and placing it into spreadsheets.This can be a huge waste of time and often a robotic process.The module will discuss ways to automate this process with Visual Basic for Applications (VBA).A real world corporate example will show how one company retrieves data to help facilitate the management of data from four different reporting methods. The lab will contain a coding exercise to import data in to a spreadsheet.

  • Exploratory Analysis

    On-Line Analytical Processing (OLAP) and Data Warehousing are decision support technologies.Their goal is to enable enterprises to gain competitive advantage by exploiting the ever-growing amount of data that is collected and stored in corporate databases and files for better and faster decision-making. Over the past few years, these technologies have experienced explosive growth, both in the number of products and services offered, and in the extent of coverage in the trade press.Vendors, including all database companies, are increasing the attention paid to all aspects of decision support.

    This session provides a roadmap of data warehousing and OLAP technologies, with an emphasis on their new requirements.We describe back end tools for extracting, cleaning and loading data into a data warehouse; multi-dimensional data models and OLAP operation; front end client tools for querying and data analysis; server extensions for efficient query processing; and tools for metadata management and for managing the warehouse. We survey the state of the art and mention representative products.

  • Balanced Scorecard & Tying Metrics to Strategy

    The Balanced Scorecard (BSC) is a performance measurement system that helps management gain a fast yet comprehensive view of the organization, as well as translate organizational strategy into every-day operations. Its name signals its objective to balance each of the following:

    • Financial measures (e.g., ROI) and non-financial measures (e.g., customer satisfaction)
    • The organization's vision (strategy) and actions taken by individual employees as part of everyday work (operations)
    • The needs of external stakeholders (e.g., customers) and internal stakeholder (e.g., employees)
    • Past performance (outcome measures) and future performance (performance measures)

    This class session will include an introduction to the Balanced Scorecard, specifically its strategy map, as well as illustrations of how it has been used in organizations. Using a case study, students will then outline a strategy map and using data visualization software, develop a dashboard that captures the key performance indicators outlined in the BSC exercise.

  • Web and Social Media Analytics

    This class is divided into two sections. To give students an introduction to web analytics, the first half of the class explores how quantitative Internet data to optimize websites and web marketing initiatives is collected, analyzed and reported. These topics are explored through Google Analytics. Particular attention will be paid to the meaning of key metrics included in the Google Analytics suite based on an understanding of how the data from which they were derived.

    In preparation for this session, it is highly recommended that students unfamiliar with how the Internet works watch the 15-minute movie on

    The second half of the class introduces students to the challenges and opportunities of social media.Key difference between web and social media analytics will be drawn. Using NodeXL, students will then analyze the structure of a Twitter and/or Facebook Fan Page network and develop strategies for activating actors in this network to achieve desired outcomes.

  • Introduction to Data Mining

    In this first of three sessions on data mining, we examine the key ideas underlying data mining and machine learning, the types of problems where these methods can be applied, the process of exploratory data analysis, and the process of preparing data for building data mining models. The session also introduces specific data mining software for building predictive models without writing any code.

  • Classification and Prediction Mining

    This session covers two types of data mining techniques based on AI and machine Learning, that are useful for predictive modeling. These are CART (Classification and Regression Trees), and Neural Networks. The goal of the session is to not only understand how to build such models, but also gain an appreciation for the particular circumstances in which each modeling technique is appropriate.

  • Clustering and Association Rule Mining

    In this session, we focus on two additional methods for data mining. First, we examine Clustering, which is a data mining method for discovering distinct segments within a broad data set. We also discuss how clustering can be a useful step in developing multiple target marketing or segmented modeling strategies. The second half of the session examines Market Basket Analysis using Association Rules. This is a useful method for mining large transaction databases to discover affinity patterns. e.g., collections of products that are bought together, or by the same buyers over time.