1 / 19

Pieter Vlag

ESSnet DWH: business register. Pieter Vlag. Outline. Central role of the statistical units, population frame, which includes number of enterprises, total turnover derived from the Value Added Tax (VAT) total employment derived from social security data. in a statistical DWH

pules
Download Presentation

Pieter Vlag

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. ESSnet DWH: business register Pieter Vlag

  2. Outline • Central role of the • statistical units, • population frame, which includes number of enterprises, • total turnover derived from the Value Added Tax (VAT) • total employment derived from social security data. in a statistical DWH • How to deal with different units in different sources ? • Feedback of revised unit-, population-, turnover- and employment data in DWH to original sources (SBR, VAT, soc security data)

  3. Definition of a statistical Datawarehouse The broad definition of a data warehouse to be used in this ESSnet is therefore: ‘A common conceptual model for managing all available data of interest, enabling the NSI to (re)use this data to create new data/new outputs, to produce the necessary information and perform reporting and analysis, regardless of the data’s source.’

  4. The statistical – DWH (1) • As stagingarea is “core business” forNSIs, • term statistical DWH is usedforstagingarea + WareHouse

  5. The statistical – DWH (2)

  6. Necessity of population frame Datasource I: Survey 1 Datasource I: Admin data Datasource I: BIG DATA Datasource I: Survey 2 • different sourcescover different enterprises -> informationabout ? • timing of availabilitysourcesdiffers -> when complete desc. available ?

  7. Statistical-DWH with a population frame Datasource 4: survey 2 Population. Datasource 1: admin data 1 Datasource 3: survey1 Datasource 2: BIG DATA ADVANTAGE: the coverage of DWH is known (e.g. whichenterprises are included in a DWH)

  8. Units and target population • The population should be known for the preparation phase, integration phase and the actual datawarehouse • datawarehouse; e.g. “about which enterprises info” • its preparation phase ; e.g. when linking data sources • Population aspects: • Statistical unit (source: SBR) • Number of enterprises (source: SBR) • Turnover (source: VAT, via SBR ?) • Employment (source: soc. sec, via SBR ?)

  9. Proposal I • Only statistical unit (=enterprise) is used • - for data-linking • - processing • in the statistical – DWH • Justification: most obvious, ESSnet on Consistency, maintenance

  10. Ideal world versus reality • In the ideal world • only an unique ID for all enterprises exists • the definition of the enterprises corresponds with the statistical unit • In practice, • several countries don’t have an unique ID • different units exist (legal, tax….. ect.) • Therefore…..

  11. INPUT IN S-DWH processing OUTPUT Legal unit KAU “Accountìng” unit LKAU “VAT-unit” Local unit ENTERPRISE GROUP ENTERPRISE (=statistical unit) Enterprise “othertax” units Enterprisegroup enterprise other units ESSnet DWH – business register

  12. Unit base • Complexity of unit base depends on • - scope of statistical-DWH • national legislation (practices) with respect to enterprise units • Unit base closely related to Business Register. • If compex, recommendation to place this base outside the Business registers • - maintenance • - more flexible in case of new in- and outputs • - more transparent in case of linking errors

  13. Position of Business Register in stat -DWH output 2 output 1 output 3 GSBPM 5.7-5.8: calculateaggregates “DATAWAREHOUSE” GSBPM 5.2-5.6: “process” Check processing GSBPM 5.1: link & integrate tax Pop-frame BIG DATA survey other units SBR VAT empl.

  14. SBR and statistical-DWH (1) • SBR = source units + population (number enterprises) • VAT = source turnover • Social security = source employment • Population, turnover and employment together and integrated are the autentativesourceto which all other data are linked • It is assumed that the autentativesourceis correct unlessotherwise proven

  15. SBR and statistical-DWH (2) • Does this mean that the SBR (and VAT and employment registers) is part of the statistical-DWH. • Not necessarily, • a copy of the population characteristics for period t can be derived from the SBR and used in the statistical-DWH • PRO’s easier maintenance, not conflicts with surveys • CON’s feedback to SBR in case of adjustments • “SBR outside the statistical-DWH” (~ 50 % preference of NSIs) • Alternatively, SBR integrated in the SBR • “SBR inside the statistical-DWH” (~ 50 % preference of NSIs) • PRO’s no feedback to SBR • CON’s maintenance (especially with VAT + employment)

  16. SBR and statistical-DWH (3) • Does this mean that totals of VAT-turnover and “register” employment are calculated within the SBR. • Not necessarily, • especially for STS and specialised low aggregate estimates knowledge of • of (other sources of) the branche, • thorough analyses • Estimation techniques • may be desired. • In thise case a separate system for estimating • VAT-turnover • “register” employment • is advised. Decision up to the NSIs.

  17. Option of definition SBR in stat –DWH (2 extremes) output 2 output 1 output 3 GSBPM 5.7-5.8: calculateaggregates “DATAWAREHOUSE” GSBPM 5.2-5.6: “process” Check processing GSBPM 5.1: link & integrate tax Pop-frame BIG DATA survey other units SBR VAT empl.

  18. Feedback to SBR • Only if “SBR outside” • In case of conflictinginformationbetweendatasources and the authenticsource (and indirectly SBR), twoquestion • When incorporating corrections in statistical DWH ? • sure of influential error • When incorporating corrections in SBR? • at certain time periods (end of year ect.)

  19. Last slide • Thank you for your attention, • any questions or comments...........

More Related