Development on Eurostat Internet site

1. Development on Eurostat Internet site Chris Laevaert Unit D4 - Dissemination

2. Introduction • Monitoring figures • Visualisation tools • The dissemination database • New Projects Workshop “Best practices exchanges”

3. Monitoring figures – November 2009 • Almost 3 million visitors • 4,5 million page views • 400.000 dataset extractions • > 500.000 tables consultations • > 400.00 publication downloads (.pdf) • Internal Commission usage less 2% Workshop “Best practices exchanges”

4. Visualisation Tools Workshop “Best practices exchanges”

5. Visualisation Tools – Latest Developments • Data Explorer • Tables, Graphs and Maps (TGM) • Graphical User Interface for Profiles (GUIP) • Business Cycle Clock (BCC) Workshop “Best practices exchanges”

6. Data Explorer • Version 2.3.x in production since 13/11/2009 • Main Features: • Downloads • more download formats (xls, csv, html, pc axis) • download of multiple dimensions (all data in extraction) • improvements for flags and footnotes • Default query customisation (NQG module) • Country protocol order in select data • Extraction limit increased to 200,000 to 300,000 cells • Session timeout increased from 10 to 20 minutes • Busy bars • Bug Fixes (quotation marks, duplication of codes etc) Workshop “Best practices exchanges”

7. Data Explorer • Version 2.4.x • Main features (78 improvements in total) • Grouping long lists under « select data » • Improvement of search functionality • Resizeable columns • Display of last update, table code • Thousand seperator • Single sign-on • Bug fixing and other cosmetic changes • Currently in test • Production planned February 2010 Workshop “Best practices exchanges”

8. Workshop “Best practices exchanges”

9. Tables, Graphs and Maps (TGM) • Version 2.0.x in production since 08/12/2009 • Main Features: • New graph types (horizontal/vertical stacked bar, box-plot, pyramid) • Source of data • Balloons • Improvement of Table layout and customisation • Cosmetic Changes • Bug Fixes Workshop “Best practices exchanges”

10. Workshop “Best practices exchanges”

11. Workshop “Best practices exchanges”

12. Workshop “Best practices exchanges”

13. Graphical User Interface for Profiles (GUIP) • Version 2.0 in test since October 2009 • Main Features • Regional Profiles • City Profiles • Production in spring 2010 Workshop “Best practices exchanges”

14. Workshop “Best practices exchanges”

15. Business Cycle Clock (BCC) • Version 3.0 in production since May 2009 • Main Feature: • Compare 6 countries Workshop “Best practices exchanges”

16. Workshop “Best practices exchanges”

17. The Dissemination Database Workshop “Best practices exchanges”

18. NAVIGATION TREE DATA EXPLORER NEW CRONOS SATELLITE APPLICATIONS COMEXT Administration Portlets API DFT DFT DFT DFT Comext Server Staging DFTL DFTL Save Comext DB API NQG Navtree Staging Database Preview ECG Daemons DE DB CDM Update Production API Navtree Production Database CSV XML Latest Converter Navtree DE Navtree Web Service BCC GUIP TGM ZIP - Bulk Download - Xdis Web service - Google . . . Navigation Tree Data Explorer Graphical UI for Profiles Tables Graphs and Maps Business Cycle Clock Workshop “Best practices exchanges”

19. New Cronos • Current Reference DB: Set of DFT files • Disadvantages • Flat file system • Data consistency • Several scripts/cron jobs for synchronisation • Difficult to manage Workshop “Best practices exchanges”

20. Eurobase • Migration to Eurobase • Pre-production version (for internal users only) to opened by next week • Testing of whole data dissemination chain • Fine-Tuning • Production planned for March/April 2010 • Advantages • Oracle RDBMS • Better synchronisation and data consistency • Easier to manage Workshop “Best practices exchanges”

21. Eurobase • Transparent for end-users, only minor changes • all the codes are defined in uppercase whereas in NewCronos they were in lowercase. • Annual, quarterly and half-yearly time periods have a new format in EuroBase: • DFT, TSV and in addition SDMX-ML format. Workshop “Best practices exchanges”

22. New Projects Workshop “Best practices exchanges”

23. Cities and Regional Profiles (CARP) • Developed in collaboration with Regional Statistics Unit • Provides search functionalities for regions and cities • Will be callable from GUIP • Currently in test phase Workshop “Best practices exchanges”

24. Workshop “Best practices exchanges”

25. Workshop “Best practices exchanges”

26. Workshop “Best practices exchanges”

27. Workshop “Best practices exchanges”

28. Google Project • Google acquired Gapminder Trendalyzer • Creating a new service that make lots of data instantly available for intuitive, visual exploration • A more central role in informed public conversations • Already available in US • Google contacted Eurostat to expand service to EU data Workshop “Best practices exchanges”

29. Google Project - Approach • Start with a subset of datasets and increase this subset gradually • NOW about 11 indicators • Unemployment • Minimum Wage • Gross government debt  • … • LATER • A lot of queries for energy, wind energy, biomass energy, renewable energy, • GDP • … Workshop “Best practices exchanges”

30. Workshop “Best practices exchanges”

31. Workshop “Best practices exchanges”

32. Google Project - Advantages • Targeted towards statistically inexperienced users • Raise awareness about Eurostat products • Reference to the source: Eurostat « clickable » • Translations Workshop “Best practices exchanges”

33. Thank you for your attention Questions / Comments / Suggestions ? Workshop “Best practices exchanges”