The Challenge

• Data Fragmentation: Real estate stakeholders were forced to rely on static, fragmented listings and inconsistent spreadsheets to gauge market health.

• Hidden Value Drivers: It was difficult to quantify how much specific features—like "Construction Grade" versus "Maintenance Condition"—actually contributed to the final sale price.

• Market Volatility: Decision-makers lacked a real-time way to identify seasonal price troughs or neighborhood-specific benchmarks in the competitive Seattle market.

The Solution

I developed a comprehensive Market Intelligence Dashboard in Tableau that transformed over 21,000 raw sales records into a strategic decision-making engine. The solution provided:

• Market Executive Snapshot: Real-time visibility into daily sales volume, price distributions, and inventory trends.

• Geospatial Benchmarking: An interactive map using LOD Expressions to compare individual property prices against hyper-local zip code averages.

• Feature Impact Analysis: A deep-dive matrix identifying the "View Premium" and the correlation between property grade and ROI.

• Seasonal Trend Forecasting: Time-series visualizations that isolated the most cost-effective months for market entry.

The Outcome

• Time-to-Insight Accelerated: Replaced hours of manual listing comparisons with a 5-second drill-down into neighborhood-specific data.

• Strategic Findings Identified: Quantified a 32% price premium for waterfront views and identified a 12% price dip in late Q4, providing a clear roadmap for budget-conscious buyers.

• Data Integrity Improved: Identified and scrubbed significant outliers (including a 33-bedroom data entry error) that previously skewed regional averages.

• Investment Confidence: Provided stakeholders with a clear, visual justification for "buy" or "sell" recommendations based on price-per-square-foot benchmarks.

Skills Demonstrated

• Business Intelligence & Dashboard Design: (Tableau Desktop, Parameter Actions, UI/UX design).

• Advanced Data Modeling: (LOD Expressions, Outlier Detection, Feature Engineering).

• Market Analysis & KPI Development: (Price per SqFt, Year-over-Year growth, ROI drivers).

• Stakeholder-Focused Storytelling: (Translating complex spatial data into actionable investment advice).