Solved

Microsoft OLAP beginner.

Posted on 2010-11-22
3
395 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:Richard Quadling
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 34187855
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
 
LVL 40

Author Comment

by:Richard Quadling
ID: 34188164
It will have to be 2005 as that is what I've got.

Have you had experience with these books?

0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 34202904
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question