DAMA1107_Zeller - DAMA-MN

separatesnottySoftware and s/w Development

Nov 25, 2013 (3 years and 11 months ago)

70 views

CP1222856
-
0

CP1222856
-
1

CP1222856
-
2

Rochester,

Minnesota

Scottsdale/

Phoenix


Arizona

Jacksonville,

Florida

Research

Education

Patient Care

CP1222856
-
3

Who Has Business Intelligence

CP1259624
-
2

Computerworld Article 10
-
23
-
2006 "Business Intelligence at age 17"

75%
25%
Large companies

(1,000 employees or more)

51%
49%
Midsized companies

(100
-
999 employees)

56%
44%
Small companies

(1
-
99 employees)

Business intelligence in place

No business intelligence

Positive w/impact

Positive w/no measurable
impact

Made better/still room

to improve

Negative results

Business Intelligence Success Rate

CP1259624
-
3

Computerworld Article 10
-
23
-
2006 "Business Intelligence at age 17"

Percentages have been rounded

Very positive,

measurable impact

1%

6%

36%

23%

CEO's Viewpoint of CIO's

CP1259624
-
4

Laurie Orlov Analyst at Forrester Research Inc, report 02
-
09
-
2007



"Happy CEO's Delusional about CIO Performance"

Large firm CEO's viewpoint


Characterize IT as offering
proactive leadership


Portray IT's role as poor or
mediocre


See IT as innovative only
when pushed


Generally not impressed with
IT's ability to track and report
assets


IT was effectively managing
assets as part of its
responsibility

28%

34%

24%

54%

31%

Katzenbach Partners Recent Survey

37%


Ignore rules

63%


Sharing ideas is a waste of time

65%


Rely on co
-
workers and themselves

28%


Improved developer
*
productivity


There is a disconnect between the formal business
process flow and the real one the users have
developed to get the job done.

90's WEB

Evolution of Business Intelligence

Business
-
IT Convergence

Business

(
INFORMATION
)

Strategists'

IT

(
DELIVER
)

Enablers'

80's PCs

Spreadsheet processes

Localized data extracts

Mini server, Networks

Broaden admin/support

Greater insight

Proliferation of data

Expanding roles

Data Mining

24x7, HTML, JAVA,
ETL, Web services,
OLAP, cookies, DW

Performance management
analytic strategies

Aligned BI strategy, CoE

& Best Practices, OBI

Right
-
time Information
Global access

Web
-
base platforms

Performance management,
scorecard, data integration

Expanded performance

RFID in BI processes

Firewalls/Sarbanes
-
Oxley

00's ALIGN

1987

CP1259624
-
5

Business Intelligence Strategies

CP1259624
-
6

Top criteria of CIO's and CEO's


Performance


Functionality and TOC


Speed of implementation


Scalability

CP1259624
-
7

Strategy to Assets

Report:

Chick production by hen

The Chicken and the Egg

New Business: Produce Chickens

CP1259624
-
8

Business strategy:

Successfully hatch chickens

BI strategy:

Monitor chick production per hen

Business process:

Fertilized egg =

rooster + hen +

amenities + duration of sunlight +

correct temperature

Hatched chick =

hen + nest +

fertilized eggs + incubation process

Developed chicken =

hen + chicks +

amenities + correct temperature

Data warehouse

Elements:

Hen

Rooster

Egg

Amenities

Feed

Water

Nest

Daylight

Temperature

Business strategy:

Increase hatch chickens

BI strategy:


-

Measure new chick production




success rate compared to old process


-

Monitor chick production per hen

Business process:

Extend required
light duration

to 52 weeks

Provide continuous appropriate
heat

conditions

Fertilized egg =

hen + amenities + artificial
insemination + correct temperature

Hatched chick =

hen + nest +

fertilized eggs + incubation process

Developed chicken =

hen + chicks +

amenities + correct temperature

Report:

Chick production by hen

Measure new process

The Chicken and the Egg

New Business: Produce Chickens

CP1259624
-
9

Data warehouse

Elements:

Hen

Egg

Amenities

Feed

Water

Nest

Building


Light


Heat

Report:

Hatched chick production

Egg success rate


The Chicken and the Egg

New Business: Produce Chickens

CP1259624
-
10

Business strategy:

Global distribution of chickens

BI strategy:


-

