Solved

Microsoft OLAP beginner.

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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