Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft OLAP beginner.

Posted on 2010-11-22
3
Medium Priority
?
403 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 1500 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

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 …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

618 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