Property Advance Data Engineering Sprint - Part 3
Interactive SSRS reports with parameters to explore house values, rentals, crime summaries, schools, and local transport by state, city, and suburb.
House Values Rendered Report
Project Overview
- Objective: Build dynamic, parameter-driven paginated reports in SSRS using SQL queries over the star schema.
- Tools Used: SQL Server Reporting Services (SSRS), SQL Server, T-SQL, Parameterized Reports, Matrix/Table Layouts
Reports Created
- House Value Report: Shows house prices by state, city, suburb with date and filtering parameters.
- Rental Value Report: Summarizes rent amounts by location and property type.
- Crime Report: Aggregates incidents by offence category and subcategory for each suburb.
- School Report: Lists school names, types, and locations by suburb and city.
- Transport Report: Displays nearby station names, transport modes, and geographic coordinates.
Features and Interactivity
- Reports built using Matrix and Table visuals for structured layouts.
- Included cascading parameters for state → city → suburb filtering.
- Used stored procedures and dynamic queries to fetch relevant records based on user input.
- Formatted headers with logos, report names, and standardized pagination footers.
- All reports are exportable to Excel or PDF for offline analysis.
Validation and Output Checks
- Each report tested with various state/city/suburb combinations to confirm correctness.
- Verified record count and values against SQL queries directly in SSMS.
- Ensured parameter selections auto-refreshed downstream filters correctly.
Key Skills Demonstrated
- Building paginated reports with multiple interlinked parameters.
- SQL querying over dimensional models to support filtering and aggregation.
- Using SSRS design features like report header/footer, export options, and matrix structures.