Federal Department of Home Affairs FDHA Federal Statistical

  • Slides: 10
Download presentation
Federal Department of Home Affairs FDHA Federal Statistical Office FSO Data Exchange Platform within

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Data Exchange Platform within the scope of Business Statistics Claude Macchi Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Content • The organisation

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Content • The organisation of the Swiss Federal Statistical Office: from the stovepipes to … • The statistical business register and the administrative data within the scope of the integrated production system of business statistics • The exchange platform Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 2

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Claude Macchi, Centre of

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 3

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Centralised data system for

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Centralised data system for BS Framework Conditions (Classifications, Definitions, Codification, Variables, Methods, Data Exchange, Data Validation, Unique Identifiers, Imputations …) Statistical Sources, Profiling, Private DBs Administrative Sources STATENT SBR Structure of business Sampling Frame ESPA UDEMO FTE Model FATS Wages Statistics R&D BAPAU DLU Labour Market STATEM DHU SPAO SVOLTA VAS NA Productivity Bank Statistics Building Statistics Agricultural Statistics Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 Health Statistics People / Household / Education 4

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Why an exchange platform?

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Why an exchange platform? • Produce once, use many times -> make data centrally available for the analysis and the production of business statistics • Controlled access to the data • Harmonisation and consistence of data and metadata • Standardised and responsible use of the FSO IT system Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 5

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The Exchange Platform (1/2)

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The Exchange Platform (1/2) BR UDEMO National Accounts Turnover Added Value Statistic Goods Import/ Export STATENT analyzes UDEMO analyzes Employeme nt BR Wages / Income Apprentice s Consistency . . . Income statistic Globalisation statistic BB (Population and Education) Platform Admin Data STATENT WI (Economy ) GS (Health and Social Affairs) RU (Territory and Environment ) Sampling frame . . . Metadata Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 6

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The Exchange Platform (2/2)

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The Exchange Platform (2/2) Which data? • Administrative data (Social Security, VAT, Customs, Taxes) • STATENT, business demography • Business statistics data to be shared To whom? • FSO units only In which format? • SAS libraries, Business Object Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 7

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The SAS Architecture Individual

Federal Department of Home Affairs FDHA Federal Statistical Office FSO The SAS Architecture Individual management off acces rights Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 8

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Link to the metadata

Federal Department of Home Affairs FDHA Federal Statistical Office FSO Link to the metadata • Metadata are centrally stored in the Statistical Metadata System (SMS) based on SDMX-ML ü Variables ü Classifications ü Dataset structure • Based on the SMS Codebooks are produced, which contain metadata stored in the SMS and enriched with additional information (conceptual metadata) produced by the data owners Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 9

Federal Department of Home Affairs FDHA Federal Statistical Office FSO claude. macchi@bfs. admin. ch

Federal Department of Home Affairs FDHA Federal Statistical Office FSO claude. [email protected] admin. ch Claude Macchi, Centre of Excellence on DWH, Wiesbaden, 23. 11. 2016 10