Ce cours fait partie de la Spécialisation Advanced Business Analytics

Manuel Laguna +2 enseignants de plus

Offert par

Spécialisation Advanced Business AnalyticsUniversité du Colorado à Boulder

À propos de ce cours

21,441 consultations récentes

The analytics process is a collection of interrelated activities that lead to better decisions and to a higher business performance. The capstone of this specialization is designed with the goal of allowing you to experience this process. The capstone project will take you from data to analysis and models, and ultimately to presentation of insights. 
In this capstone project, you will analyze the data on financial loans to help with the investment decisions of an investment company. You will go through all typical steps of a data analytics project, including data understanding and cleanup, data analysis, and presentation of analytical results. 
For the first week, the goal is to understand the data and prepare the data for analysis. As we discussed  in this specialization, data preprocessing and cleanup is often the first step in data analytics projects. Needless to say, this step is crucial for the success of this project.  

In the second week, you will perform some predictive analytics tasks, including classifying loans and predicting losses from defaulted loans. You will try a variety of tools and techniques  this week, as the predictive accuracy of different tools can vary quite a bit. It is rarely the case that the default model produced by ASP is the best model possible. Therefore, it is important for you to tune the different models in order to improve the performance.

Beginning in the third week, we turn our attention to prescriptive analytics, where you will provide some concrete suggestions on how to allocate investment funds using analytics tools, including clustering and simulation based optimization. You will see that allocating funds wisely is crucial for the financial return of the investment portfolio.

In the last week, you are expected to present your analytics results to your clients. Since you will obtain many results in your project, it is important for you to judiciously choose what to include in your presentation. You are also expected to follow the principles we covered in the courses in preparing your presentation.

Certificat partageable

Obtenez un Certificat lorsque vous terminez

100 % en ligne

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.

Cours 5 sur 5 dans le

Spécialisation Advanced Business Analytics

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.

Approx. 19 heures pour terminer

Anglais

Sous-titres : Anglais, Coréen

Enseignants

Certificat partageable

Obtenez un Certificat lorsque vous terminez

100 % en ligne

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.

Cours 5 sur 5 dans le

Spécialisation Advanced Business Analytics

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.

Approx. 19 heures pour terminer

Anglais

Sous-titres : Anglais, Coréen

Offert par

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.

Programme du cours : ce que vous apprendrez dans ce cours

Semaine

Semaine 1

4 heures pour terminer

Module 1 - Understand the data and prepare your data for analysis

This week your goal is to understand the data and prepare the data for analysis. As we discussed in this specialization, data preprocessing and cleanup is often the first step in data analytics projects. Needless to say, this step is crucial for the success of this project. We've selected a few videos from Courses 2 and 4 for you to review before completing this week's assignments. Dealing With Missing Values and Dealing with Outliers videos will remind you how to perform preliminary data cleanups. The last part of the assignments ask you to construct data visualizations. You may find the ideas discussed in What is Good Data Visualization? and Graphical Excellence useful.

4 heures pour terminer

5 vidéos (Total 25 min), 2 lectures, 1 quiz

5 vidéos

Data Cleanup and Transformation4 min

Dealing with Missing Values6 min

Dealing with Outliers3 min

What is Good Data Visualization4 min

Graphical Excellence4 min

2 lectures

Introduction to the Project30 min

Semaine

Semaine 2

5 heures pour terminer

Module 2 - Perform predictive analytics tasks

This week you will perform some predictive analytics tasks, including classifying loans and predicting losses from defaulted loans. You will try a variety of tools and techniques this week, as the predictive accuracy of different tools can vary quite a bit. It is rarely the case that the default model produced by ASP is the best model possible. Therefore, it is important for you to tune the different models in order to improve the performance.This week’s assignments require you to build predictive models for both classification and regression tasks. <p> Before working on the assignments, you may review a few videos to remind yourself several important concepts, such as cross validation. These concepts are discussed in the videos Cross Validation and Confusion Matrix and Assessing Predictive Accuracy Using Cross-Validation. You may also find a refresher on XLMiner useful. The videos Building Logistic Regression Models using XLMiner and How to Build a Model using XLMiner discuss how to build logistic regression and linear regression models. Depending on your needs, you may also go back to the videos that discuss how to build trees and neural networks. </p>

5 heures pour terminer

4 vidéos (Total 25 min)

4 vidéos

Cross Validation and Confusion Matrix5 min

Assessing Predictive Accuracy Using Cross-Validation5 min

Building Logistic Regression Models using XLMiner6 min

How to Build a Model using XLMiner8 min

Semaine

Semaine 3

5 heures pour terminer

Module 3 - Provide suggestions on how to allocate investment funds using prescriptive analytics tools

This week we turn our attention to prescriptive analytics, where you will provide some concrete suggestions on how to allocate investment funds using analytics tools, including clustering and simulation-based optimization. You will see that allocating funds wisely is crucial for the financial return of the investment portfolio.

5 heures pour terminer

Semaine

Semaine 4

5 heures pour terminer

Module 4 - Present your analytics results to your clients

You have done a lot so far! In this last week, you will present to your analytics results to your clients. Since you have many results in your project, it is important for you to judiciously choose what to include in your presentation. Several videos in Course 4 offer some guidelines on communicating analytics results. This assignment will give you an opportunity to apply the skills you learned there.

5 heures pour terminer

À propos du 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.

Foire Aux Questions

Quand aurai-je accès aux vidéos de cours et aux devoirs ?
L’accès à des vidéos de cours et des devoirs dépend de votre type d’inscription. Si vous suivez un cours en mode auditeur libre, vous pourrez voir la plupart des contenus de cours gratuitement. Pour accéder aux devoirs notés et obtenir un certificat, vous devrez acheter une expérience de certificat, pendant ou après avoir assister au cours en tant qu’auditeur libre. Si vous ne visualisez pas l’option auditeur libre :
Il est possible que le cours ne propose pas d’option auditeur libre. Vous pouvez en revanche accéder à un essai gratuit ou faire une demande d'aide financière.
Le cours propose peut-être « Cours complet, aucun certificat » à la place. Cette option vous permet de voir tous les contenus de cours, de soumettre les évaluations requises et d'obtenir une note finale. Cependant, vous ne pourrez pas acheter une expérience de certificat.
À 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.
Is financial aid available?
Oui, Coursera offre une Aide Financière aux étudiants qui n'ont pas les moyens d'acquitter les frais. Demandez-la en cliquant sur le lien Aide Financière sous le bouton S'inscrire situé à gauche. Vous devrez remplir un formulaire de demande et vous serez averti(e) si elle est acceptée. Vous devrez répéter cette procédure pour chaque cours de la Spécialisation, y compris pour le Projet Final. En savoir plus.

D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.

Advanced Business Analytics Capstone