Copy of 4

1
a presentation by W H Inmon
2
in the beginning were applications.
applications were designed to solve specific
businees needs ...
3
soon there were a lot of applications ..
4
you would think that with a lot of applications
that information would be easy to come by. Not
so.
5
how much revenue did we have last quarter?
426,982
640,000
1,896,118
6
how many customers do we have?
12,992
5,298
761
7
give me a five year trend of sales.
I can give you todays balance.
I only have a months worth of data
I only go back a quarter
8
the only kind of information that applications
are good for are those that - - look at very
specific requirements - look at very current
data - look at detailed data
9
there are dimensions of data that are entirely
untouched by applications
- integration - history - summarization and detail
10
who is a customer?
- a prospect? - an individual? - a business? - an
inactive customer? - a European customer? - a
competitor? - an indirect customer?
11
what is a product?
- a wip? - a finished good? - a discontinued
part? - a foreign part? - a made to order
product? - a precious good? - an ordered but
undelivered part?
12
(No Transcript)
13
so how is it that you really get to know your
customers?
it is through history that you get to know who
your customers are .
14
why is history so valuable -
- people are creatures of habit - it is in
history that important patterns of behavior are
buried - history allows us to see the forest
for the trees
15
detailed data
summary data
both detailed and summary data are needed to run
a business
managerial
clerical
16
data warehouse
- integrated - historical - detailed and
summarized
in support of analytical applications
17
what to expect from your data warehouse ..
data warehouses grow large
18
what to expect from your data warehouse ..
departmental data warehouses called data
marts will start to appear
19
what to expect from your data warehouse ..
people will use the warehouse in ways that you
never imagined
20
what to expect from your data warehouse ..
the DSS community will divide into different
types of users
farmer