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

Newbie question

 
   Database Help (Home) -> Data Warehouse RSS
Next:  Visual Studio  
Author Message
Ed

External


Since: Nov 05, 2007
Posts: 37



(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: 1



(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: May 24, 2007
Posts: 3



(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: 854



(Msg. 4) Posted: Thu Nov 08, 2007 6:58 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: May 24, 2007
Posts: 3



(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 25, 2007
Posts: 1



(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 14, 2008
Posts: 55



(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:   
Related Topics:
newbie design question - I am designing a dimBroker table about all the Borker information. However, there is a table called BrokerContact in the OLTP systems. Obviously, one broker can have multiple contacts. What is the best way to design the relationship in the Dimensio...

Design Question Again. - Hi, I am a newbie and I have been studying DW for a while and I've successfully built some cubes. There is still one thing I am not sure how to design it in the fact table which is the COUNT. Let's say I have an Order Fact to record the order from...

Fact Table(s) Design Question - Please forgive the cross-posting, I wasn't sure the best place to put this question. I'm modeling a procurement process as part of a data warehouse project - and in this case what we're procuring is people (filling jobs). The basic process is that the..

SQL Scheduled Jobs - Is there a way to monitor schedule jobs and restart the jobs automatically when it faills and if it fails then notify the responsible person, is there a tool to do this ?

Running total with "treshold value" detection..? - Hi, I have to create a query which evalaute, for each year, the employees who reached a particular number of absences and when this value is reached. I have 1 000 000 records in my absence table. my table is like this: DateID, EmployeeID, ActivityID,...
   Database Help (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 ]