VERTI

1. VERTI Tieto’s statistical data distribution tool Pavel Bublavy Tieto pavel.bublavy@tieto.com

2. Verti team Arto HahtoDB layer Helsinki Markku KoskelaUIHelsinki Jan CzopikUI Ostrava Pavel BublavýUI Ostrava VERTI - Tieto’s statistical data distribution tool

3. Overall solution for distribution of statistical data Presentation tool • Diagrams and tables can be used as elements in building sophisticated reporting applications Text base Reporting • Helsinki Region Trends • Findikaattori of Statistics Finland and Prime Minister’s Office of Finland Data refining tool • Population forecasting model for communes (City of Lahti) Diagram base Combining Calculation Graphics • Education resources optimation model Kohti (for Ministry of Employment and Economy of Finland) Statistical data distribution tool • Displays data as tables and diagrams Statistical base Data distribution • Huge statistical cubes, complicated data structures • The number of cells in the cube is 2.333665125407577e+37 VERTI - Tieto’s statistical data distribution tool

4. Verti main features Scalability ability to handle very big data tables Big statistical tables • The biggest cube at present in production has 30 dimensions • Size of the cube is several GB • Number of non-zero cells in the cube is > 100 billion • The number expressing the count of cells contains about 30 digits Long classifications • CN commodity classification has over 20.000 rows Big databases • Size of the database of Finnish Employment Service Statistics is about 60 GB. • Statistics Finland’s Verti database contains > 7 000 cubes (px files) • Finnish Foreign Trade Statistics in http://uljas.tulli.fi • CN statistics contain > 20 billion numbers Verti picture base • Built by Verti’s graphical tool • Graphics is created dynamically based on actual data Tailored views for authenticated users Authentication • Interface to customer single signon service Verti’s own logging service • Views to the database and picture base can be tailored according to the user Two methods to delimit the view (methods can be used in parallel) • By database sector (subject area) – the user sees only parts of the database • By classification – the user sees only parts of cubes Platform for report applications • Verti has tools to build report pages • It’s possible to combine graphics with texts, both are updated peridically • Example, Helsinki Economic Trends http://www.helsinkitrends.fi VERTI - Tieto’s statistical data distribution tool

5. References Finnish State Treasury (Valtiokonttori) • Administrator of public sector debt, pensions and occupational insurances • Extranet statistical and picture base on pensions, occupational accidents and insurances • Used by HR personnel in public sector organizations all over the country • Under Construction: Report pages for Finnish and foreign investors on amount, structure, rent, etc. of Finlands public debt, based on Verti database and graphics Finnish Board of Education • Under construction: National database on education need forecasts by area, branch and degree of education City of Helsinki • Helsinki Metropolitan area statistical database (www.aluesarjat.fi) • Environment statistics (www.helsinginymparistotilasto.fi) • Helsinki Metropolitan area economic indicators (www.helsinkitrends.fi) City of Lahti • Common statistical database for all departments of the city organization • Intranet, internet (www4.lahti.fi/verkkotilastointi) City of Espoo, City of Oulu • Internal PX-Web databases City of Lahti, City of Lohja, City of Kokkola City of Joensuu • Venni (population growth and housing construction forecasting model for municipalities) Etc. Finland More than 20 public sector customers Main producers of Finnish Official Statistics use Verti Statistics Finland (Statistical Office of Finland) Verti is used as platform for special applications (www.findikaattori.fi) Verti Graphics is used within selected PX-Web databases Finnish Customs Finnish Foreign Trade Statistics (uljas.tulli.fi) Finnish Ministry for Employment and the Economy (TEM) Finnish Labor statistics (only internal database) Four other sites, including ToimialaOnline (www2.toimialaonline.fi) Finnish Game and Fisheries Research Institute Finnish fisheries and hunting statistics The Finnish Centre for Pensions (ETK) Central organization of private sector employment pension companies of Finland The database contains detailed statistics on pensions Intranet database Extranet database (with authentication/authorization) for pension companies Public internet database will be opened later Finnish Forest Research Institute (Metla) Has just bought Verti license Database for Finnish Forest Statistics will be built VERTI - Tieto’s statistical data distribution tool

6. Verti structure client server Web browser UI framework Javascript, HTML, CSS IIS, ASP.NET, C# Graphics engine Runtime base APL Database engine Development base APL CSV, PX WEB PAX VERTI - Tieto’s statistical data distribution tool

7. VERTI Map Graphics Map visualization of statistics data

8. From Px-iMap2 to PX-Map3 Map component Px-iMap2 originally developed by Statistics Norway but discontinued Agreement with Statistics Norway • Statistics Norway will get right use use basic version and distribute basic version to the statistical institutions which are members of PC-Axis Reference Group • Tieto will get right to use Px-iMap2 in Verti Map Graphics Development finished and Map Graphics integrated into Vertiapplication by Tieto • Verti standalone >> PX-Map3 • Basic and Advanced version Distribution of PX-Map3 installation package for PC-Axis Reference Group will be handled by Statistics Finland VERTI - Tieto’s statistical data distribution tool

9. Installation Download will be available from Statistic Finland website • http://stat.fi/tup/pcaxis/lataus_tyokalut_en.html Installation packages will be provided for • 64bit • 32bit Verti Installer Manual installation Support • Jan.Czopik@tieto.com – installation issues • Pavel.Bublavy@tieto.com – runtime issues • Petri.Friberg@tieto.com – sales VERTI - Tieto’s statistical data distribution tool

10. Data communication between PX-Web and Verti PX-Web plugin created by Statistics Sweeden allowing data exchange between PX-Web and Verti Data exchange via PX file VERTI - Tieto’s statistical data distribution tool

11. PX-Map3 in Verti structure Verti Verti standalone Graph Map Graphics Basic Advanced VERTI - Tieto’s statistical data distribution tool

12. Basic Advanced Basic version implements features which were originally intended for Px-iMap2 • Plugin for PX-Web • Free of charge • Choropleth map • Circle map • Pie symbol • Bar symbol map • Svg, vml and png graphics supported • Export of graphics to png, svg and html Advanced versiosn provides additional set of advanced features • Area level selection • Multimaplayers • Zooming- detail selection • Map data reselection • Saved queries • Tools for adminstrators for building graphics into web pages and creating reports VERTI - Tieto’s statistical data distribution tool

13. Roadmap VERTI - Tieto’s statistical data distribution tool

14. Pavel Bublavy Tieto pavel.bublavy@tieto.com