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

▶
a concept for the visual
SMART_READER_LITE
LIVE PREVIEW

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

Nov 13, 2022 23 likes •327 views

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

slide-1
SLIDE 1

A concept for the visual and interactive impact analysis and simulation

  • f data changes to

enterprise metrics

Kickoff Presentation

10.04.2014 Master Thesis Matti Maier 1

slide-2
SLIDE 2

Index

  • Example

– Problem – Databasis – Model

  • Components

– Requirements

  • Technology
  • Goals
  • Methodology
  • Roadmap

10.04.2014 Master Thesis Matti Maier 2

slide-3
SLIDE 3

Example (I): Problem

10.04.2014 Master Thesis Matti Maier 3

  • Mr. Smith

Head of Accounting

What happens with our KPIs if… …we increase our sales price? …the energy costs increase? …we lower labor costs?

Data

slide-4
SLIDE 4

Example (II): Databasis

10.04.2014 Master Thesis Matti Maier 4

slide-5
SLIDE 5

Example (III): Accounting in Hotel Business

10.04.2014 Master Thesis Matti Maier 5

Room Rate Breakfast Dinner

Additional Charges

Material Staff Fixed Costs

Fare

Guests Earnings Variable Costs

Gross Margin

Profit € € € € € € € + x +

  • Energy

€ +

#

+

Room Charges

Invoice

+

∑ Material Invoices Energy Costs Loans and Wages Fees, Insurance ∑ ∑ ∑ ∑

slide-6
SLIDE 6

Components and their Dependencies

10.04.2014 Master Thesis Matti Maier

Model

6

Data Store

User Interface

Simulation Engine

defines Results Parameter Calculations Metadata Databasis

slide-7
SLIDE 7

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

slide-8
SLIDE 8

Web Application Mockup

10.04.2014 Master Thesis Matti Maier 8

slide-9
SLIDE 9

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

slide-10
SLIDE 10

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

slide-11
SLIDE 11

Technology

10.04.2014 Master Thesis Matti Maier 11

Database Web Server Browser

INFRASTRUCTURE

H2 Database Engine

Open Source In-Memory Datenbank

Apache Tomcat

Open Source Application Server for Java Enterprise Applications

REST

Data-Driven Documents (D3.js)

Open Source Document Manipulation Framework in JavaScript

JDBC / SQL Txl

Tricia

Hybrid Wiki

jQuery

JavaScript Library

slide-12
SLIDE 12

Goals

Interactive simulation of the impact of inflencing factors

  • n metrics

Near realtime visualization of the impact in a graph

10.04.2014 Master Thesis Matti Maier 12

slide-13
SLIDE 13

Methodology

10.04.2014 Master Thesis Matti Maier 13

Business Case Requirements Technical Concept Prototype Documentation

  • Definition of use cases and possible questions
  • Goal to answer the question with the models
  • Business requirements elicitation
  • Technical requirements elicitation
  • Technology selection
  • Solution/Prototype Architecture
  • Implementation of the prototype
  • Answering the questions
  • Documentation of the results
slide-14
SLIDE 14

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 Implementation Development Setup Generate Testdata Web UI Model Transformation Calculation Engine Data Source Connection Testing & Debugging Documentation Answer Questions Documentation Finalization Final Presentation Print & Submit March April May June July August

Roadmap

10.04.2014 Master Thesis Matti Maier 14

TODAY

slide-15
SLIDE 15

10.04.2014 Master Thesis Matti Maier 15

A concept for the visual and interactive impact analysis and simulation of data changes to enterprise metrics

slide-16
SLIDE 16

BACKUP

10.04.2014 Master Thesis Matti Maier 16

slide-17
SLIDE 17

Visualization in D3js

10.04.2014 Master Thesis Matti Maier 17

slide-18
SLIDE 18

Visualization Gephi

10.04.2014 Master Thesis Matti Maier 18

slide-19
SLIDE 19

Visualization GraphStream

10.04.2014 Master Thesis Matti Maier 19

slide-20
SLIDE 20

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

10.04.2014 Master Thesis Matti Maier 20

Time: 1 year = 365 days Receipts / Stay: 3 Beds / Room 1.7

slide-21
SLIDE 21

Other Technologies

10.04.2014 Master Thesis Matti Maier 21

Data Web Server Browser

INFRASTRUCTURE SAP Stack Java Stack

SAP HANA

In-Memory Database

Apache Derby

Open Source In-Memory Database

JDBC

SAP AS Java

Proprietärer Application Server for Java Enterprise Applications

Apache Tomcat

Open Source Application Server for Java Enterprise Applications

REST

SAP OpenUI 5

Open Source UI-Framework

Data-Driven Documents (D3.js)

Open Source Document Manipulation Framework in JavaScript

GraphStream

Open Source Java Graph Library

Vaadin

Open Source Webanwendungs-Framework for Rich Internet Applications (RIA)

slide-22
SLIDE 22

Transformation

10.04.2014 Master Thesis Matti Maier 22

{ Model: {Name:myModel}, Nodes: [ … ] }

Model.json

SELECT sum(fieldname) FROM table WHERE datum <= now() GROUP BY guest;

SQL Statements

public void simulate() { if(node == leaf) … else … return …; }

Application Code

{ Model: {Name:myModel}, Nodes: [ … ] }

Result.json

SELECT sum(fieldname) FROM table WHERE datum <= now() GROUP BY guest;

Txl Statements

slide-23
SLIDE 23

EAM: Complexity Metrics

10.04.2014 Master Thesis Matti Maier 23

Complexity Heterogenity Topology Industry

Interface Implementation (Appl.) Interface Implementation (Dom.) Operating System Operating System Type Programming Language Number of Information Flows Number of Infrastructure Elements Functional Redundancy Periphery Propagation Cost Number of Applications Standard Conformity Functional Scope Application Type Business Function Component Category Coupled Domain Data Base Core Control Shared

slide-24
SLIDE 24

EAM: Industry Metrics

10.04.2014 Master Thesis Matti Maier 24

Industry

Number of Applications per Domain Number of Information Flows Standard Conformity Number of Infra- structure Components Functional Scope (FP) Functional Scope (BF) Total Number of Information Flows Average Number of Information Flows Total Number of Infra- structure Components Average Number of Infrastructure Comp.

Group by application Group by domain

Sum of customizationLevel Total Functional Scope (FP) Average Functional Scope (FP) Total Functional Scope (BF) Average Functional Scope (BF)

slide-25
SLIDE 25

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?

10.04.2014 Master Thesis Matti Maier 25

Answers on EAM complexity metrics basis

slide-26
SLIDE 26

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

slide-27
SLIDE 27

Web Application: Screenshot

10.04.2014 Master Thesis Matti Maier 27

slide-28
SLIDE 28

Example: Calculated Model

10.04.2014 Master Thesis Matti Maier 28

slide-29
SLIDE 29

Web Application Mockup: Sidebar bottom

10.04.2014 Master Thesis Matti Maier 29

slide-30
SLIDE 30

Web Application Mockup: Others

10.04.2014 Master Thesis Matti Maier 30