Data Analysis for Operations Management

Learn to model and analyze models that support management decision-making in difficult and complex operations contexts

Data Analysis for Operations Management
Course Format Icon

Modalidade Presencial

Course Format Icon

Presencial

Icone Relógio Carga horária: 16 horas

This course provides insight into problem modeling as the art of structuring and analyzing a decision problem within the given constraints and drawing recommendations that may lead organizations to action – with a particular focus on Operations Management. A strong emphasis will be put on problem modeling and analysis. To do so, this course will unlock the potential of using spreadsheet modeling to assist decision-making – from descriptive to predictive and prescriptive models. Spreadsheet engineering will give special attention to structure and in-depth and error-free development.

As a model builder or a coach for others who built models, it is essential to have practical experience in the art of modeling. Well-constructed models give a deep insight into the impact of the critical factors of the problem and will enable us to focus on the most important risks and tradeoffs.

The aim of this course is to provide students with the skills, methodologies, and tools to successfully model and analyze models that support management decision-making in difficult and complex operations contexts, such as ill-structured problems or problems involving lack of information and uncertainty.

This course is part of the MBA International Week, which is a short-term program designed to provide students with a unique opportunity to expand their knowledge and skills in various topics of the business world in classes with international and Insper professors.

Investimento

Valor integral R$ 4.889,00

Valor para matrícula antecipada (10% de desconto até 25 dias antes do início do curso)R$ 4.400,10

Valor para Alumni Insper (25% de desconto)R$ 3.666,75

Formas de pagamento

  • À vista no boleto ou cartão de crédito
  • Ou parcele em até 10X sem juros no cartão de crédito

Por que fazer o curso?

Planejamento e Produtividade em Vendas B2B (3)

Describe the problem-solving process and the role of models and modeling in that process;

Private Equity & Venture Capital (4)

Recall and explain important guidelines for designing, building, and testing spreadsheets;

Private Equity & Venture Capital (2)

Describe tools and techniques for sensitivity and data regression, their underlying concepts, assumptions, capabilities, and limitations;

Sustentabilidade e Negócios (3)

Discuss possibilities of articulating these tools and techniques in integrated approaches to problem-solving;

Investimentos no Mercado Imobiliário (1)

Recognize critical factors in a problem;

Negociação Razão e Emoção (1)

Develop a structure for analyzing problems;

Gestão do Capital de Giro (1)

Carry out a cogent analysis;

Negociação Estratégica e Gestão de Conflitos (3)

Present the analysis and insights on a problem to interested parties in a convincing, non-technical manner;

Negociação Razão e Emoção (2)

Design, build, test, and use meaningful spreadsheets to present and solve quantitative operations problems;

Reestruturação de Empresas (1)

Carry out sensitivity and data regression;

Investimentos no Mercado Imobiliário (2)

Translate descriptions of business situations in operations into formal models and investigate those models in an organized fashion;

Negociação Estratégica e Gestão de Conflitos (2)

Apply generic modeling heuristics to help in the design and use of models;

Tributações de Fusões e Aquisições (2)

Extract insights from models and use those insights to communicate, persuade, and motivate change;

Gestão Financeira Empresarial (2)

Interact with members in a group to produce analysis for external parties with time constraints.

O que você precisa saber

Perfil

The program is aimed at senior professionals, executives, entrepreneurs, consultants, and decision-makers with over 5 years of professional experience, experience in management, and varied backgrounds in different areas and sectors of the economy, who are interested in problem modeling and analysis focused on Operations Management.

Pré-requisitos

Completed higher education degree. Classes will be conducted in English without simultaneous translation. Although no proficiency test is required, we recommend B2 level to fully engage with the program.

O que você vai aprender

Modelling Practice

Spreadsheet engineering: designing a worksheet

  • Designing, building, and testing a workbook.

Analysis using spreadsheets

  • Base-case analysis;
  • What-if analysis;
  • Breakeven analysis;
  • Optimization analysis;
  • Simulation and risk analysis.

Regression analysis

  • Scatter plots and correlation;
  • Simple linear regression;
  • Goodness-of-fit;
  • Simple nonlinear regression;
  • Multiple linear regression;
  • Regression assumptions.

Optimization

  • Decision variables, objectives, and constraints;
  • Formulating and solving an optimization problem with a spreadsheet.

Course evaluation:

DA Evaluation

Corpo Docente

A maioria dos nossos professores é de mestres e doutores oriundos de renomadas escolas nacionais e internacionais e/ou executivos com extensa experiência profissional e prática.

Prof. Luis Guimarães

Luis Guimarães

Luis Guimarães is a Professor at the Department of Industrial Engineering and Management of the Faculty of Engineering of the University of Porto, an invited professor at the Porto Business School, senior researcher at the Industrial Engineering and Management group of the research institute INESC TEC and co-founder of LTPlabs, advanced analytics consulting firm. He holds an MSc and Ph.D. in Industrial Engineering and Management from the University of Porto, Portugal. His main area of activity is Operations Research/Computer Science. Most of his research is problem-driven and aims to develop advanced analytic solutions for real-world problems. In this context, he has collaborated in over +100 industry-based research and consulting projects with various companies in the process industry, transportation, retail, and energy. He is also leading work streams on several national and European funded projects. Author of several publications in international journals in the field of Operations Research.

Prof. Luis Guimarães

Luis Guimarães

Luis Guimarães is a Professor at the Department of Industrial Engineering and Management of the Faculty of Engineering of the University of Porto, an invited professor at the Porto Business School, senior researcher at the Industrial Engineering and Management group of the research institute INESC TEC and co-founder of LTPlabs, advanced analytics consulting firm. He holds an MSc and Ph.D. in Industrial Engineering and Management from the University of Porto, Portugal. His main area of activity is Operations Research/Computer Science. Most of his research is problem-driven and aims to develop advanced analytic solutions for real-world problems. In this context, he has collaborated in over +100 industry-based research and consulting projects with various companies in the process industry, transportation, retail, and energy. He is also leading work streams on several national and European funded projects. Author of several publications in international journals in the field of Operations Research.

X

Processo Seletivo

Conheça as etapas para ingressar no curso:

01.

Preencha o formulário de inscrição

02.

Análise do seu perfil

03.

Aprovação

04.

Matrícula Digital

Programas específicos da área de Internacional, passam pela etapa da entrevista anterior a aprovação.