Dimensional modelling of the UK Land Registry property prices file into a SQL Server database.
Creation of an SSAS reporting cube (tabular) using the dimensional model as a data source.
The data is pulished by the UK ONS.
https://www.gov.uk/government/statistical-data-sets/price-paid-data-downloads
Column | Col Type | Info |
---|---|---|
Rowkey | GUID | source file guid |
Price | Whole Number | £ with no decimals |
Price Date | Date & Time | dd/mm/yyyy hh:mi:ss |
Postcode | String | Post Office Sorting Key |
Property Type | Code | D=detached, T=terraced, S=semi, F=flat |
New Build Flag | Yes/No Flag | Y=yes, N=no |
Land Ownership Type | Code | F=freehold, L=leasehold |
PAON | String | Primary Address Object |
SAON | String | Secondary Address Object (if a property is sub-divided, such as Flats) |
Street | String | Street Name |
Locality | String | Other Region Name |
Town | String | Postal Town |
District | String | Postal District |
County | String | Local Governing Region |
PPD Category | Code | Land Registry Data Category |
Record Type | Code | Land Registry Record Type. A=add, U=update, D=delete |