Skip to content

Instantly share code, notes, and snippets.

@rossbowen
rossbowen / data-model-for-cms.md
Last active June 9, 2022 15:17
Data model for CMS

Molly is an analyst at the Valuation Office Agency. Each year, she is responsible for producing "Private rental market statistics", a set of official statistics which summarise rents paid for private properties in England only.

Molly wants to create these statistics using our new CMS.

Each year, the statistics are made up of:

  • a statistical summary. Previously this took the form of a PDF, but Molly will now produce this in a WYSISYG editor within our CMS,
  • a single dataset. Previously Molly would publish these as 14 cross-tabs in an excel spreadsheet, but she has condensed these into a tidy dataset and has turned this into a cube using csvcubed.

In 2019, the current year, the statistical summary is named _"Private rental mar