When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 4 modules in this course
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.
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.
What's included
5 videos3 readings1 peer review
Show info about module content
5 videos•Total 25 minutes
Data Cleanup and Transformation•5 minutes
Dealing with Missing Values•7 minutes
Dealing with Outliers•4 minutes
What is Good Data Visualization•5 minutes
Graphical Excellence•5 minutes
3 readings•Total 41 minutes
Course Updates and Accessibility Support•1 minute
Introduction to the Project•30 minutes
Register for Analytic Solver Platform for Education (ASPE)•10 minutes
1 peer review•Total 180 minutes
Understand the data and prepare your data for analysis•180 minutes
Module 2 - Perform predictive analytics tasks
Module 2•5 hours to complete
Module details
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>
What's included
4 videos1 peer review
Show info about module content
4 videos•Total 25 minutes
Cross Validation and Confusion Matrix•5 minutes
Assessing Predictive Accuracy Using Cross-Validation•5 minutes
Building Logistic Regression Models using XLMiner•7 minutes
How to Build a Model using XLMiner•8 minutes
1 peer review•Total 300 minutes
Perform predictive analytics tasks•300 minutes
Module 3 - Provide suggestions on how to allocate investment funds using prescriptive analytics tools
Module 3•5 hours to complete
Module details
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.
<p>The relevant videos for this week are from Course 3: Week 1: Cluster analysis with XLMiner, Week 2: Adding uncertainty to spreadsheet model, Week 2: Defining output variables and analyzing results. </p>
What's included
1 peer review
Show info about module content
1 peer review•Total 300 minutes
Provide suggestions on how to allocate investment funds using prescriptive analytics tools•300 minutes
Module 4 - Present your analytics results to your clients
Module 4•5 hours to complete
Module details
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.
Good luck!
What's included
1 peer review
Show info about module content
1 peer review•Total 300 minutes
Present your analytics results to your clients•300 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
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.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.3
90 reviews
5 stars
68.47%
4 stars
15.21%
3 stars
6.52%
2 stars
1.08%
1 star
8.69%
Showing 3 of 90
D
DM
5·
Reviewed on Apr 30, 2024
The content of the overall specialisation was excellent. Difficult topic and learnt a lot. Frustration with the high number of empty or plagiarised assignment submissions that waste everyone's time.
R
RA
5·
Reviewed on Mar 3, 2019
Great List of Courses for People who are interested
L
LK
4·
Reviewed on Jun 26, 2020
in week 3 analysis it was not taught during the course
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.