model drivers: how to industrialize business reporting 2013-09-01

How to industrialize business reporting

with Data Point Modelling and ModelDR tooling


2

About Model Drivers

Business model industrialization.

Model driven products and services: •Reporting•Testing•Regulatory conformance•Business strategy and business cases•Business architecture•Systems delivery

2013-09


3

Agenda

A.The reporting landscape and its gapsB.Steps to industrialized reportingC.How to tool up for industrialized reporting with ModelDRD.Summary and further reading

2013-09


4

One piece of data, many ways to need to see itEach of the modelling approach to solve this has limitationsBringing data together for reporting is thus complex, costly and manual

A: The reporting landscape and its gaps

2013-09

Datapoint modelling and its opportunity

5

One piece of data, many ways to need to see it

All this must be true: • There can

only be one source of truth

• It must be concrete and accurate

• Many players must view it in their own, very differently ways

2013-09

Client data

I need ….. We order that… I don’t care!

No way can we…

Look, it …

I have to …

Accounts data


6

Each of the modelling approach to solve this has limitations

Logical Data Modelling: •Hard coded concepts and relationships•Single set of opinions of how things are

Ontologies are•100% flexible•Lacking concrete standards

Star Schema models & data warehouses•Large scale•Inflexible

2013-09

Client facts table

City

State

Country

Company

Department

Branch

Day

Month

Year

Fox Rabbit

eats

Carnivore Herbivore

Is in the family of

Mammal

Is a species of

Is in the family of

Is a species of


7

Bringing data together for reporting is thus complex, costly and manual

2013-09

No one can afford gaps, inconsistency, errors in 100’s

of business reports.Not sure which is worse –

wrong / late internal reports for decision making

Or wrong reports to regulatorsBusiness

Unit ABusiness

Unit BBusiness

Unit CBusiness

Unit D


8

1. Adopt the vision and mental model2. Implement four big ideas3. Continuous learning and improvement

B: Steps to industrialized reporting

2013-09


9

1. Adopt the vision and mental model

2013-09

What does a good reporting echo-system looks like?Reports and analytics data is 100% accurate = industrialized testingEach user can have their own data to their own rulesReported data has provenance and lineageFast (=automated)

Cheap (=automated)

Fully visible – at the tester level

Well governed and managed

Industrialization: Conversion to the methods, aims, and ideals of industry and economic activity, particularly of an area that was previously underdeveloped

How to industrialize testing10

2. Implement four big ideas

• Big idea 1: Industrialise your understand of your data• Big idea 2: Industrialise your reporting model with DMP• Big idea 3: Overlay your business data with your industrialised

DMP• Big idea 4: Drive implementation through automation and

tooling

2013-09


11

Big idea 1: Industrialise your understand of your data

1. You cant do a good job of reporting without a good understanding of your business data

2. To industrialise reporting you therefor have to industrialise your understanding of the business data

3. This means architecture, design, tooling and appropriate language

2013-09

Manage

Business

Domain

Data

Data warehous

eConsumer

(Regulator, manager,analyst..)

Extract &

formatSubmission

modellDR

Data point model

Taxonomy

design

Business

domain LDM

View, Publish,Analyse

Arelle, EDGAR

Oracle, NoSQLBusiness Objects, Cognos

RDF, Sparql Ontology


12

Architect your understanding of your data

2013-09

ManageBusiness Domain

DataData

warehouse

Consumer(Regulator, manager,

analyst..)

Extract &

formatSubmission

modellDR

Data point

model

Taxonomy design

Business domain

LDM

View, Publish,Analyse

Arelle, EDGAR

Oracle, NoSQLBusiness Objects, Cognos

RDF, SparqlOntology

2: You need concrete data models

1: You need flexibility and abstraction


13

Big idea 2: Industrialise your reporting model with DMP

2013-09

Value

Value Set

Data point

Aspect

CubeBusiness class

Resource link

ResourceAxis

Axis coord.

Table

The data point meta model has dozen main concepts


14

Build reports on an automated production line from quality manufactured parts

2013-09

Pre built report components

Report design

Drag and drop


Big idea 3: Overlay your business data with your industrialised DMP

15

DPM reporting components

Mapping business domain to the report components

2013-09

Business domain data model


16

Big idea 4: Drive implementation through automation and tooling

2013-09

Because design information is structured, this interface

can be automated

MS Word specifications

Continuous testing and integration

MS Excel everywhere!

Business and systems modelling

Build and read reporting databases

Auto generate code

