linked in 1ère table ronde 20110330

Le Réseau des professionnels de la Business Intelligence en Suisse Romande

De l’utilité d’un ODS – Table ronde

Lausanne, le 30 Mars 2011

AGENDA

• 14h00 – 14h10 Le mot de bienvenue – Trivadis

• 14h10 – 14h15 Un mot sur le réseau sur LinkedIn – Dario Mangano

• 14h15 – 14h30 La BI chez Nespresso – Dario Mangano

• 14h30 – 14h45 La problématique ODS – Dario Mangano

• 14h45 – 15h15 Présentation de cas – Boris Horquin

• 15h15 – 15h30 Pause café

• 15h30 – 16h00 Présentation de cas – Michel Bridy

• 16h00 – 16h30 Discussion ouverte sur l’ODS

• 16h30 – 17h00 Présentation d’une solution ODS – Trivadis

• 17h00 – 17h15 Discussion sur les prochains sujets de table ronde

• 17h15 Conclusions et drink

La problématique ODS

• Le mot de bienvenue…


• Le groupe LinkedIn

La BI chez Nespresso

Knowledge Management

Enterprise Content

Management

Business Intelligence

CIO

Unstructured DataUnstructured Data Structured DataStructured Data

From Data To Information To knowledge To Actions


BI at HQ – Internal Organization

– 1st view: by activities• Operational• IT Projects• Business Projects

– 2nd view: by BI layers / areas• Back End• Front End• Infrastructure

– 3rd view: by interactions• Businesses

• Markets


The pre-existing SituationSources Integration Denormalization

Te

xt

1 2 3 4 3

0

10 20 40 5030

10

20

Business ReportsOLAP cubes

CH

D-1Reporting DBNesImports

ProtoDWH(Project)

2038 reports, 127 cubes,

1869 reports on cubes

0 reports, (1 cube)1156 reports,

0 cubes

FR

DE

ES

CEE

AU

AS

BE

US

SQL

ETL


Roadmaps

DWH Foundation - IDHSources Integration Denormalization Presentation

Web

Tel

Other

Real Time Operational reporting

N1

N2

N3

Nn

Nx

.

.

CRMETL

Operational reportingControl and QC reporting

BI reports, Cubes and Dashboards

IDH

Quality

Services

ETL

SCM

FIN

HR

Other

ETL

ETL

ETL

ETL

Metadata

Decoup

ling


Roadmaps

DWH Foundation - IDH

Operational MetadataConfiguration Rules

Data Import Layer Data Integration Layer

Flat File

DB Table(s)

Operational Integration Data Store

Data PublicationLayer

Data Access Layer

MDH

iTED

Transaction Data such as Authorization Trade

ETL / REPL

ESB

RV (MOM)

Staging

Staging

Authentication Service

Web Service

SQL Service

Authorization Service

Archive

Metadata

DataEntitlements

RI /Syntax Rules

File Syntax Rules

SemanticRules

Transform. Rules

Pub/Sub Config

Metadata & Metrics Data MartsOperations Console & Management Layer

IDH DataMartOperational Metatdata Reporting

Metadata Console

HubServices

Configuration

Repair Console

Archive Console

Common Services Layer

ArchivingException

MgmtBusiness

Rules EngineScheduler Process

ControlAuditing Notification

Import Staging

IntegrationProcesses

Data Quality Rules

RIScheduler Rules

Enrichment Rules

Structure Rules

Master Data such as Asset and Account

KEY

Data Store

Metadata Store

Process

Service

Document

Created by

Created on

3

FAAC

May-5-2008

Last Updated by

Last Updated on

CONMZC

May-30-2008

Version 1.0

Location

The IDH reference architecture is shown here from the perspective of its services are related to the components of the IDH.

The diagram shows what services each component is expected to deliver. The components are what will actually be built or bought must deliver the services.

Description / Objectives

IDH Reference Architecture – Components-Services View

Message(CDM)

DB Load(files)

ETLDatatype Checks

DB Formatting

Archiving

Message Capture

Synchronization

GIM Transformation

iTED

MDH

Movem

ent or R

eference?

Change Data Capture

Identity Mgmt

Cross Ref. Mgmt

Hierarchy Mgmt

Match & Merge

Data Movement

Data Movement

Flat File

DB Table(s)

ETL

ETL/REPL

Message(CDM)

IDH DataMart IDH DataMart(e.g.

Performance)(e.g.

Data Quality)(e.g.

Data Lineage)

DQ Profile Metrics

LineageMetadata

Operational Metadata

ExceptionLogs

LUW Rules

Source DB

SemanticAdapter to GIM

(optional)

Database Extract

Data Formatting

PublisherApplication

Target DB

SemanticAdapter from GIM

(optional )

SubscriberApplication

Data Publication

ESB

MOM

Data Flow

Data Distribution

D1

V1D2

DB Load(DB)

Msg Formatting

2

3

Key Management

4

Workflow

Direct MD Update

5

5

5

D2


Sources

Web

Tel

Other

N1

N2

N3

Nn

Nx

.

.

ETL - CDC

Metadata

Staging

IDH

ODS

ETL


QUESTIONS :

• Pourquoi avons-nous besoins d’un ODS ?• Historisation ?• Scénario de reprise ?• Alternatives ? (back-up des Stagings ?)• Chargement par hub régional ?• Etc.


Etude de cas : Groupe Mutuel Assurances – Boris Horquin


Etude de cas : BCV – Michel Bridy


DISCUSSIONS


Une solution ODS - Trivadis


• Discussion sur les prochains sujets de table ronde


• MERCI !!!

http://misociety.com.au/wp-content/uploads/2008/04/nespresso-george-clooney.JPG

linked in 1ère table ronde 20110330

Documents