Date - a distinct list of quarter end dates used for the median sale price data.

Median Sales Price Residential Property - this table contains all the median sale price data for each quarter in the period and for each Area Region.

Area Region - which is a list of geographic regions at various levels within NSW.CMBI have manipulated this raw data using Power Query to create the final tables seen in the model. The model uses data from the NSW FCS Government Department website. If you have any feedback about the model or notice any errors or points for improvement please contact Power Pivot model data The workbook is unprotected and you are free to add your own visualisations and calculations to the model. Technical details about the sample Power Pivot model NSW Property Growth statistics using DAX Time Intelligence functions Slicers linked to the Pivot Table which act as parameters for viewing different data cuts.DAX time intelligence and advanced DAX calculations using CALCULATE statement for measures and calculated columns.Conditional formatting linked to Pivot Table measure in Power Pivot model.Excel Pivot Table linked to Power Pivot model.

The Overview sheet uses the following features The data is grouped by Local Government Area (LGA) and can be filtered by Rings which are defined by their proximity to the CBD. The Overview sheet allows you to analyse sales property growth for houses, units, or all property in NSW for any period between 1991 and Q1 2015. The workbook contains a number of worksheets which are briefly described below. The NSW Residential Sales Property Growth Power Pivot model demonstrates some key features of Power Pivot modelling, DAX calculations, and Excel visualisation using data that is engaging yet relatively straightforward to understand. Introduction to NSW Residental Sales Property Growth Power Pivot Model NSW Residential Sales Property Growth Power Pivot model for Excel 2016Īlso interested in Power Query for Excel?ĬMBI have also developed a World Cup 2018 Power Query sample which includes an Excel file to download, notes, and instructional video. The model also features Sydney sales price data up to Q1 2018. NSW Residential Sales Property Growth Power Pivot model for Excel 2016 uses advanced Power Query features.

Click here to download NSW Residential Sales Property Growth Power Pivot model for Excel 2013.

Click here to download NSW Residential Sales Property Growth Power Pivot model for Excel 2010.For your convenience you can download a pre-converted Excel 2013 model too. CMBI have developed this NSW Residential Sales Property Growth Power Pivot model using Excel 2010 with the Power Pivot 2012 SP1 Add In which is FREE from Microsoft.

Power pivot excel 2010