Creating your first data warehouse

Hello,
I am doing a research project on data warehousing so that I can see
what it can do for my workplace. I have googled on this subject and
the web sites I found relating to this have not been too detailed. I
have a basic set of data and business questions that I want answered
already scoped out and I just wanted some rough guidelines as to what
common processes go into creating your first data warehouse. So far it
seems like a starting point is to grab the raw data that is of interest
and push it to a data warehouse, perhaps aggregating data as it is
moved. Past that point I am a little vague on creating fact tables and
dimensions. Does anybody have some sagely advice, or links to sites
that are a good starting point for someone wanting to throw together a
data warehouse?weluvpaul@.hotmail.com wrote:
> Hello,
> I am doing a research project on data warehousing so that I can see
> what it can do for my workplace. I have googled on this subject and
> the web sites I found relating to this have not been too detailed. I
> have a basic set of data and business questions that I want answered
> already scoped out and I just wanted some rough guidelines as to what
> common processes go into creating your first data warehouse. So far it
> seems like a starting point is to grab the raw data that is of interest
> and push it to a data warehouse, perhaps aggregating data as it is
> moved. Past that point I am a little vague on creating fact tables and
> dimensions. Does anybody have some sagely advice, or links to sites
> that are a good starting point for someone wanting to throw together a
> data warehouse?
Buy "The datawarehouse etl toolkit" and "the data warehouse toolkit"
from amazon.
Very good books that will help you understand the whole concept.|||Hi weluvpaul@.hotmail.com,
feel free to browse all the materials on my web
site...www.peternolan.com. It is there for 'newbies'. Feel free to go
to the beginners page. It points you to books I recommend.
I would recommend you do not try to 'read the books and then build a
DW'. Thats rather a slow way to go about getting a DW built.....If
your company truely has no DW already I'd suggest you look outside for
some skills/experience to show you the way.
On 'What can a DW do for my business?'
For commercial organisations the answer should be 'make more money'...
Or more correctly 'enable the business to increase profitability on a
long term sustainable basis.'
Alas, this does not seem to be what most DWs get built for...
Browse through my 'Newsletters' and especially the one about Business
Benefits of DWing.
On my 'fastest payback' project we got all our money back on the EDW
and more before we even turned it on......
So far I haven't heard of any other project that paid back before it
was finished!!
Best Regards
Peter Nolan
www.peternolan.com
weluvpaul@.hotmail.com wrote:
> Hello,
> I am doing a research project on data warehousing so that I can see
> what it can do for my workplace. I have googled on this subject and
> the web sites I found relating to this have not been too detailed. I
> have a basic set of data and business questions that I want answered
> already scoped out and I just wanted some rough guidelines as to what
> common processes go into creating your first data warehouse. So far it
> seems like a starting point is to grab the raw data that is of interest
> and push it to a data warehouse, perhaps aggregating data as it is
> moved. Past that point I am a little vague on creating fact tables and
> dimensions. Does anybody have some sagely advice, or links to sites
> that are a good starting point for someone wanting to throw together a
> data warehouse?|||Thanks for the advice guys, I will check out the references!