In order to improve and optimise statistical production, ESS Member States are searching for ways to make optimal use of all available data sources, existing and new. This modernisation implicates not only an important organisational impact but also higher and stricter demands for the data and metadata management. Both activities are often decentralised and implemented in various ways, depending on the needs of specific statistical systems (stove-pipes), whereas realising maximum re-use of available statistical data just demands the opposite: a centralised and standardised set of (generic) systems with a flexible and transparent metadata catalogue that gives insight in and easy access to all available statistical data.
To reach these goals, building a Statistical Data Warehouse (S-DWH) is considered to be a crucial instrument.
The S-DWH approach enables NSIs to identify the particular phases and data elements in the various statistical production processes that need to be common and reusable.
The CoE on DWH provides 2 documents that help and guide in the process of designing and developing a S-DWH:
- The S-DWH Design Manual:
- The S-DWH Handbook (one of the deliverables of the ESSnet on DWH)
These documents answer the following questions:
- What is a Statistical Data Warehouse (S-DWH) ?
- How does a S-DWH differ from a traditional = 'commercial' DWH ?
- Why should we build a S-DWH ?
- Who are the envisaged users of a S-DWH ?
- Give a road map for designing, building and implementing the S-DWH:
- What are the prerequisites for implementing a S-DWH ?
- What are the phases/steps to take ?
- How to prepare for an implementation ?