Microsoft OLAP beginner.

Hi.

I've been asked to learn about OLAP (as implemented by Microsoft on SQL 2005 - just in case things are wildly different on other systems).

I'm quite happy with most aspects of normal RDBMS, but my knowledge on OLAP is limited.

So, what books can you recommend? Currently, no courses, but if there are some self worked online tutorials, etc. these would be useful too.

Currently, my desktop Microsoft SQL Server Management Studio cannot connect (probably a firewall issue - being looked into).

So, right at the beginning of this and I'm looking for good links, books, tutorials, etc.

Regards,

Richard.
LVL 40
Richard QuadlingSenior Software DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You can begin with the following books;

1. Microsoft SQL Server 2005 Analysis Services Step By Step (or 2008 version too)
2. SQL Server's Developer's Guide to OLAP with Analysis Services

Or else you can go for professional books like:
1. Pro SQL Server 2008 Analysis Services
2. Microsoft SQL Server 2008 Analysis Services Unleashed

In the mean while get Analysis Services installed in your machine and start parallely working with it to get complete knowledge about it.
0
 
Richard QuadlingSenior Software DeveloperAuthor Commented:
It will have to be 2005 as that is what I've got.

Have you had experience with these books?

0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Then go for "Microsoft SQL Server 2005 Analysis Services Step By Step". I have gone through this book and learnt things on my own (Forgot to mention that I am beginner in OLAP)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.