solutions > statistical data warehouses and information systems

Statistical Data Warehouses and Information Systems

Architecture, development and integration of complex information systems for organisations with information intensive needs, such as official statistics. Database and data warehouse design and implementation, as well as data organisation and management

• PPP Integrated Information System: development of an integrated information system, including a central data warehouse and web based applications for the management of the Purchasing Power Parities multi-country survey. (Eurostat, 2006-2008)
• PPP Data Warehouse, Survey Management Tools and Methodology: A data warehouse for price data, indicators and metadata for the European Purchase Power Parities (PPP) surveys, web-based tools for the management of the price surveys, as well as development of related statistical methodology. (Eurostat, 2004-2009)
  
• ETIS Transport Indicators Dissemination System: An integrated system for the collection, storage and delivery of indicators and metadata of the European Transport Information System (ETIS), including a multi-dimensional data warehouse and an OLAP server based on an SDMX-ML web service. (DG Transport and Energy, 2002-2005)
• IST/STATLAS - Statistical Atlas of the European Union: A dissemination system for geographically-referenced multidimensional statistical data, including a data warehouse, a geographical database, a data analysis toolkit and a metadata driven web service for data delivery in GESMES/XML and GML formats. (Eurostat, 5th Framework Programme for RTD, 2001-2004)
• NSSG Integrated Information System: Requirements analysis, process analysis, architecture and design of the survey information system of the National Statistical Service of Greece (NSSG), as well as detailed design and implementation of an integrated survey, classification and metadata database. (NSSG, Altec SA, 2002-2004)
• NSSG Data Warehouse: An integrated metadata based data warehouse for the storage and management of aggregated statistical data for the National Statistical Service of Greece (NSSG), including implementation of ETL (Extraction, Transformation and Loading) procedures. (NSSG, Altec SA, 2000-2004)
• IST/ESIS e-Survey Tools: A palette of web based software tools for e-surveys and measurement of statistical indicators, including: web survey management, e-questionnaire design, web based data collection, data warehouse and statistical analysis tools. (Eurostat, 5th Framework Programme for RTD, 2001-2004) 
• Postal Codes NUTS Mapping: Maintenance of nomenclature conversion tables to support the automatic mapping and homogenisation of transport statistics collected in member states on the basis of local postal codes to European statistics on the basis of the NUTS nomenclature. (Eurostat, 2005)
• Automatic data collection for statistics of Flight Delays: Feasibility study of the available technological options for automatic data collection of flight delays data directly from the information systems of major European airports, EuroControl and IATA. (Eurostat, 1999)