enEnglish
CROS

Data warehouse (SGA1)

Coordinator: Harry Goossens
Organisation:
CBS - Statistics Netherlands
Phone number:
+31(0) 6 5235 3826

The overall objective of this ESSnet is to provide assistance in the development of more integrated databases and data production systems for business statistics in Member States. Therefore the ESSnet has to work on issues that are common for the majority of the ESS NSIs when applying a data warehousing approach for statistics.

Its general objectives are:

  • Review of current best practices in integrated business data systems
  • Identification of problems and solutions in current practices and the opportunities
    that a data warehouse might provide
  • Examination of ways in which data can be combined to support new outputs
  • Provision of recommendations on how the ESS can improve data warehousing
  • Dissemination of the ESSnet results to all ESS countries.

 

In order to realize its objectives, this ESSnet will carry out activities around the following 3 axes:

  1. Stock taking / Inventory of current situation in Member States
    As several Member States already have introduced data linking and warehousing, it is important that the ESSnet will make it possible to compile and compare current practices. Therefore work will first focus on taking stock of current best practices in integrated business data systems, of problems and desired solutions, of already available models/architectures and of opportunities that data warehousing can provide. On the basis of this complete inventory of the current situation in Member States, the ESSnet can work out a detailed work plan for subsequent work to be run under the FPA.
     
  2. Analyses and Development
    Efforts will concentrate on the development of a functional model of the statistical data warehouse. Based upon such a model all issues, raised within this ESSnet, can be assessed in a generic and standardized way.  The ESSnet will provide recommendations and best practices on ways in which data can be organized and combined to support interactive data analysis and new outputs. Also it will provide recommendations on how the European Statistical System can implement and improve data warehousing methods, based upon current experiences and identified best practices. Furthermore, a set of tools and guidelines will be created to support the design and implementation of a maximum efficient statistical process for business and trade statistics. Finally, the ESSnet will give recommendations and best practices on various aspects of change management.
     
  3. Dissemination
    The ESSnet will organise workshops to present and discuss intermediate results in order to get feedback and input for further development throughout the entire implementation period of the FPA. The dissemination of developments and results to the other ESS members will not only be done via the channel of workshops, seminars and meetings, but also via a website and through the production of reports, manuals and documentation.

SGA 1

As the field and scope of this ESSnet is very broad, it first needs a strict definition of specific detailed subjects which the ESSnet should explore and study in depth. The activities as defined in this Specific Grant Agreement (SGA) will mainly concentrate on the first (stock taking) and third axes (dissemination), creating the following deliverables:

  • a detailed overview of current best practices in integrated business data systems;
  • a prioritised list of problems and desired solutions as indicated by the Member States;
  • an overview of opportunities that data warehousing can provide for Member States.

Based upon these deliverables, partners will define and prioritize the subjects that need to be explored in depth. The main criterion for this will be the subjects indicated as most urgent by most Member States. Final result will be a detailed work plan for future work to be run under the FPA, with a clear repartition of the subjects in to specific work packages.

During the first SGA 2 workshops will be organised to present and discuss intermediate results with the ESS countries and to get feedback and input for further activities. At the end of this SGA a workshop will be organised to present the final results and the future work plan to the ESS countries.

Read more...