Interactive session: Mapping the BPM-Notation on a SDWH layered architecture Discussion on Vision

1. Interactive session:Mapping the BPM-Notation on a SDWH layered architectureDiscussion on Vision in sub groups

2. business architecture – BPM Notation data A: sub-process which must be done Actor • For the operational analytical activities we have used the Business Process Model Notation (BPMN), in a simplified version, in which only four descriptor objects are used, they are: • activity object describes the actor and the sub –process which must be realized. • sequence flow object shows in which order the activities are performed; • association object is used to associate objects, and can indicate some directionality using an open arrowhead, toward the object to represent a result, from the object to represent an input, and both to indicate it is read and updated; • data objects (representedwith a rhombus) show the readerwhich data isrequired or produced in anactivity.

3. BPM Analysis: Structural Business Statistics SBS • 1th Group • The Structural Business Statistics SBS cover industry, construction, trade and services. Presented according to the Statistical Classification of Economy Activity in the European Union (NACE 2) activity classification, they describe the structure, conduct and performance of businesses. • Generally SBS does not collect information on products. The external trade and the production of specific products are covered by Prodcom and external trade statistics.

4. BPM Analysis: Structural Business Statistics (EE-Case) 1th Group

5. BPM Analysis: External Trade statisticsET • 2thGroup • The External Trade statistics track the value and quantity of goods traded between EU Member States (intra-EU trade) and between Member States and non-EU countries (extra-EU trade). • They are the official source of information on imports, exports and trade balance of the EU, its Member States and the euro area. • We will make a top-down analysis of the two ET measures, independently from the products. These measures are related to other statistical production lines considered:

6. BPM Analysis: External Trade statistics(IT-Case) 2thGroup

7. BPM Analysis: Short-term statistics (STS) • 3thGroup • Short-term statistics (STS) describe the most recent developments of country economies. STS cover four major economic domains: industry, construction, retail trade and other services. • In the field of STS, the development in the different economic domains is described with a series of indicators (STS indicators) such as production, turnover, new orders received, prices, number of persons employed, gross wages and several more. STS indicators are published as indices which show the changes of the indicator in comparison with a fixed reference year. • STS indicators are generally published with a monthly frequency. These measures are related to other statistical production lines considered:

8. BPM Analysis: Structural Business Statistics STS (IT-Case) 3thGroup

9. BPM Analysis: Statistical Business Register(SBR) • 4thGroup • The Statistical Business Registeris a registerofallenterprisesaswellastheirworkplaces. The availability of Statistical BRs is the key to the compilation of consistent and comparable short-term and structural business statistics. • SBRs are crucial for establishing efficient statistical survey frames which aim to reduce the reporting burden on enterprises. • We will make a top-down analysis from two significant BR values, which even if they are not objects of direct statistical output at Estat level, have an important impact on economic-stratification characteristics for STS and SBS:

10. BPM Analysis: Statistical Business Register (PT-Case) 4thGroup B, C: 4.2 set up collection C: 4.3 runcollection Surveys data B 4.1 select sample A: 5.2 classify & code (priorities) Complete SBR (T-1) Administrative data A: 5.3 review, validate & edit SBR A: 5.1 integrate data SBR changes (T-1) A: 6.2 validate outputs F, G: 6.2 validate outputs A: Register unit B: Statistical Methods unit C: Information Collection department D: Dissemination unit E: Statistical Producers units F: Economical Statistics department G: National Accounts department A: 7.1 update output systems • D, E: 7.2 produce dissemination products

11. Mapping the BPM-Notation on a SDWH layerd architecture • To this aim, it will be used a graphical mapping of GSBPM on a SDWH layered architecture, where: • GSBPM phases are on horizontal axe on different columns • SDWH layers are on vertical axe on different rows • they cross produce a cell-matrix representation of possible sub-processes. • gray diagonal represents, in a generic statistical process, the most probable association area between SDWH-layers and GSBPM phases. • To include a sub-process in a process flow we fill a cell-matrix with a circle and connect subsequent sub-processes. • As on BPMN, rhombus are representing data objects and must be positioned at layer level. • In order to identify actor of each sub-process we fill each circle with several color. The different actors will be referenced on a separated legend with the associated color. CAWI

12. Mapping the BPM-Notation on a SDWH layerd architecture • Example of mapping a Business Process on a SDWH architecutre: 5 Process 6 Analyze 7 Disseminate 4Collect 4.2 4.3 4.4 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 6.1 6.2 6.3 6.4 6.5 7.1 7.2 7.3 7.4 7.5 4.1 access Layer interpretation and analysis layer integration layer admin balance-fiscal-tax source Layer CAWI Legend: A - Data collection department B- Enterprise statistical department