Project 9

Property Analysis: Interactive Power BI & SSRS Integration || Power BI, SSRS, SSMS

🎯 Objective

To build an integrated analytical solution that empowers users to explore suburb-level insights across House Value, Rental Trends, School Quality, Transport Accessibility, and Crime Rates, while enabling seamless drill-through to SSRS paginated reports for detailed, printable analysis.

Dynamic Drill-Through from Power BI to SSRS Paginated Reports.

🧠 Project Overview

  • This project focused on designing and developing a comprehensive suburb insights dashboard in Power BI using a centralized Data Warehouse model. The solution not only presents interactive and intuitive data visualizations across multiple dimensions but also connects Power BI pages with corresponding SSRS paginated reports hosted on the SSRS Web Portal. This enables users to deep-dive into data for specific suburbs by simply clicking dynamic hyperlinks embedded within the Power BI interface.
  • The report pages (House Value, Rental Value, School, Transport, and Crime) feature dynamic links that pass state, city, and suburb parameters directly into SSRS reports, allowing users to view tailored, printable reports for informed decision-making.
  • Tools Used: Power BI Desktop | SQL Server Reporting Services (SSRS) | SSMS
  • Techniques: DAX, Star Schema / Dimensional Modeling, Parameterized URLs, SSRS Web Portal

🔧 What I Did

  • Designed a dimensional data model supporting suburb-based analytics.
  • Developed ETL pipelines using SSIS to extract, transform, and load data into SQL Server.
  • Created interactive dashboards in Power BI for House Value, Rental Value, School, Transport, and Crime.
  • Built SSRS paginated reports tailored to suburb-level details and deployed them to the SSRS Web Portal.
  • Integrated dynamic URL-based drill-through from Power BI to SSRS reports using DAX.
  • Used tables visuals to embed hyperlinks that passed state, city, and suburb as parameters to SSRS reports.
  • Ensured consistency and performance across both platforms by optimizing datasets and visuals.

📋 Tables Used

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

📦 Key Deliverables

  • Interactive suburb analytics dashboard in Power BI.
  • SSRS paginated reports with parameter-driven filtering.
  • Hyperlink integration for seamless navigation between Power BI and SSRS.
  • Complete end-to-end data flow from ETL to reporting.
  • Parameterized user experience tailored to suburb-specific data.


See Code here!