Categories: Power BI
Tags:

This Power BI dashboard titled “Global Housing Market Analysis (2015-2024)” presents key housing market indicators across different countries and years. Below is a breakdown of its components:

Dataset is given here : https://www.kaggle.com/datasets/atharvasoundankar/global-housing-market-analysis-2015-2024

1. Filters (Dropdowns)

  • Country: Allows users to filter the analysis by selecting a specific country.
  • Year: Enables filtering by a specific year to analyze trends over time.

2. Key Metrics (KPIs)

The top section displays important summary statistics:

  • $130.38 – Average House Price Index
  • $83.05 – Average Rent Index
  • 3.65% – Average Inflation Rate
  • 2.13% – Average GDP Growth Rate
  • 7.24 – Average Affordability Ratio 💰
  • 4.15% – Average Mortgage Rate
  • 0.72% – Average Population Growth Rate
  • 74.77% – Average Urbanization Rate

These values provide an overall view of the housing market conditions.

3. Trend of House Price & Rent Index (Line Chart)

  • Displays the year-over-year trend for house price index and rent index from 2015 to 2024.
  • Helps in visualizing market fluctuations and long-term trends.

4. Average House Price Index, Rent Index, and Inflation Rate by Country (Bar Chart)

  • Compares house price index, rent index, and inflation rate across multiple countries.
  • Highlights regional variations in property prices and rental costs.

5. Average House Price Index by Country and Year (Bubble Chart)

  • Each bubble represents a country, with colors denoting different years.
  • Larger bubbles likely indicate higher values of the house price index.
  • Useful for identifying country-wise trends over multiple years.

6. Average Affordability Ratio, Construction Index, and Mortgage Rate by Year (Bar Chart)

  • Displays the affordability ratio, construction index, and mortgage rate trends from 2015-2024.
  • Helps understand how housing affordability has changed over time.

7. Footer

  • “Learn Power BI @ Slidescope.com” indicates that this dashboard is an educational resource.

Insights from the Dashboard

  • House and rent prices have been gradually increasing.
  • Inflation and mortgage rates show fluctuations, affecting affordability.
  • The affordability ratio gives insights into whether housing is becoming more or less accessible.
  • Country-wise comparisons reveal significant variations in housing market conditions.

This dashboard is designed to provide a quick and interactive way to analyze global housing trends.