Want to learn SQL DW processes

  • Hi seniors,

    I am in problem with this point that from where i should start to train myself in SQL DW. oooh let me tell something about me i am dba since last 4 years and have experts skills in SQL DBA tasks But as all of u know that time changes and there is need to change or upgrade my skills so i decide tha i should learn the process of SQL DW and good use through BI studio. But i am unable to verify my initial skills against SQL DW. So can any of u can guide me in SQL DW so that i could enhance my skill set to DW . Any procedure, ? Any Tutorial?, any guidance? So that i could learn SQL DW basics with a couple of months.

    thnks in advance

  • http://www.microsoft.com/technet/prodtechnol/sql/2005/dwsqlsy.mspx - Overview of Business Intelligence and Data Warehousing

    http://msdn2.microsoft.com/en-us/library/ms173767.aspx - Introducing Business Intelligence Development Studio

    Try to pull out some useful tip from the above mentioned websites. Try out using SSAS which comes along with SQL Entr Edition as BI studio and start working on the basic exercies with the sample databases on building cubes stuff etc.,

    If you are interested in manual reading books, then try this...

    MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance Veerman, Lachev, Sarka, and Loria of Solid Quality Learning 9780735623415 0-7356-2341-4 59.99

  • You may want to invest in the following as well:

    Microsoft Data Warehouse Toolkit (Wiley)

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

    By Joy Mundy and Warren Thornthwaite

Viewing 3 posts - 1 through 2 (of 2 total)

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