A concept for the visual and interactive impact analysis and - PowerPoint PPT Presentation

A concept for the visual and interactive impact analysis and simulation of data changes to enterprise metrics Kickoff Presentation 10.04.2014 Master Thesis Matti Maier 1

Index Example • – Problem – Databasis – Model Components • – Requirements Technology • Goals • Methodology • Roadmap • 10.04.2014 Master Thesis Matti Maier 2

Example (I): Problem What happens with our KPIs if … … we increase our sales price? … the energy costs increase? … we lower labor costs? Data Mr. Smith Head of Accounting 10.04.2014 Master Thesis Matti Maier 3

Example (II): Databasis 10.04.2014 Master Thesis Matti Maier 4

Example (III): Accounting in Hotel Business € Room Rate x Room Charges Guests # ∑ + Earnings Invoice € Breakfast + € Dinner Fare + € Additional Charges - Gross Margin ∑ € Material Material Invoices ∑ + € Energy Variable Costs Energy Costs + ∑ € Staff Loans and Wages - ∑ € Fixed Costs Profit Fees, Insurance 10.04.2014 5 Master Thesis Matti Maier

Components and their Dependencies User defines Interface Results Parameter Calculations Model Simulation Engine Metadata Databasis Data Store 10.04.2014 Master Thesis Matti Maier 6

Requirements (I): Web UI Functional Definition of model • Interactively changing • influencing factors Edit data basis for calculation • Visualization of the results on the model • Web application running in a browser • Non-Functional Response times allowing user interaction • Usability • 10.04.2014 Master Thesis Matti Maier 7

Web Application Mockup 10.04.2014 Master Thesis Matti Maier 8

Requirements (II): Model Functional Define Dependencies • Define Operations • Persist model • Model references metadata • Non-Functional Fast access to model data • 10.04.2014 Master Thesis Matti Maier 9

Requirements (III): Simulation Engine • Functional – Can run on operational data store – Calculations based on model – Changed influence factors from UI – Returns the results to UI – Additional data is regarded • Non-Functional – Documented Code – Use standards where applicable 10.04.2014 Master Thesis Matti Maier 10

Technology INFRASTRUCTURE Data-Driven Documents (D3.js) jQuery Browser Open Source Document Manipulation Framework JavaScript Library in JavaScript REST Apache Tomcat Web Open Source Application Server Server for Java Enterprise Applications JDBC / SQL Txl H2 Database Engine Tricia Database Open Source In-Memory Datenbank Hybrid Wiki 10.04.2014 Master Thesis Matti Maier 11

Goals Interactive simulation of the impact of inflencing factors on metrics Near realtime visualization of the impact in a graph 10.04.2014 Master Thesis Matti Maier 12

Methodology • Definition of use cases and possible questions Business Case • Goal to answer the question with the models • Business requirements elicitation Requirements • Technical requirements elicitation • Technology selection Technical • Concept Solution/Prototype Architecture • Implementation of the prototype Prototype • Answering the questions Documentation • Documentation of the results 10.04.2014 Master Thesis Matti Maier 13

Roadmap March April May June July August Phase Work Package CW 12 CW 13 CW 14 CW 15 CW 16 CW 17 CW 18 CW 19 CW 20 CW 21 CW 22 CW 23 CW 24 CW 25 CW 26 CW 27 CW 28 CW 29 CW 30 CW 31 CW 32 CW 33 CW 34 CW 35 Preparation Abstract Kickoff Presentation Business Case Use Cases Goals Requirements Business Requirements Technical Requirements Research Visualization Calculation Patterns Tech. Concept Technology Selection Architecture Prototype Development Implementation Setup Generate Testdata Web UI Model Transformation Calculation Engine Data Source Connection Testing & Debugging Documentation Answer Questions Documentation Final Finalization Presentation Print & Submit TODAY 10.04.2014 Master Thesis Matti Maier 14

A concept for the visual and interactive impact analysis and simulation of data changes to enterprise metrics 10.04.2014 Master Thesis Matti Maier 15

BACKUP 10.04.2014 Master Thesis Matti Maier 16

Visualization in D3js 10.04.2014 Master Thesis Matti Maier 17

Visualization Gephi 10.04.2014 Master Thesis Matti Maier 18

Visualization GraphStream 10.04.2014 Master Thesis Matti Maier 19

Hotel Business: Datasize Approximation No. Rooms Occupation Stays Receipts 50 70% 21.718 7.239 100 70% 43.435 14.478 250 65% 100.831 33.610 500 60% 186.150 62.050 1000 60% 372.300 124.100 1500 60% 558.450 186.150 Time: 1 year = 365 days Receipts / Stay: 3 Beds / Room 1.7 10.04.2014 Master Thesis Matti Maier 20

Other Technologies SAP Stack INFRASTRUCTURE Java Stack SAP OpenUI 5 Browser Open Source UI-Framework Vaadin Data-Driven Documents (D3.js) Open Source Webanwendungs-Framework Open Source Document Manipulation Framework for Rich Internet Applications (RIA) in JavaScript REST GraphStream Open Source Java Graph Library Web SAP AS Java Apache Tomcat Proprietärer Application Server Server Open Source Application Server for Java Enterprise Applications for Java Enterprise Applications JDBC SAP HANA Apache Derby Data In-Memory Database Open Source In-Memory Database 10.04.2014 Master Thesis Matti Maier 21

Transformation Model.json { Model: {Name:myModel}, Nodes: [ SQL Statements … ] } SELECT sum(fieldname) FROM table WHERE datum <= now() GROUP BY guest; Application Code public void simulate() { if(node == leaf ) … else … return …; Txl Statements } SELECT sum(fieldname) FROM table Result.json WHERE datum <= now() GROUP BY guest; { Model: {Name:myModel}, Nodes: [ … ] } 10.04.2014 Master Thesis Matti Maier 22

EAM: Complexity Metrics Interface Application Type Implementation (Appl.) Interface Business Implementation (Dom.) Function Component Operating System Category Heterogenity Operating System Type Coupled Domain Data Base Programming Language Core Periphery Topology Complexity Control Propagation Cost Shared Number of Functional Redundancy Applications Number of Information Standard Industry Flows Conformity Number of Functional Scope Infrastructure Elements 10.04.2014 Master Thesis Matti Maier 23

EAM: Industry Metrics Group by application Group by domain Number of Total Number of Average Number of Information Flows Information Flows Information Flows Number of Infra- Total Number of Infra- Average Number of structure Components structure Components Infrastructure Comp. Number of Applications per Domain Industry Sum of Standard Conformity customizationLevel Total Average Functional Scope (FP) Functional Scope (FP) Functional Scope (FP) Total Average Functional Scope (BF) Functional Scope (BF) Functional Scope (BF) 10.04.2014 Master Thesis Matti Maier 24

EAM: Sample Questions What happens if … … the number of operating systems increases? … we increase the use of standard software? … the functionality of our applications increases? Answers on EAM complexity metrics basis 10.04.2014 Master Thesis Matti Maier 25

EAM: Challenges • Models of large size – Complex to understand from a user perspective • Complex operations for heterogenity and topological metrics – Matrix Calculation – Transitivity • Main Information is in relations between objects, not in the objects themselves – Many aggregations – Many joins / unions 10.04.2014 Master Thesis Matti Maier 26

Web Application: Screenshot 10.04.2014 Master Thesis Matti Maier 27

Example: Calculated Model 10.04.2014 Master Thesis Matti Maier 28

Web Application Mockup: Sidebar bottom 10.04.2014 Master Thesis Matti Maier 29

Web Application Mockup: Others 10.04.2014 Master Thesis Matti Maier 30