Measure cost per hatched chicken


-

Measure egg development success

Business process:

Procure

eggs

Ready equipment


incubator
,
brooder

Hatched chick =

service delivered

fertilized eggs + artificial incubation process

Developed chicken =

chicks + amenities +

artificial brooding process

Data warehouse

Elements:

Egg (service delivery


element)

Incubator

Brooder

Building

Heat

Humidity

Chick Amenities

Feed

Water

DW 1

Elements:

Hen

Rooster

Egg

Amenities

Feed

Water

Nest

Daylight

Temperature

DW 2

Elements:

Hen

Egg

Amenities

Feed

Water

Nest

Building


Light


Heat



DW 3

Elements:

Egg (service delivery


element)

Incubator

Brooder

Building

Heat

Humidity

Chick Amenities

Feed

Water

Hatch Chickens

Increase Production

Global Distribution

Evolving Process

CP1259624
-
11

Business Strategy




BI Strategy






Business Processes

Technology
delivers

Information Management

Business intelligence and Data warehousing

Dresner Advisory Services, LLC
-

2007

USERS

Analytical Applications

Query and
Reporting
Tools

Dashboard
Tools

Statistical &
Analytical
Tools

Data Mining
Tools

Dictionary/Semantic Layer

ETL, DQ, DW

Data Marts

Corporate
Data

Business Intelligence Components

CP1259624
-
14

IT

(
DELIVER
)

BUS.

(
INFORMATION
)

D
W
1

D
W
2

D
W
3

Business Intelligence Components

CP1259624
-
14

IT

(
DELIVER
)

BUS.

(
INFORMATION
)

D
W
1

D
W
2

D
W
3

Information Management

Name:

DECA

Factor:


10 / 1

HECTO


10 / 2

KILO

10 / 3

MEGA


10 / 6

GIGA

10 / 9

TERA

10 / 12

PETA

10 / 15

YOTTA

10 / 24


EXA

10 / 18

ZETTA

10 / 21

DM Review reports:

By 2010 Data storage will be approaching
1 ZETTABYTE

1,000,000,000,000,000,000,000

Data growth rate averages about
30%

per year

Modeling Techniques

The Flow of Warehouse Data Modeling Deliverables


Business Goals & Drivers


Information Needs


Source Composition


Source Subjects


Integrated Source


Data Model (ERM)


Source Data Files


Source Data File
Descriptions


Source Data Structure
Model


Warehousing Subjects


Business Questions


Facts and Qualifiers


Targets Configuration


Implemented
Warehousing Databases


Staging, Warehouse & Mart


ER Models


Data Mart Dimensional Models



Staging Area Structure


Warehouse Structure


Relational Mart Structures


Dimensional Mart Structures


Staging Physical Design


Warehouse Physical Design


Data Mart Physical Designs
(relational & dimensional)

Contextual

Models

Conceptual

Models

Logical

Models

Structural

Models

Physical

Models

Functional

Models

Triage

© The Data Warehousing Institute

Synergy

Web

Applications

Portals

B2B

Performance Management

CP1259624
-
12

Operational

Business Intelligence

(coarse grained)

Legacy

Operational

Data

Warehouse

Web

Repository

Conventional

Business Intelligence

(fine grained)

Business Process Flows


Custom Business functions


Based on Services


Global integration of businesses


Federated architecture


Mechanically based approach


Performance
management


Process reusability


Open
-
source


100% deployed


Object
-
Oriented Processes


Dependent on binding data to
processes


Point
-
to
-
point and hub &
spoke integration


Manual driven approach


Reporting


Analytics


OLAP


Data Mining

1.

It takes a lot of work to put together an SOA ... and no one wants to clean up
the associated mess that comes with it.

Michael Meehan


Search SOA.com 11
-
19
-
07

SOA can be Like a Thanksgiving Meal

2.

Reuse, the next round of Web services you build are the IT equivalent of
next week's turkey sandwiches and soups. You should be getting a lot of
meals out of this feast.

3.

Unless you find a way to spice it up or make it savory, SOA can be dry and a
lot of people around the table may quickly lose interest. Also, too much SOA
can put you to sleep.

4.

An SOA project can bring together a lot of people you rarely see. In fact, you
probably aren't sure you want to see some of them.

5.

