1 / 24

DsNA : A database for network analysis

DsNA : A database for network analysis. Dott.ssa Barbara livieri ( Barbara.livieri@unisalento.it ) . Steps. Objectives and progress report Understand what networks are and what KPIs are used; Define the Goal – stakeholders’ diagram and elicitate requirements E/R Diagram

pia
Download Presentation

DsNA : A database for network analysis

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. DsNA: A database for network analysis Dott.ssa Barbara livieri (Barbara.livieri@unisalento.it)

  2. Steps • Objectives and progress report • Understand what networks are and what KPIs are used; • Define the Goal – stakeholders’ diagram and elicitate requirements • E/R Diagram • Relational Model • Access and queries; • Assignments

  3. Objective The aim is to develop a new tool, called DsNA (Database for Strategic Network Analysis), which enables KPIs monitoring and benchmarking. • Why is this important? • At the moment 50% of alliance fails, often due to the lack of a comprehensive analysis that combines strategic goals and KPIs.; • Performance measurement and management have a key role in the assessment of the achievement of alliance goalsand of how the strategic partnership is affecting firms. • How do we do this? We need: • a database, in which store all useful information on firms, financial statements, KPIs and so on; • a web interface to allow access from stakeholders

  4. Progress report Work done Results 2 published scientific contributions; 2 “works in progress” Call for partnership: Commerce Chambers (CCIAA); Retimpresa; Confindustria. • Information Model; • Requirement Analysis; • Research Plan; • System prototype.

  5. Networks and their rationales • Which are the rationales that justify cooperation between firms?

  6. Networks and their rationales Worldwide Europe Italy

  7. Why a firm should draw a network agreement?

  8. Why a firm should draw a network agreement? Pmi.it IlSole24Ore

  9. How firms are reacting Number of networks and involved firms Link

  10. What information can you get from the agreement • Firms involved; • Contractual boundaries; • Goals; • Steps to achieve them; • Network related tasks; • Rights and obligations for firms; • Economic and governance aspects; • Time interval.

  11. KPIs • We can use predefined KPIs, among which: • and some more, defined in order to satisfy stakeholders’ goals • Several others KPIs could be defined, but they are difficult to track when you don’t work in the organization you’re analyzing

  12. KPIs – Some examples The easiest way is to look at the financial statements, which are generally restructured or presented in a different way from what Italian law requires.

  13. Stakeholders • Researchers; • Consultants; • Network’s Associations (such as Retimpresa); • Policy makers • External subjects (e.g., banks)

  14. Firms’ goals and requirements elicitation Goals Requirements G.1 Evaluating network suitability for specific business goals (competitivity, fiscal benefits, lower interest rate, improvement and increase of advertisement, growth of R&D) R1 (DL). Information objects: firms, network agreements, financial statements, items. (Stored data) R2 (BRL). KPIs calculation rules, privacy  anonimizazion, (derived data) R3 (BRL). Visibility - managers and directors can see (DD): their own analytic data; Information on other firms of the network, depending on each firm choice; synthetic data of other firms and networks; R4 (PL). Reports and dashboards on R3 objects R5 (PL). Filtering, search, ordering and comparison on R1 objects R6 (PL). Overall navigation

  15. Network’s manager’s goals and requirements elicitation Goals Requirements G.5 View statistics (synthetic data) R1 (DL). Required info: network size, firm size, industrial sectors, firms and networks age, performance trend, … R2 (DL) Information objects: Firms, network agreements, financial statements, items, sector. R3 (BRL). KPIs calculation rules, trend analysis and comparison, descriptive and inference statistics indicators, privacy  anonimizazion, R4 (BRL). Visibility: synthetic data of other firms and networks; R5 (PL). Statistical reports on R3 objects; R6 (PL). Filtering, search, ordering and comparison on R1 information and R2 objects; R7 (PL). Overall navigation

  16. Other stakeholders’ goals and requirements Goals Requirements Which requirements? • Researchers and consultants are interests in all NM’s goals, plus the possibility do define new KPIs (G.6); • Network’s Associations and policy makers are interested in synthetic data (G.5)

  17. E/R Diagram Belongs to Includes n n Network m Firm 1 Sector From To Network name Creation date Sector name Code Company name Start date n Year Value Made by n m m Item m n Financial statement Has Refers to n 1 Accounting period From To Il presente diagramma può essere migliorato. Cosa modifichereste?

  18. Possible assignments • Build a part of the website; • Queries; • Db.

  19. Application Structure: three-layer architecture • Presentation layer (interface and interaction); • Business rule layer: rules of access to data and of data transformation (who has access to certain data and how data is transformed) • Data layer

More Related