The Home Mortgage Disclosure
Completion Date:
Project Overview
Mortgage disclosure data is growing the data will tell you if the consumer got the mortgage—look for applications that were \"originated“—or if the consumer was denied, didn\'t complete the application, or something else happened.
The data also have information about pre-approvals and loans sold from one institution to another. For each record, you can learn about the loan, the property characteristics, the applicant demographics, and the lender. The data are modified to protect applicant and borrower privacy.
In this project, I will show you how to find and download this data online and the tools to convert data from CSV to JSON.
You will learn how to create a data model and data warehouse by turning an Excel sheet into 16-dimensional and two fact tables.
I will go through the ETL process is comprised of 3 steps that enable data integration from source to destination: data extraction, data transformation, and data loading by using SQL server and SSIS from Visual Studio.
Role:
Problem Statement
Homeownership in the U.S. has fallen sharply since the housing boom peaked in the mid-2000s, though it’s declined more for some racial and ethnic groups than for others. Black and Hispanic households today are still far less likely than white households to own their own homes (41.3% and 47%, respectively, versus 71.9% for whites), and the homeownership gap between blacks and whites has widened since 2004.
Executive Summary
Data Dictionary
