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.
Ce cours fait partie de la Spécialisation Advanced Business Analytics
Business Analytics for Decision Making
proposé par
À propos de ce cours
4.5
183 notes
Compétences que vous acquerrez
Data AnalysisSimulationBusiness AnalyticsMathematical Optimization
Programme du cours : ce que vous apprendrez dans ce cours
Semaine
1Data Exploration and Reduction — Cluster Analysis
7 vidéos (Total 53 min), 1 lecture, 2 quiz
7 vidéos
0. What is Cluster Analysis7 min
1. Data Reduction and Unsupervised Learning7 min
2. Preparing Data and Measuring Dissimilarities8 min
3. Hierarchical and k-Means Clustering7 min
4. Cluster Analysis with Excel8 min
5. Cluster Analysis with XLMiner9 min
1 lecture
Register for Analytic Solver Platform for Education (ASPE)10 min
2 exercices pour s'entraîner
Week 1 Quiz16 min
Week 1 Application Assignment - Clustering30 min
Semaine
2Dealing with Uncertainty and Analyzing Risk
7 vidéos (Total 52 min), 2 quiz
7 vidéos
1. Adding Uncertainty to a Spreadsheet Model9 min
2. Defining Output Variables and Analyzing the Results7 min
3. Using Historical Data to Model Uncertainty7 min
4. Models with Correlated Uncertain Variables5 min
5. Creating and Interpreting Charts8 min
6. Using Average Values versus Simulation5 min
2 exercices pour s'entraîner
Week 2 Quiz30 min
Week 2 Application Assignment - Monte Carlo Simulation30 min
Semaine
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 vidéos (Total 54 min), 2 quiz
7 vidéos
1. Formulating an Optimization Problem7 min
2. Developing a Spreadsheet Model7 min
3. Adding Optimization to a Spreadsheet Model5 min
4. What-if Analysis and the Sensitivity Report9 min
5. Evaluating Scenarios and Visualizing Results to Gain Practical Insights9 min
6. Digital Marketing Application of Optimization8 min
2 exercices pour s'entraîner
Week 3 Quiz24 min
Week 3 Application Assignment - Linear Optimization45 min
Semaine
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 vidéos (Total 39 min), 2 quiz
6 vidéos
1. Business Problems with Yes/No Decisions5 min
2. Formulation and Solution of Binary Optimization Problems7 min
3. Metaheuristic Optimization8 min
4. Chance Constraints and Value At Risk6 min
5. Simulation Optimization6 min
2 exercices pour s'entraîner
Week 4 Quiz30 min
Week 4 Application Assignment - Simulation Optimization45 min
4.5
41 avisMeilleurs avis
par 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.
par 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.
Enseignant
Manuel Laguna
ProfessorLeeds School of Business
À propos de Université du Colorado à 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.
À propos de la Spécialisation 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!
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2019 Coursera Inc. Tous droits réservés.
