Project 8

Property Analysis: Power BI Dashboard & Visualization || Power BI, DAX, Power Query

🎯 Objective

To develop an interactive Power BI dashboard that enables stakeholders to analyze and compare real estate and infrastructure metrics—such as house prices, rental values, school availability, transport accessibility, and crime incidents—across suburbs, cities, and states. The goal is to support data-driven decision-making for property investors, city planners, and home buyers.

Summary Dashboard – Property Analysis Dashboard Overview.

🧠 Project Overview

  • This project delivers a comprehensive multi-page Power BI dashboard using data imported from a structured data warehouse. Each page focuses on a specific domain—House Value, Rental, Schools, Transport, and Crime—with tailored visuals and KPIs. A centralized Summary page provides cross-domain insights with drill-through to detail pages, while an Overview (Home) page enables image-based navigation.
  • By integrating multiple datasets and dimension tables, this report provides an end-to-end real estate intelligence solution at suburb-level granularity.
  • Tools Used: Power BI Desktop | SQL Server | DAX (Data Analysis Expressions) | Power Query
  • Techniques: Dimensional Modeling, Drillthrough Navigation, KPI Cards, Hierarchical Filtering, Top N & Distribution Analysis, Bucketization, Highlighting Gaps, Custom Color Palette

🔧 What I Did

  • Imported and modeled data from SQL-based data warehouse.
  • Designed page-level analysis for each domain (House, Rental, Crime, School, Transport).
  • Created custom DAX measures for KPI cards.
  • Built dynamic visuals by suburb, city, and state.
  • Implemented category-based distribution charts and Top N comparisons.
  • Designed a Summary page for high-level insights with drill-through to detail pages.
  • Created a Home (Overview) page using visual tiles for intuitive navigation.
  • Applied a cohesive custom color theme to enhance user experience and brand consistency.

📋 Tables Used

DimSuburb, DimSchool, DimTransport, FactCrime, FactHouseValue, FactRentalValue, FactlessFact_School, FactlessFact_Transport

📦 Key Deliverables

  • Designed 5 dedicated analysis pages for House Value, Rental Value, Crime, Schools, and Transport
  • Implemented KPI cards showing Min, Max, Avg, and Count metrics for each domain.
  • Created interactive slicers for State, City, and Suburb filtering across all pages.
  • Developed Top 5 visualizations for suburbs by average value, crime incidents, school count, and transport stops.
  • Built distribution charts for House Value and Rental Amount categories.
  • Highlighted data gaps such as suburbs with no schools or transport stops.
  • Built a Summary page consolidating KPIs and key visuals across domains.
  • Enabled drill-through navigation from Summary to individual analysis pages using suburb.
  • Designed a Home (Overview) page with clickable image tiles for intuitive navigation.
  • Applied a custom color palette consistent with all visuals for a polished and cohesive dashboard.


See Code here!