ESSnet Workshop session 5 The ESS VIP Data

ESSnet Workshop – session 5 The ESS VIP "Data Warehouses" August Götzfried Head of Unit B 5 November 2012 Slide 1 Eurostat

Scope and objectives Overall scope and objectives: • Analysis, design and implementation of ESS data warehouses to support the business requirements of the ESS VIPs (in particular on transport and price statistics) and redesigned ESS business processes in general; • The cross-cutting project covers ESS data warehouses for production and reference/dissemination; • It follows the service-oriented architecture of the ESS VIPs which will lead to more business process integration in the ESS; Slide 2

Relation with ESS VIP projects The cross-cutting ESS VIP "data warehouses" is closely related to the ESS VIP "Data warehouses in price and transport statistics". There will be a mutual impact between the crosscutting project and the specific business cases in those two statistical domains. I. e. : the data warehouse work done in both statistical domains will provide an input to the general business case of the cross-cutting project "Data warehouses" and its implementation. The outcome of the ESS data warehouses project should also be usable also for those two domains. Slide 3

Link with previous projects Input from previous projects: • From the VIP "Enhanced Dissemination Chain" (dealing with improvements of the current Eurostat dissemination, also with some impact on Member states); • In Transport statistics: experiences made with using data sources from other organisations and generation of modal split indicators; • Input from ESSnets such as the ESSnet on data warehouses (see the subsequent presentation). The ESS VIP "Data warehouses" is a cross-cutting VIP using ESS technical, statistical and IT standards. This VIP is related to all specific VIPs (such as SIMSTAT, NAPS, etc. ). Slide 4

ESS VIPs versus ESS Cross cutting projects ESS VIP vs Cross cuttings Informati on models Network Data Warehou se Shared services SIMSTAT EGR/EBR ICT PRIX / TRANS NAPS ADMIN Validatio n Contribute & Use Slide 5 use Contribute Validatio n

The "To-be-state" of the ESS Users Other Partners European Statistics - Dissemination - Storage Production Disseminati on Infrastructu re … NS I European Statistical System NSI EST AT European System of Central Banks NC EC B B Common Standards & Models … Other Statistical Actors ST ST AT AT ESS Secure Bus Primary Collection Slide 6 IMF European Statistics – Production Processes Shared Services - OEC D Administrative Sources - Surveys – Official Sources – Private Sources

What parts of the ESS "To-be-state" are concerned by the ESS VIP Data Warehouses? The following parts are concerned: • • European Statistics – dissemination European statistics – production processes Shared services Common ESS standards & models Primary data collection is not in the focus of this cross-cutting ESS VIP. Slide 7

Current ESS data/metadata exchange processes Slide 8

Model for the future ESS data/metadata exchange processes Slide 9

Production data versus reference data Production data Reference data Accessible to public No Yes Accessible within ESS authorities Yes Sharing at collection/production level Yes Sharing at reference/ No Yes (in the sense that the production of statistics needs to make use of reference data) Yes No dissemination level Include confidential data Slide 10

Expected benefits for Member states • Improvement of the quality of European statistics through more integrated statistical business processes; • Broader use of statistical and technical ESS standards in more integrated ESS data warehouses; • More cross-domain statistical production and dissemination; • Improvement of national/international data/metadata exchange processes; • More integrated dissemination of European statistics; Over time: reduction of production and dissemination costs for European statistics. Slide 11

Next steps As requested by the ESSC meeting in 11/2012, the business case for the ESS cross-cutting project "Data Warehouses" needs to be further elaborated. This needs to be done in taking into consideration the input from related ESSnets, the work done in transport and price statistics and in other related projects. This more elaborated business case will then be forwarded to the appropriate decision making body. Slide 12