Create synthetic test data

Read and write XBRL


17

C: How to tool up for industrialized reporting with ModelDR

Tooling for planning, analysis and designExample automations with ModelDR

2013-09


18

Example automations with ModelDR

a) Full modelling of business data and databasesb) Domain Specific Language to validate report designc) Mapping from source data to target reportd) Management reports & analysis on provenance and data

lineagee) Word reports give auto generated specificationsf) Design reporting and analytics in graphical design toolg) Pre-packaged taxonomies for XBRL reg reportsh) Testing integrationi) Work in familiar Web and Excel for day to day work

2013-09


19

a) Full modelling of business data and databases

2013-09

You get Best in class tooling for business

domain documentation and modelling

Full integration with other plugins, like Testing, Ontology and code generation


20

b) Domain Specific Language to validate DMP and report design

2013-09

Business rules from the DPM meta model

You get Guaranteed correctness and completeness


21

c) Mapping from source data to target report

2013-09

DPM reporting components

Mapping business domain to the report components

Business domain data model

You get Data provenance from source to report and back Rapid report and analytics database design


d) Management reports & analysis on provenance and data lineage

22

Bus

ines

s do

mai

n

Reporting artefacts

Business domain consumption in reports

2013-09

You get Analysis tools for completeness and correctness Powerful impact analysis


e) Word reports give auto generated specifications

23

Report design and mapping to the business domain

Automated report specifications

Quality assurance metrics and reports

2013-09

You get Automated

specifications of reports and analysis databases


f) Design reporting and analytics in graphical design tool

242013-09

You get Speed and accuracy in

analysis and report design

Full visibility across the enterprise

Full security, change control and multi user integration

Pre built report components

Report design

Drag and drop


25

g) Inbound reporting obligation pre-designs

2013-09

You get modelDR comes with complex regulatory

reports pre-packed, reducing the task to mapping it to the business data

XBRL taxonomy interface to xbrl design tool COREP

FINREP

Solvency II

10-K, 10-Q


26

h) Testing integration

2013-09

You get Tight integration with testing tools End to end design through testing

automation

Quality Center

Auto testing of business rules

Behaviour driven testing

Testing environmentvirtualisation

Requirements management, test management

MD Word testing specifications

Continuous testing and integration

MS Excel everywhere!

Business and systems modelling

Project manager

User

Test environment

Test data

Unit test

Operating model /Business process

Risk management

Test plan

Test result

User AcceptanceTest

User story

Test runner

Database

Tester Programmer

Test case

SUT


27

i) Work in familiar Web and Excel for day to day work

2013-09

You get Work in, integrate

with, existing tooling

Web interface

Excel interface

Modelling interface

Database

RE

ST

ful

web

se

rvic

e in

terf

ace


modelDR plugin development roadmap

•1.0–Base Domain Specific Language–End user help, manual, training

•1.1–Test data generation–Further imports - XBRL, SQL, DDL etc–Further exports – XBRL, SQL, noSQL, DDL etc

•2.0–Ontology integration–Methodology wizards–Domain specific patterns and models

•3.0–KPI modelling and reporting

282013-09


D: Summary and further reading

Summary- There are 4 big ideas to industrialized business

reporting1. Industrialise your understand of your data2. Industrialise your reporting model with DMP3. Overlay your business data with your industrialised

DMP4. Drive implementation through automation and tooling

- Data Point Modelling gives flexibility and concrete data- ModelDR is a tool that implements the DMP- Enabling industrialization and large scale automation

2013-09 29


Next steps

• Demonstration: Attend a short web presentation and explore any aspect of Model Driven Reporting.

• White paper: Request a copy of “Roadmap to industrialised reporting”.

• Questions: Greg Soulsby http://uk.linkedin.com/in/gregsoulsby

• Twitter: @modelDR, @modelDrivers• Youtube: modelDrivenReporting• Linked in group: www.linkedin.com/groups/Model-drivers-4341672/

• Blog: http://blog.modeldrivers.us/• Site: www.modelDrivers.us• Plugin beta: Get the benefits with free support &

contribute to direction

302013-09

http://uk.linkedin.com/in/gregsoulsby

http://www.linkedin.com/groups/Model-drivers-4341672/about?trk=anet_ug_grppro

http://blog.modeldrivers.us/

http://www.modeldrivers.us/

model drivers: how to industrialize business reporting 2013-09-01

Business

business data

reporting model

business domain data

industrialized reporting

integration business

data big idea

reporting landscape

s of business reports