1 / 30

USE OF COMMERCIAL DATA IN THE GERMAN BUSINESS REGISTER

USE OF COMMERCIAL DATA IN THE GERMAN BUSINESS REGISTER. CONFERENCE OF EUROPEAN STATISTICIANS Seminar on New Frontiers for Statistical Data Collection Geneva, 31 October - 2 November 2012. Outline of the presentation. 1 Data description 2 Data acquisition process 3 Production cycle

hernadezb
Download Presentation

USE OF COMMERCIAL DATA IN THE GERMAN BUSINESS REGISTER

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. USE OF COMMERCIAL DATA IN THE GERMAN BUSINESS REGISTER CONFERENCE OF EUROPEAN STATISTICIANS Seminar on New Frontiers for Statistical Data Collection Geneva, 31 October - 2 November 2012

  2. Outline of the presentation • 1 Data description • 2 Data acquisition process • 3 Production cycle • 4 Experience on data quality • 5 Summary

  3. Data description E# Enterprises E1 E2 E8 E4 E3 E5 E9 E6 E7 04.01.2020 slide 3

  4. Data description E# Enterprises E1 E2 E8 E4 E3 E5 E9 E6 E7 04.01.2020 slide 4

  5. Data description E# Enterprises No control Control E1 100% E2 E8 E4 100% 100% E3 20% E5 60% 60% E9 E6 E7 45% 35% 04.01.2020 slide 5

  6. Data description E# Enterprises Indirect control Control No control E1 100% E2 E8 E4 100% 100% E3 20% E5 60% 60% E9 E6 E7 45% 35% 04.01.2020 slide 6

  7. Data description E# Enterprises Indirect control Control No control Enterprise group E1 100% E2 E8 E4 100% 100% E3 20% E5 60% 60% E9 E6 E7 45% 35% 04.01.2020 slide 7

  8. Data description E# Enterprises Enterprise group Enterprises: 822.000 German enterprises: 776.000 Enterprise groups (EG): 207.000 German EG: 180.000 E1 E2 E3 (Reference year 2010) E4 E8 E5 E9 E6 E7 04.01.2020 slide 8

  9. Data sources Trade register Public registers of county courts Federal gazette Information on enterprise groups Daily economic press Annual reports Surveys List of debtors

  10. Data acquisition process t Desicion • Availability • Efficiency • Reduction of burden 04.01.2020 slide 10

  11. Data acquisition process Deadline for tenders t 52 days Call for tenders Desicion • Description of the specifications of services: • notes for a tender • minimum requirements • additional an optional requirements 04.01.2020 slide 11

  12. Data acquisition process Acceptance of tender t 10-40 days Call for tenders Desicion Evaluation • Catalogue with evaluation criteria: • Exclusion criteria • Should-be-fulfilled criteria • Nice-to-have criteria 04.01.2020 slide 12

  13. Data acquisition process t Call for tenders Desicion Contract Evaluation • Contract after about 1 year of process • Contract for 4 reference years • Yearly delivery since 2003 (reference year) 04.01.2020 slide 13

  14. Production cycle Processing in business register Preparation for processing Validation phase Preliminary talk 1. Data delivery Dissemination t Aug 12 ... Oct 12 Nov 12 Dec 12 Jan-Apr 13 ... Jun 13 • Confirmation of the timeline and order of new material • Reflection of previous year process • Adjustments 04.01.2020 slide 14

  15. Production cycle 1. Data delivery (ref. year 2011) Processing in business register Preparation for processing Preliminary talk Dissemination Validation t Aug 12 ... Oct 12 Nov 12 Dec 12 Jan-Apr 13 ... Jun 13 • Quality checks • Feedback to data provider • Corrections of the material • In case of corrections by the provider rechecking of the data • Acceptance of the material • End of interaction with data provider 04.01.2020 slide 15

  16. Production cycle Processing in business register Preparation for processing Validation phase Preliminary talk 1. Data delivery Dissemination t Aug 12 ... Oct 12 Nov 12 Dec 12 Jan-Apr 13 ... Jun 13 • Technical adjustments 04.01.2020 slide 16

  17. Production cycle Processing in business register Preparation for processing Validation phase Preliminary talk 1. Data delivery Dissemination t Aug 12 ... Oct 12 Nov 12 Dec 12 Jan-Apr 13 ... Jun 13 • Linking by numerical identifiers and address comparison • Add enterprise group information 04.01.2020 slide 17

  18. Production cycle Processing in business register Preparation for processing Validation phase Preliminary talk 1. Data delivery Dissemination t Aug 12 ... Oct 12 Nov 12 Dec 12 Jan-Apr 13 ... Jun 13 • Consolidation of processing • Finish of the business register cycle 04.01.2020 slide 18

  19. Experience on data quality • 52 tests on the data set with information on legal units: • 1st class error: 32 • 2nd class error: 7 • 3rd class error: 13 • 27 tests on the data set with information on their links: • 1st class error: 20 • 2nd class error: 0 • 3rd class error: 7

  20. Experience on data quality Data set with information on legal units (Reference year 2010) 1,23 bn errors 04.01.2020 slide 20

  21. Experience on data quality Data set with information on legal units (Reference year 2010) 1,23 bn errors 591.306 units (62%) 04.01.2020 slide 21

  22. Experience on data quality Data set with information on legal units (Reference year 2010) 73.787 units (8%) 1,23 bn errors 591.306 units (62%) 04.01.2020 slide 22

  23. Experience on data quality Data set with information on the links of legal units (Reference year 2010) 98.320 errors 04.01.2020 slide 23

  24. Experience on data quality Data set with information on the links of legal units (Reference year 2010) 97.530 links (5%) 98.320 errors 98.237 links (5%) 04.01.2020 slide 24

  25. Experience on data quality • Discrepancies between administrative and commercial data • total matches of active units: 404.224

  26. Experience on data quality Discrepancies between administrative and commercial data total matches of active units: 404.224 04.01.2020 slide 26

  27. Experience on data quality Discrepancies between administrative and commercial data total matches of active units: 404.224 04.01.2020 slide 27

  28. Experience on data quality Discrepancies between administrative and commercial data (Reference year 2010) 04.01.2020 slide 28

  29. Summary • Need for enterprise group data by law • Preference for commercial data • Sensible use of the commercial data for the relevant information • No use of the commercial data for further economic analyses

  30. You are welcome! Dr. Susanne Maus Telephone: +49/(0) 611 / 75 20 51 susanne.maus@destatis.de www.destatis.de

More Related