In this course you will learn how to create models for decision making. We will start with cluster analysis, a technique for data reduction that is very useful in market segmentation. You will then learn the basics of Monte Carlo simulation that will help you model the uncertainty that is prevalent in many business decisions. A key element of decision making is to identify the best course of action. Since businesses problems often have too many alternative solutions, you will learn how optimization can help you identify the best option. What is really exciting about this course is that you won’t need to know a computer language or advanced statistics to learn about these predictive and prescriptive analytic models. The Analytic Solver Platform and basic knowledge of Excel is all you’ll need. Learners participating in assignments will be able to get free access to the Analytic Solver Platform.
Este curso faz parte do Programa de cursos integrados Advanced Business Analytics
Business Analytics for Decision Making
oferecido por
Informações sobre o curso
4.5
175 classificações
Habilidades que você terá
Data AnalysisSimulationBusiness AnalyticsMathematical Optimization
Programa - O que você aprenderá com este curso
Semana
1Data Exploration and Reduction — Cluster Analysis
7 vídeos (total de (Total 53 mín.) min), 1 leitura, 2 testes
7 videos
0. What is Cluster Analysis7min
1. Data Reduction and Unsupervised Learning7min
2. Preparing Data and Measuring Dissimilarities8min
3. Hierarchical and k-Means Clustering7min
4. Cluster Analysis with Excel8min
5. Cluster Analysis with XLMiner9min
1 leituras
Register for Analytic Solver Platform for Education (ASPE)10min
2 exercícios práticos
Week 1 Quiz16min
Week 1 Application Assignment - Clustering30min
Semana
2Dealing with Uncertainty and Analyzing Risk
7 vídeos (total de (Total 52 mín.) min), 2 testes
7 videos
1. Adding Uncertainty to a Spreadsheet Model9min
2. Defining Output Variables and Analyzing the Results7min
3. Using Historical Data to Model Uncertainty7min
4. Models with Correlated Uncertain Variables5min
5. Creating and Interpreting Charts8min
6. Using Average Values versus Simulation5min
2 exercícios práticos
Week 2 Quiz30min
Week 2 Application Assignment - Monte Carlo Simulation30min
Semana
3Identifying the Best Options — Optimization
At the end of this module students should be able to: 1. Develop a spreadsheet model for an optimization problem 2. Use Excel to solve optimization models 3. Interpret solutions and conduct what-if analysis
7 vídeos (total de (Total 54 mín.) min), 2 testes
7 videos
1. Formulating an Optimization Problem7min
2. Developing a Spreadsheet Model7min
3. Adding Optimization to a Spreadsheet Model5min
4. What-if Analysis and the Sensitivity Report9min
5. Evaluating Scenarios and Visualizing Results to Gain Practical Insights9min
6. Digital Marketing Application of Optimization8min
2 exercícios práticos
Week 3 Quiz24min
Week 3 Application Assignment - Linear Optimization45min
Semana
4Decision Analytics
At the end of this module students should be able to: 1. Given a business situation, apply an appropriate technique to identify the best solution alternatives 2. Formulate and solve models for business problems that requires yes/no decisions and logical constraints 3. Create models that mix techniques and tools such as simulation and optimizationAnalyze and interpret results to make informed decisions
6 vídeos (total de (Total 39 mín.) min), 2 testes
6 videos
1. Business Problems with Yes/No Decisions5min
2. Formulation and Solution of Binary Optimization Problems7min
3. Metaheuristic Optimization8min
4. Chance Constraints and Value At Risk6min
5. Simulation Optimization6min
2 exercícios práticos
Week 4 Quiz30min
Week 4 Application Assignment - Simulation Optimization45min
Melhores avaliações
por NH•Jul 12th 2017
The instructor is great. However, I would like to know the solutions for the exam. I sometimes pass the exam but struggle with certain questions but had no clue how to resolve it.
por DA•Mar 9th 2018
Very interesting subject with a good instructor. I'd like to be able to cover the content in more detail, but it was a good introduction to optimization theory.
Instrutores
Manuel Laguna
ProfessorLeeds School of Business
Sobre Universidade do Colorado em Boulder
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Sobre o Programa de cursos integrados Advanced Business Analytics
The Advanced Business Analytics Specialization brings together academic professionals and experienced practitioners to share real world data analytics skills you can use to grow your business, increase profits, and create maximum value for your shareholders. Learners gain practical skills in extracting and manipulating data using SQL code, executing statistical methods for descriptive, predictive, and prescriptive analysis, and effectively interpreting and presenting analytic results.
The problems faced by decision makers in today’s competitive business environment are complex. Achieve a clear competitive advantage by using data to explain the performance of a business, evaluate different courses of action, and employ a structured approach to business problem-solving.
Check out a one-minute video about this specialization to learn more!
Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.
O que recebo ao me inscrever nesta Especialização?
Quando você se inscreve no curso, tem acesso a todos os cursos na Especialização e pode obter um certificado quando concluir o trabalho. Seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.
Qual é a política de reembolso?
Existe algum auxílio financeiro disponível?
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.
O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.
© 2019 Coursera Inc. Todos os direitos reservados.
