Revision Project of the Business Register (BR) and Business Statistics in 2009-2014

1. Revision Project of the Business Register (BR) and Business Statistics in 2009-2014 3-4 September 2013 Tuula Viitaharju

2. Background of the revision project • Business Register in Finland: • 570 000 active legal units • The origin was Business Censuses in 1953,1963 • Regular maintenance started since 1968 • the technical service life of the present BR data system is coming to an end; the previous system revision was made in 1995-1998 • The project was started first as Business Register revision project • Very soon in the definition phase it was realised that it would be more feasible to establish an integrated Business Statistics System Business Statistics

3. Background / present status description • Overlapping work is made between different business statistics systems • Data copies are made and data are processed differently • Changes are made to several different databases or in the worst case errors are corrected only in one place! • Different definitions in different databases/production systems • Unit structures (establishment, enterprise, etc.), varibles (NACE, sector, turnover, employment...) -> inconsistent statistics • Modernisation of the whole Business Statistics system was needed • Move from separate stovepipe data systems to an integrated and consistent Business Statistics System Business Statistics

4. Present status description Process B Publication1 Process C Process A Publication2 Publication3 • Strategies • International regulations and decrees • Technical age Process D Business Statistics

5. Business Statistics

6. Statistical systems in the integrated system (defining phase 2009) • 1. ”Dependent” statistics of the integrated production database • A. Business Register • B. SBS and other statistics: * Financial statement * Regional and industrial statistics * International trade in services * FATS statistics (inward and outward) * Industrial output / Commodity (PRODCOM)C. STS statistics (partial integration) • 2. ”Independent and small” statistics to the warehouse: • Business services (the first system) • Others in near future Business Statistics

7. Collected results of the desired state Yritystilastojen yhteiset asiat Yritystietovaraston määrittely Yritysten suhdanteet / Yritysrekisteri Business Statistics 14.7.2014 7

8. Business Statistics

9. Clarification of the Vision

10. Raw warehouses of data collections • Original data from both administrative files and direct data collections are in safekeeping and usable • No corrections are made to data contents • Data are technically corrected (formats), Data are as ordered • Validity of data has been established (no major deficiencies) • Source data have been described into the metadata system • Standardised procedures (e.g. data descriptions) and tools for data reception Business Statistics

11. Enterpriseproduction database • Place for processing unit-specific data • Unfinished data (controlled with quality variables) • Automatic and manual validation phases, editing and imputation • Conversion of data collection units into statistical units • Unit-level data are validated with the "Unit data processing application” Business Statistics

12. Enterprise data warehouse • Data selections and inquiries • Updating once a day, timed overnight • Data in a consistent place and format(classifications and unit structures) • Passive, i.e. data are not validated direct into the data warehouse but changes are made via the production database • Initially comprises the contents of the enterprise production database) • All data of business statistics in the long run • Different application alternatives for browsing data Business Statistics

13. Data extractions • Unit data extractions • File extractions • Compilation processes of statistics • Updates of external information services (Internet) • Information and researcher services • National Accounts system extraction • Archiving Business Statistics

14. Progress of the process • Managed with the process management application • We know where we are • Tasks are performed in the right order (e.g. data selections after certain checks) • Activation of automatic and manual work phases • Tasks have contact/responsibility persons • Documentation on sub-tasks easily accessible • Planned dates of completion and tracking of adherence to them (→ automatic email messages) Business Statistics

15. Metadata • "Technical and file metadata", e.g.: • Names and properties of variables • Classifications • Managed with variable and classification editors • "Application program metadata" • "Process metadata" • Information from the process management application, e.g. • Who has done and what • Schedules, etc. • Managed with the process editor Business Statistics

16. Business Statistics

17. Where we are now • Plan: Implementation 2014 in phases • Implementation will start 2013 • Data conversion November – December 2013 • After that data collection for annual statistics concerning statistical year 2013 will start Business Statistics

18. Thank you for your attention ! Tuula Viitaharjutel. +358 9 1734 3378 email: yritys.rekisteri@stat.fi • Further information about the revision • Mr Sami Saarikivi • tel. +358 9 1734 3345 • email: yritys.rekisteri@stat.fi Business Statistics