Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Newbie question

 
   Database Forums (Home) -> Data Warehouse RSS
Next:  Question about numbers in a field  
Author Message
Ed

External


Since: Mar 07, 2006
Posts: 33



(Msg. 1) Posted: Mon Nov 05, 2007 8:26 pm
Post subject: Newbie question
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

hi,
I am interested in building a DW for my company. As usual, we have 4
different systems which holds different applications. I would like to know
what is the first step of buidling the DW? Retrieve the columns / data that
we need? Any good link to view?

Thanks so much

Ed

 >> Stay informed about: Newbie question 
Back to top
Login to vote
happy camper

External


Since: Nov 07, 2007
Posts: 4



(Msg. 2) Posted: Wed Nov 07, 2007 1:40 pm
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Nov 5, 10:26 pm, Ed wrote:
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to know
> what is the first step of buidling the DW? Retrieve the columns / data that
> we need? Any good link to view?
>
> Thanks so much
>
> Ed

The first step is to close your eyes, take a deep breath, and prepare
for a long and exciting journey.

I am _very_ new to the DW/BI scene so bear that in mind when reading
this post.

I have found these websites helpful:

http://www.dwinfocenter.org/
http://www.kimballgroup.com/

However, what works best for me is the old-fashioned approach: book
learning combined with trail-and-error. You might want to stop by a
bookstore (or use Amazon's "Search Inside" feature) and flip through
some of these titles: http://www.kimballgroup.com/html/books.html

I all but stopped buying technical books several years ago because the
information is often outdated by the time the book goes to press.
Having said that, for a subject that is deep, wide, and unfamiliar,
trying to get up to speed using only internet searches can be
frustrating and counterproductive.

Best wishes on your project!

 >> Stay informed about: Newbie question 
Back to top
Login to vote
Joe

External


Since: Feb 01, 2007
Posts: 22



(Msg. 3) Posted: Wed Nov 07, 2007 1:47 pm
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can hire my team!

"happy camper" wrote in message

> On Nov 5, 10:26 pm, Ed wrote:
>> hi,
>> I am interested in building a DW for my company. As usual, we have 4
>> different systems which holds different applications. I would like to
>> know
>> what is the first step of buidling the DW? Retrieve the columns / data
>> that
>> we need? Any good link to view?
>>
>> Thanks so much
>>
>> Ed
>
> The first step is to close your eyes, take a deep breath, and prepare
> for a long and exciting journey.
>
> I am _very_ new to the DW/BI scene so bear that in mind when reading
> this post.
>
> I have found these websites helpful:
>
> http://www.dwinfocenter.org/
> http://www.kimballgroup.com/
>
> However, what works best for me is the old-fashioned approach: book
> learning combined with trail-and-error. You might want to stop by a
> bookstore (or use Amazon's "Search Inside" feature) and flip through
> some of these titles: http://www.kimballgroup.com/html/books.html
>
> I all but stopped buying technical books several years ago because the
> information is often outdated by the time the book goes to press.
> Having said that, for a subject that is deep, wide, and unfamiliar,
> trying to get up to speed using only internet searches can be
> frustrating and counterproductive.
>
> Best wishes on your project!
>
 >> Stay informed about: Newbie question 
Back to top
Login to vote
David Portas

External


Since: Nov 11, 2003
Posts: 678



(Msg. 4) Posted: Thu Nov 08, 2007 2:57 am
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Ed" wrote in message

> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
>
> Thanks so much
>
> Ed

If you don't have BI experience then get some experienced assistance on
site. A DW is only one part of a BI solution. To be successful and deliver
value to your business customers you should first consider the whole
end-to-end picture.

--
David Portas
 >> Stay informed about: Newbie question 
Back to top
Login to vote
Joe

External


Since: Feb 01, 2007
Posts: 22



(Msg. 5) Posted: Thu Nov 08, 2007 8:16 am
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Gartner claimed a short time ago that DW efforts were the near 50% failure
rate.

Maybe start with just a data mart on a specific subject area on just one of
your 4 applications. Get the ETL working with SSIS, develop a cube in SSAS
and use Excel 2007 to browse cubes or just use SSMS.

Once you are succesful on a specific subject area then you can start pulling
in your other hetrogenous sources.

Without help you will flail about some - so if at all possible; hire some
assistance.

"David Portas" wrote in message

> "Ed" wrote in message
>
>> hi,
>> I am interested in building a DW for my company. As usual, we have 4
>> different systems which holds different applications. I would like to
>> know
>> what is the first step of buidling the DW? Retrieve the columns / data
>> that
>> we need? Any good link to view?
>>
>> Thanks so much
>>
>> Ed
>
> If you don't have BI experience then get some experienced assistance on
> site. A DW is only one part of a BI solution. To be successful and deliver
> value to your business customers you should first consider the whole
> end-to-end picture.
>
> --
> David Portas
>
>
 >> Stay informed about: Newbie question 
Back to top
Login to vote
JAK

External


Since: Nov 17, 2007
Posts: 6



(Msg. 6) Posted: Sun Nov 25, 2007 6:04 am
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

To name just a few items: Create small wins for yourself by Implementing
incrementally, always working on those sections that will have the biggest
positive businss impact and can released in the shortest amount of time. If
you don't already know how to data model, learn. Read Ralph Kimball's books
on OLAP design and implementation

--
Sincerely,

John K
President
Knowledgy Consulting, LLC
1024 Spalding Forest Ct.
Atlanta, GA 30328
---------------------------------------
Knowledgy.org
---------------------------------------
Contact: Knowledgy$knowledgy.org
Replace $ with @ for emails
---------------------------------------
 >> Stay informed about: Newbie question 
Back to top
Login to vote
"Xin

External


Since: Jan 24, 2008
Posts: 1



(Msg. 7) Posted: Thu Jan 24, 2008 5:10 pm
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This web site can give you a jump start on that:

http://www.microsoft.com/bi/about/data-warehousing.aspx

Especially:
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-2...1282b04

Shin

"Ed" wrote in message

> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
>
> Thanks so much
>
> Ed
 >> Stay informed about: Newbie question 
Back to top
Login to vote
Knowledgy

External


Since: Jan 03, 2008
Posts: 56



(Msg. 8) Posted: Tue Feb 12, 2008 5:30 pm
Post subject: Re: Newbie question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You may want to start by conforming facts. Basically, documenting your 4
databases and researching what columns and data are the same in all of the
databases

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Ed" wrote in message

> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
>
> Thanks so much
>
> Ed
 >> Stay informed about: Newbie question 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]