Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Want to learn DW concepts : FACT tabels, Dim tables, CUbes Expand / Collapse
Author
Message
Posted Thursday, January 17, 2008 2:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 10:42 AM
Points: 4, Visits: 436
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
Post #444600
Posted Thursday, January 17, 2008 2:55 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 06, 2011 7:52 AM
Points: 80, Visits: 44
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
Post #444628
Posted Friday, January 18, 2008 1:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:51 PM
Points: 269, Visits: 338
The Kimball Group website (http://www.kimballgroup.com) is also a great source for some fundamental articles.

Dan
Post #445131
Posted Sunday, January 20, 2008 4:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 10:42 AM
Points: 4, Visits: 436
Thanks a lot for your help.
Post #445316
Posted Thursday, January 24, 2008 3:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 25, 2010 10:10 AM
Points: 297, Visits: 267
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...
Post #447243
Posted Wednesday, January 30, 2008 2:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 10:42 AM
Points: 4, Visits: 436
Thanks a lot. It has great stuff for watching.

Thanks a lot again.
Post #449690
Posted Thursday, January 31, 2008 10:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 29, 2009 2:34 PM
Points: 56, Visits: 77
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



Post #450068
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse