USA Real Estate - Power BI

USA Real Estate

Goal: exploring this dataset to practice Power BI and learn more skills.

Date Created: Sep 6, 2023

Dataset source: Kaggle

Tools used: Power BI Transform, DAX

The dataset contains 415,919 rows (after cleaning) and 10 columns:

1. status --> for sale

2. bed --> number of bedrooms

3. bath --> number of bathrooms

4. acre_lot

5. City

6. State

7. zip_code

8. house_size --> in sq.ft

9. prev_sold_date

10. price

Some extreme outliers and errors were cleaned.

Let's dive into visualizations:

DAX custom measures:

1. Price per bedroom:

Price per bedroom = 
AVERAGEX(
    KEEPFILTERS(VALUES('realtor-data'[bed])),
    CALCULATE(SUM('realtor-data'[price])/SUM('realtor-data'[bed])
))

2. Price per 100 sqft:

price per 100 sqft = 
AVERAGEX(
    KEEPFILTERS(VALUES('realtor-data'[price])),
    CALCULATE(SUM('realtor-data'[price])/SUM('realtor-data'[house_size])*100)
)

3. Norm_dist (testing norm.dist function in DAX):

Norm_Dist = NORM.DIST([index],[Mean],[Standard Deviation],FALSE())

That's it!

Thanks for reading.