Solved

Microsoft OLAP beginner.

Posted on 2010-11-22
3
392 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
  • 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
spx for moving values to new table 5 74
PERFORMANCE OF SQL QUERY 13 73
Set the max value for a column 7 38
Table create permissions on SQL Server 2005 9 41
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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

772 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