It’s not enough that we do our best; sometimes we have to do what’s required.

- Sir Winston Churchill

Projektform og indhold

ProjectPlanning

Business

Requirement

Definition

Technicalarchitecture design

Product selection & installation

Dimensional modelling

Physical design

Data stage, design & development

Test & deployment

End user application specification

End user application development

Maintenance & growth

Projekt model

Project Management

ProjectPlanning

Business

Requirement

Definition

Technicalarchitecture design

Product selection & installation

Dimensional modelling

Physical design

Data stage, design & development

Test & deployment

End user application specification

End user application development

Maintenance & growth

Projekt model

Project Management

# 5

Forretningsområder

Varer

Kunder

Medarb.

Kalender

Afdeling

Leverandører

Kontoplan

Salg X X X X X X

Lager X X X X

Finans X X X X X

Afdeling

Afdeling ID

Afd. hierarki level 1

Afd. hierarki level 2

Afd. hierarki level n…

Afd. Navn

Afd. Ansvarlig

Finans

Konto ID

Afdeling ID

Leverandør ID

Medarbejder ID

Dato

Beløb

Valuta

# 6

Forretningsområde - salgProdukter

Butik

Sælgere

Geografi

Ordremetode

Lev. sikkerhed

Primær lev.

Kalender

Kunder...

Oms. X X X X X X X X X

Kost X X X X X X X X X

DB X X X X X X X X X

DG% X X X X X X X X X

Antal X X X X X X X X X

Budget oms. X X X

Budget kost X X X

Budget DB X X X

Budget DG% X X X

Budgetafv. X X X

Dimensioner

STOCKTABLE

STOCKGROUP

DEBTABLE

DEBGROUP

EMPLOYEE

CREDTABLE

CREDGROUP

Salg

DEBINVJOUR

DEBINVTRANS

STOCKTRANS

DEBBUDGET (STOCKBUDGET)

# 7

Salg - fortsatProdukter

Butik

Sælgere

Geografi

Ordremetode

Lev. sikkerhed

Primær lev.

Kalender

Kunder...

X X

X X X X X X X X X

X X X X X X X X X

X X X X

X X

M2 - butik

Antal bon’er

Antal bon-linier

Antal besøgende

Time

X

Kampagner

X

X

XReklamationer (antal & værdi)

• Basket analyse• Web statistik

# 8

Forretningens behov - finansKontoplan

Dim. 1 – afd.

Dim. 2 - bærer

Dim. 3 - formål

Evt. øvrige dim.

Valuta

Budgetversion

Kalender

Actual/real. X X X X X X X

Budget X X X X X X

Afv. X X X X X X

Afv. % X X X X X X

FTE X X

Actual allok. X X X X X X X

Budget allok. X X X X X X

Open purch. X X X

Budget FTE X X X

Dimensioner

LEDTABLE

DEPARTMENT

CENTER

PURPOSE

EMPLOYEE

Finance

LEDTRANS

LEDBUDGET

PURCHTABLE

PURCHTRANS

# 9

Forretningens behov - indkøbProdukter

Leverandører

Indkøber

Geografi – lager

Godkender

Lev. sikkerhed

ERP dimensioner

Kalender

# ordrer X X X X X X X X

# Antal ordrelinier X X X X X X X X

Antal, bestilte X X X X X X X X

Værdi, bestilte X X X X X X X

Forsinkede dage X X X

Gns. lev. tid X X X

# 10

Forretningens behov – logistikProdukter

Geografi – lager

Shipping interval

ERP dimsnioner

Kalender

Antal på lager X X X X X

Værdi på lager X X X X X

Antal (bev.) X X X X X

Værdi (bev.) X X X X X

Lageroms. hastighed X X X X X

Gross Margin return on inv. X X X X X

Cycle count items X X X

On time shipping, lines X X X

On time shipping, items X X X X

On time shipping, case (order) X X X

Freight cost per unit X X X X

Units damaged/ scrapped X X X X

Value damaged / scrapped X X X X

# 11

Forretningens behov - HRMedarb.

Geografi

Medarb. / jobklasse

Løn gruppe

Skill kategori

Køn? Alder interval

Anciennitet interval

Kalender

ERP dimsnioner

Antal medarb. X X X X X X X X X X

Gns. alder X X X X X X X X X X

Gns. anciennitet X X X X X X X X X X

Grundløn X X X X X X X X X X

Bonus, etc. X X X X X X X X X X

Andre benefits X X X X X X X X X X

Skill rating X X X X X X X X X X

Norm tid X X X X X X X X X X

Antal timer arb. X X X X X X X X X X

Antal timer syg X X X X X X X X X X

Sygdom% X X X X X X X X X X

Ferie timer X X X X X X X X X XFlex status X X X X X X X X X X

# 12

Forretningens behov - aktiverAktiv

Transaktionstype

ERP dimensioner

Kalender

Værdi, periode X X X X

Værdi, ultimo X X X X

BI projekter - afgrænsning

• Tænk stort• Start småt• Udvid efter behov

# 13

Det samlede Data warehouse

Phase 1Phase 2

Phase 3

Phase 4

Phase 5

Phase 6

Organisk vækst

Fase 2

Infrastructure

Datamodel

Reporting-and analysis

Infrastructure

Datamodel

Reporting-and analysis

Fase 3

3-stepprojects

Infrastructure

Datamodel

Reportingand analysis

Fase 1

ProjectPlanning

Business

Requirement

Definition

Technicalarchitecture design

Product selection & installation

Dimensional modelling

Physical design

Data stage, design & development

Test & deployment

End user application specification

End user application development

Maintenance & growth

Projekt model

Project Management

Hvorfor modellere data?

# 15

ERP DM

# 16

AS/400

Excel

CSV

Andet?

E T L

Kube

Extract

Transform

Load

Indsamling af data

Forretningslogik

Data modellering

MS SQL Server 2005+

Integration Services (SSIS)

Analysis Services (SSAS)

TARGIT

ProjectPlanning

Business

Requirement

Definition

Technicalarchitecture design

Product selection & installation

Dimensional modelling

Physical design

Data stage, design & development

Test & deployment

End user application specification

End user application development

Maintenance & growth

Projekt model

Project Management

Mapning - dokumentation

SourceSystem

Source Table Source Column

Dest Table Dest Column

ERP DEBTABLE EmailAddress1 DimCustomer CustomerMail

ERP DEBTABLE Name DimCustomer CustomerName

CRM PROSPECT Name DimCustomer CustomerName

CRM PROSPECT Amount FactSalesBudget Forecast_Amt

# 18

Fordele• Bygger på Best Practice (Data Warehouse – Multidimensionelle

kuber)• Forbindelse mellem AS/400 og MS SQL Server er standard

funktionalitet.• Flyt CPU/DISK forbrug til billigere hardware• Mange muligheder for at tilgå kuber (f. eks. TARGIT, EXCEL, SSRS, …)• Åbent miljø, ingen kompileringer og runtimemoduler• Mange konsulenter worldwide med Targit/MS SQL kompetence• kombinationen MS SQL Server - TARGIT er en fremtidssikker og

holdbar løsning uanset kildesystem• Tilfører IT-afdelingen nye kompetancer, som kan anvendes i andre

sammenhænge

# 19