Real Estate Analysis

A dashboard built with Power BI (with DAX) to visualize real estate property data.

Problem Statement

Need to understand the sales revenue across the portfolio of properties, condition under which the units were sold et cetera.

Power BI dashboard page 1

Data

Data obtained from Kaggle.

Approach

  • Measures were created with DAX.

Insights

  • Least sales on Fridays ($31mill +), most on Saturdays ($43mill +).
  • Over 40% of the sales occurred at weekends, with the most on Saturdays and the least on Fridays, likewise in number of sales and value respectively.
  • The highest sales value occurred in 2007 ($61mill+) and 2009 ($60mill+), while the lowest occurred in 2010 ($31mill +).