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

How to start learnig datawarehousing?

  
   Database Forums (Home) -> Data Warehouse RSS
Next:  SQL 2005 Analysis Services and data encryption  
Author Message
Jwalant Natvarlal Soneji

External


Since: Oct 18, 2007
Posts: 1



(Msg. 1) Posted: Wed Nov 07, 2007 2:21 am
Post subject: How to start learnig datawarehousing?
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)
I have worked with integration services and reporting services in sql
server 2005 and I am willing to learn datawarehousing, but how to
start?

 >> Stay informed about: How to start learnig datawarehousing? 
Back to top
Login to vote
happy camper

External


Since: Nov 07, 2007
Posts: 4



(Msg. 2) Posted: Wed Nov 07, 2007 1:24 pm
Post subject: Re: How to start learnig datawarehousing? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Nov 7, 4:21 am, Jwalant Natvarlal Soneji
wrote:
> I have worked with integration services and reporting services in sql
> server 2005 and I am willing to learn datawarehousing, but how to
> start?

I am just starting to learn myself. Here are my primary sources:

Theoretical:
http://www.dwinfocenter.org/getstart.html

Practical:
SQL Server Books Online > "SQL Server Analysis Services (SSAS)"
contains a wealth of information specific to their product but covers
some background information too.

There's also the "social network bookmark" approach:
http://del.icio.us/tag/datawarehouse, but I don't have enough
foundation for a set of random links to help me much yet.

Best wishes for success on your project.

 >> Stay informed about: How to start learnig datawarehousing? 
Back to top
Login to vote
Marco Russo

External


Since: Jul 11, 2007
Posts: 22



(Msg. 3) Posted: Thu Nov 08, 2007 1:17 am
Post subject: Re: How to start learnig datawarehousing? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Nov 7, 11:21 am, Jwalant Natvarlal Soneji
wrote:
> I have worked with integration services and reporting services in sql
> server 2005 and I am willing to learn datawarehousing, but how to
> start?

The best way to understand how to build good schemas for SSAS and
relational reporting is to learn the Kimball methodology (The Data
Warehouse Toolkit: The Complete Guide to Dimensional Modeling -
http://www.amazon.com/gp/product/0471200247/?tag=se04-20). After that,
you can focus on specific products, but you will have solid
foundations.

However, reading all the content indicatedin the other post (ink
http://www.dwinfocenter.org/getstart.html) can give you a better
overall view of all this world.

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo
 >> Stay informed about: How to start learnig datawarehousing? 
Back to top
Login to vote
Knowledgy

External


Since: Jan 03, 2008
Posts: 56



(Msg. 4) Posted: Sat Jan 19, 2008 7:27 pm
Post subject: Re: How to start learnig datawarehousing? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Also read some of the books by Ralph Kimball. Some of them are The
Datawarehouse Toolkit, The DW Lifecycle and a whole bunch more. I liked
them b/c he uses case studies as examples to his explanations

--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Marco Russo" wrote in message

> On Nov 7, 11:21 am, Jwalant Natvarlal Soneji
> wrote:
>> I have worked with integration services and reporting services in sql
>> server 2005 and I am willing to learn datawarehousing, but how to
>> start?
>
> The best way to understand how to build good schemas for SSAS and
> relational reporting is to learn the Kimball methodology (The Data
> Warehouse Toolkit: The Complete Guide to Dimensional Modeling -
> http://www.amazon.com/gp/product/0471200247/?tag=se04-20). After that,
> you can focus on specific products, but you will have solid
> foundations.
>
> However, reading all the content indicatedin the other post (ink
> http://www.dwinfocenter.org/getstart.html) can give you a better
> overall view of all this world.
>
> Marco Russo
> http://www.sqlbi.eu
> http://sqlblog.com/blogs/marco_russo
>
 >> Stay informed about: How to start learnig datawarehousing? 
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 ]