Want to learn DW concepts : FACT tabels, Dim tables, CUbes

Question

Want to learn DW concepts : FACT tabels, Dim tables, CUbes

tejinder pal singh

SSC Journeyman

Points: 98
More actions
January 17, 2008 at 2:12 pm

#185749

Hi,
Can any one help in learning datawarehouse concepts . I work with SQL Serever DBA/Development stuff.
I want to learn DW concepts and Basics
ANy help will be highly appreciated.
Thanks
TJ

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stefan K SSCommitted Points: 1786 More actions · Answer 1

Hi,

there are a lot of books on the market. For a general overview about the concepts I would suggest to read the books from Kimball. There is also a special book for SQL Server 2005 on the market.

http://www.amazon.de/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0471267155

There are a lots of Webcasts available from Microsoft about their data warehouse technologies. You could check msdn or search by google.

Kindest Regards,

SK

Dan Colbert-387424 SSCrazy Points: 2195 More actions · Answer 2

The Kimball Group website (http://www.kimballgroup.com) is also a great source for some fundamental articles.

Dan

tejinder pal singh SSC Journeyman Points: 98 More actions · Answer 3

tejinder pal singh

SSC Journeyman

Points: 98

January 20, 2008 at 4:37 pm

#770020

Thanks a lot for your help.

Ben Sullins-437405 SSCertifiable Points: 5397 More actions · Answer 4

The Channel9 Wiki has some great screen casts demonstrating how to accomplish a lot of the tasks with the SQL 2005 BI tools. It doesn't however explain conceptually to well what a DW is and why it makes sense. For that I would recommend turning to the Kimball group.

http://channel9.msdn.com/wiki/default.aspx/Channel9.SQLServer

Hope this helps!

Cheers,

Ben

Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...

tejinder pal singh SSC Journeyman Points: 98 More actions · Answer 5

Thanks a lot. It has great stuff for watching.

Thanks a lot again.

dtevlin Ten Centuries Points: 1084 More actions · Answer 6

There are two compeating methodologies in the DW area and have been for a while. Kimbell with the Data Warehouse Lifecycle Toolkit and Inmon with the Corporate Information factory.

We covered both books in grad school and I use a hybrid method most of the time, but it is very useful to know both.

--Dave