- Level Foundation
- Duration 20 hours
- Course by University of Colorado Boulder
-
Offered by
About
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.Modules
Videos
5
Videos
- Data Cleanup and Transformation
- Dealing with Missing Values
- Dealing with Outliers
- What is Good Data Visualization
- Graphical Excellence
Introduction to the Project and Peer Graded Assignment
1
Peer Review
- Understand the data and prepare your data for analysis
2
Readings
- Introduction to the Project
- Register for Analytic Solver Platform for Education (ASPE)
Videos
4
Videos
- Cross Validation and Confusion Matrix
- Assessing Predictive Accuracy Using Cross-Validation
- Building Logistic Regression Models using XLMiner
- How to Build a Model using XLMiner
Peer Graded Assignment
1
Peer Review
- Perform predictive analytics tasks
Peer Graded Assignment
1
Peer Review
- Provide suggestions on how to allocate investment funds using prescriptive analytics tools
Peer Graded Assignment
1
Peer Review
- Present your analytics results to your clients

Instructors
Manuel Laguna

Instructors
Dan Zhang

Instructors
David Torgerson