Need advice - good place to start learning SSAS

Question

Post reply

Need advice - good place to start learning SSAS

ntuschiev

SSC Veteran

Points: 230
More actions
July 25, 2012 at 5:15 am

#392824

Any suggestions would be very appreciated.
Currently I have experience with TSQL, SSIS
Thanks in advance,
Nikolay

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

I think a good place to start would be here http://technet.microsoft.com/en-us/library/ms170208.aspx

ntuschiev SSC Veteran Points: 230 More actions · Answer 2

Thanks,

currently I'm reading this one http://msdn.microsoft.com/en-us/library/bb522607

as a starting point..

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

Yep thats a good one to read, more of a overview to SSAS, the one I provided is more of a hands on, lets go build a cube tutorial.

ntuschiev SSC Veteran Points: 230 More actions · Answer 4

Hey someone else wants to share learning sources .. ?

ntuschiev SSC Veteran Points: 230 More actions · Answer 5

FYI

Another great articles from this site!

http://www.sqlservercentral.com/stairway/72404/

Tatsu SSCertifiable Points: 7824 More actions · Answer 6

The Microsoft Data Warehouse Toolkit[/url] by Joy Mundy and Warren Thornthwaite with Ralph Kimball is a really good high-level book that covers how to design and build a full BI solution from the data warehouse or datamart all the way up to the user interface. Knowing SSAS isn't enough to go out and start building cubes if you really want to do it right.

If you can afford the time and money, Pragmatic Works[/url] has some really good online, instructor-lead training. Information on their SSAS class can be found at http://pragmaticworks.com/Services/training/Course/Pragmatic-SSAS-Training.aspx. The time investment isn't too bad at four three-hour sessions plus labs but the $795 can be a little steep if you don't have an employer or patron to cover it. The classes are taught by knowledgeable and experienced consultants are are regularly in the trenches working with companies on real solutions, not Microsoft trainers with little-to-no real-world experience.

BTW, SSAS didn't change in 2012 so 2008 R2 resources will probably be just as good as the 2012 stuff.

[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog

Jared SSC Guru Points: 61793 More actions · Answer 7

I have used Microsoft SQL Server Analysis Services 2008 with MDX for this. I found it very intuitive and a great tutorial that is hands on. I have always liked the WROX books. Also, I second the Stairway to MDX here at SSC. http://www.sqlservercentral.com/stairway/72404/

Jared
CE - Microsoft