SOA can give rise to lots of interesting combinations, kind of like turducken
(a chicken stuffed inside a duck stuffed inside a turkey).

6.

Everyone offers up advice on how to cook up an SOA, but they always leave
you with the distinct feeling that they aren't so sure these tips actually work.

7.
Standards, on Thanksgiving the standards are turkey, mashed potatoes,


gravy, stuffing and cranberry sauce. In SOA it's WS
-
* specifications and


communication protocols.

8.

You can undertake lots of small projects while you've got your SOA bird in
the oven.

9.

It takes a solid network and good communication to move all the food
around a Thanksgiving table so that everyone gets to pick exactly what they
want. In many ways, it's a service
-
oriented meal dependent on a loosely
-
coupled infrastructure.

10.
Screw up your SOA and you'll never hear the end of it.

Business Intelligence Organization

CP1259624
-
15


BI Sponsorship


BI Program Oversight


BI Project Team

Enterprise/Department level
Project Sponsorship &
Management Office


Requirements


Development


BI Project "XYZ"

Service Level Agreement
(consulting, doing, mentoring,
coaching, training, etc)

Coordinate Business Priorities &
Projects to Tactical Objectives for BI

Align Business Strategy Plan to
Vision for BI

Getting Data In

(GDI)

Getting Information Out

(GIO)


CoE

Shared Services Admin

Business Intelligence Deployment

CP1259624
-
16


Establish reports


Ad
-
Hoc data query mechanisms


Localized level of organized data


Mini servers and segmented processes


Heard about Business Intelligence


Initial advance analytical processes


Scorecards and dashboards


Localized marts and data repositories


Motivated by Business Intelligence
-
has

some understanding


Standardized metrics and alerts


Enterprise


Aligned business direction and support


Enterprise data warehouse, portals and
dashboards


Center of Excellence


Adopted Business Intelligence Best Practices


Enterprise integration of business processes


Use of certified services


Established Business Performance
Management technology and methodology


SOA: Alignment of BI to BPM is achieved

Where Do We Go From Here?

CP1259624
-
17

CP1259624
-
19

Scope of the enterprise needs to be
defined.


-

all institutional department, business units


-

partners


-

associates


-

suppliers


-

web


CP1259624
-
20

Where Do We

Go From Here?

Business Intelligence 2.0

Location BI

Pervasive BI


Data Warehouse 2.0


Web 2.0


SaaS


New licensing strategies


Governance

CP1259624
-
20

Where Do We

Go From Here?

‘These are Changing Times’



IBM obtains Cognos



Oracle acquires


Hyperion



SAP buys BO



BEA almost sold to


Oracle

CP1259624
-
21

Where Do We

Go From Here?

Jonathan Wu, Nightsbridge Solutions
-

2001


CP1259624
-
22

Business Intelligence:
Chicken or the Egg

Plan and Define , Plan and Define, Plan and Define

CP1259624
-
23

Reference Articles

Web


BI review
-

BI: the Chicken or the Egg by John Zeller, 06
-
2007


Computer World


Business Intelligence at age 17 with Howard Dresner by China Martens,

10
-
23
-
2006


Gartner Magic Quadrant

for BI Platforms, 01
-
26
-
07


Computerworld Executive Briefings;

Mainstream BI


Knightsbridge White Paper


Top 10 Trends in Business Intelligence for 2007


CXO America Article


will it be extinction for the enterprise software model; by Eric
Kavanagh TDWI, 12
-
2006


DM Review


Back to Basics by Greg McMillan; 11
-
2002


DM Review


On
-
Demand Business Intelligence and Software as a Service Revolutionizing


Small to Medium
-
Sized Business by George O'Connor, 01
-
2007


TDWI


Putting the Business Back into BI; by David Wells, 04
-
2006


Forrester Research Inc.
-

Happy CEO’s Delusional about CIO Performance

by Laurie Orlov Analyst, 02
-
2007


Media Inc.
-

CIO Insight


A Valued Tool Still Has Unmet Potential

by Ziff Davis, 10
-
2005


Business Intelligence Network



Technology or Business


the chicken or the egg part 1,2,3;

by Bill Inmon, 10
-
2007

Books


Performance Dashboards
-
Measuring, Monitoring, and Managing Your Business


by Wayne
W. Eckerson


BI Strategy
-
How to Create and Document


by Michael L. Gonzales and David L. Wells