This project demonstrates the use of Tableau as a dashboarding tool to uncover trends, patterns, and insights into real estate sales dynamics. Using a synthesized dataset modeled on real-world scenarios, the project explores key aspects of the housing market, including sales activity, market performance, and investment opportunities.
Breakthrough Insight:
The analysis identifies significant market trends, including conditions leading up to the 2007 housing market crisis—commonly referred to as "The Big Short." By visualizing metrics like housing sales, shares (e.g., BBB and AAA ratings), and profits, the project provides actionable insights for understanding past crises and predicting future opportunities.
Purpose:
This dashboard was designed to assist real estate stakeholders—including buyers, sellers, and investors—in understanding market trends and dynamics. It provides actionable insights to help maximize profits, avoid potential risks, and identify future investment opportunities.
- Use Tableau to create a dynamic, interactive dashboard for real estate market analysis.
- Assess market dynamics and variations in sales volume across different regions.
- Identify high-performing cities and seasonal trends in sales.
- Visualize relationships between active listings, housing shares, and market demand/surplus.
The dataset used for this project was synthesized to reflect real-world housing market conditions. While the dataset itself is not included in this repository, the analysis focused on key metrics such as:
- Number of listings sold city-wise.
- Sales volume and median sales price.
- Active listings.
This dataset was modeled to simulate market trends leading to and following the 2007 housing market crisis. The insights and visualizations in this repository are based on this dataset.
- High-Performing Cities:
Identified key cities driving sales growth and potential investment opportunities. - Market Trends on Monthly Basis:
Seasonal patterns and peak months shaping market dynamics. - Active Listings over Time:
The analysis modeled conditions leading to the 2007 housing market crash, providing a framework for identifying future downturns. - Investment Insights for Stakeholders:
Predicted positive opportunities based on recovery trends and market dynamics.
- Features:
- Interactive filters for city, year, and month.
- Dual-axis charts to visualize relationships between sales and inventory.
- Heatmaps to highlight high-performing cities and trends over time.
Realestatedynamics.twbx: Tableau workbook containing the analysis.Real estate dynamics - Dashboard.png: Exported visual representation of the dashboard.
README.md: This file.
The dataset used in this project was synthetically generated but reflects real-world scenarios and market trends. The focus is on demonstrating dashboarding, visualization and storytelling techniques.
- Housing Market Crisis:
- Investopedia: "The Big Short" Explained.
- Visualization Techniques:
- Analytics Vidhya: Dual Axis Chart in Tableau.