There are many publicly available datasets that we can download and extract information from, determine some trends, and so on. We will use the Housing Affordability Data System (HADS) dataset to get a sneak peek into the average housing conditions in 2011. The data contains details such as affordability, income, fair market rent, and so on, which will be particularly helpful to derive a few deep observations.
We can download the data from http://www.huduser.org/portal/datasets/hads/hads2011(ASCII).zip. There is only one file in the dataset, named thads2011.txt
. We will create a database in the SQL Server instance of the name HousingAffordabilityData
and import this file into the database with the table name thads2011
. We will have to import the file as a flat file source into the SQL table. The following screenshot shows a portion of the data in a few columns: