October 29, 2003 at 11:21 am
Can anyone recommend a book on OLAP? We are planning to create a data warehouse soon with help from some consultants. I need a better handle on this topic.
Thanks
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill is nigh
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 29, 2003 at 6:37 pm
A good starting book is SQL Server 2000 Analysis Services Step-by-Step if you don't have any experience with the AS side. It's pretty fast and touches on the top level stuff. As far as data warehousing theory, anything by Ralph Kimball.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
October 30, 2003 at 2:22 am
I have an FAQ "pending approval" on this one:
Beginners should look at
"Fast Track to MDX" ISBN: 1-852-33681-1
Good beginners stuff but lacking in detail
More expirenced users will need:
"MDX Solutions" ISBN: 0-471-40046-7
Gets right down to the tough stuff but serious hard going. Always on my desk.
Keith Henry
DBA/Developer/BI Manager
Keith Henry
October 30, 2003 at 5:59 am
Books by Ralph Kimball--The Data warehouse toolkit and the Data warehouse lifecycle toolkit are excellent.
October 30, 2003 at 6:11 am
I've used OLAP Unleashed as well as the Microsoft Press Books on Analysis Services.
Buck Woody
MCDBA, MCSE, Novell and Sun Certified
October 30, 2003 at 12:33 pm
Another good book that is just about SQL Server Analysis Services (OLAP) is "SQL Server Developer's Guide to OLAP with Analysis Services" by Mike Gunderloy and Tim Sneath (Sybex, 2001).
November 4, 2003 at 8:21 am
There's a small book from Cognos called "The Multidimensional Manager" that give a good, non-technical overview of OLAP. The book is really a sales tool (I'm a Cognos partner), but it's excellent for describing the benefits/limitations of OLAP. It also give 24 examples of cubes for different functional areas, such as sales analysis or finance. The book can be read in less than a half hour. Note that if you're looking for code, this is not the book.
You can get a copy from Cognos, or I'd be happy to send one.
Don
Donhttp://www.biadvantage.com
November 4, 2003 at 10:33 am
Thanks for the great response.
Midnight on the bridge
Icy wind and yellow moon
rising. No wetsuit.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply