Case Study: Mortgage Trading Analysis in Power BI
In this Power BI case study you’ll play the role of a junior trader, analyzing mortgage trading and enhancing your data modeling and financial analysis skills.
Start Course for Free3 Hours5 Videos23 Exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
Course Description
Explore the Financial System with Power BI
In this Power BI case study, you will play the part of a newly hired junior trader on a trading desk for a mortgage originator. Enjoy this fast-paced and challenging case study as you learn the ins and outs of the financial system.Play the Role of a Junior Trader
The flow of money through our economy happens on your desk as it trickles down from big investment banks to your lending firm to individual borrowers – and you’re the one making it happen.Use Your Power BI Skills to Gain Insights
You will identify a population of mortgages to trade, evaluate each mortgage and each bid received from prospective buyers, and finally execute a trade. By the end of this case study, you will have sharpened your data modeling, DAX, and financial analysis skills, and you will have experienced a unique perspective on the banking industry.For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Financial Reporting in Power BI
Go To Track- 1
Mortgage data
FreeIn this chapter, you will focus on getting our data ready for trading. You’ll clean up mortgage data, create loan statuses, and amortize loan balances.
- 2
Trade on
Bids are in on the loans, so now it's time for you to analyze the bids and determine the winners.
- 3
Trade Profit Analysis
Now that you've struck our trades, it's time to analyze the outcomes and Sooper Mortgage's business strategy.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Financial Reporting in Power BI
Go To TrackCollaborators
Nick Edwards
See More
Analyst for Mynd
Nick Edwards is an Analyst for Mynd, a fast-growing PropTech startup, where he uses data and BI tools to unlock the full strength of financial analysis. He graduated with honors in Economics and Business Analytics at the University of Colorado Boulder. He realized honing data science skills would greatly benefit his career and believes it will for you, too!
What do other learners have to say?
Join over 13 million learners and start Case Study: Mortgage Trading Analysis in Power BI today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.