Microsoft OLAP Unleashed with CDROM [Paperback]

Bob Pfeiff (Foreword), et al (Author)

Book Description

Series: Unleashed | Publication Date: November 18, 1999

Microsoft OLAP Unleashed offers professional-level expertise and an in-depth explanation of the latest in multidimensional database management. It contains an entire section on MDX, the programming language of OLAP. MS OLAP Unleashed details real-world uses, how to prepare data, and how to implement an OLAP system. Topics include preparing data, creating cubes, using PivotTable Service, OLAP programming, using Excel as client, server security, real-world examples, managing a data warehouse MDX reference, and system.

Editorial Reviews

From the Back Cover

Microsoft OLAP Unleashed offers professional-level expertise and an in-depth explanation of the latest in multidimensional database management. It contains an entire section on MDX, the programming language of OLAP. MS OLAP Unleashed details real-world uses, how to prepare data, and how to implement an OLAP system. Topics include preparing data, creating cubes, using PivotTable Service, OLAP programming, using Excel as client, server security, real-world examples, managing a data warehouse MDX reference, and system.

About the Author

Tim Peterson is a data warehousing consultant, seminar leader, and database designer with his company, SDG Computing, Inc. He is a MCSD, a MCSE, a MCT, and an associate member of the Data Warehousing Institute. Visit his web site at sdgcomputing.com. Jim Pinkelman, PhD, is VP of Technology and consultant for Geppetto's Workshop, specializing in relational and multi-dimensional databases. He teaches Management Sciences part-time at Loyola University in Chicago. Russell Darroch, PhD, is a MCSE, a MCT, and a MCP and owns a consulting firm in Australia, Accord IT Solutions, which specializes in relational and multidimensional databases. He is also Senior Instructor with Microsoft Australia. Visit his web site at accord-it.com.au.

Product Details

• Paperback: 900 pages
• Publisher: Sams; 1st edition (November 18, 1999)
• Language: English
• ISBN-10: 0672316714
• ISBN-13: 978-0672316715
• Product Dimensions: 9.1 x 7.4 x 2.2 inches
• Shipping Weight: 3.7 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #2,708,077 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

27 of 28 people found the following review helpful:

5.0 out of 5 stars Finally a comprehensive book, December 7, 1999

By A Customer

This review is from: Microsoft OLAP Unleashed with CDROM (Paperback)

I have finally found a comprehensive book for OLAP solutions. I have read several good books that deal either exclusively with OLAP or exclusively with data warehousing. This book touches on all aspects.

And FINALLY, some examples and explanations on how to use the advanced aspects of DTS. I have been unable to find this anywhere else.

I also liked the fact, that although more detail was neeeded in some areas, it managed to touch on a large amount of all the aspects involved with OLAP and SQL.

While at times, it was a little too technical for me, and other times a little too general, this is by far the best book on SQL and OLAP I have come across yet.

I highly recommend this book for those who need a fairly complete reference to SQL/OLAP.

26 of 29 people found the following review helpful:

5.0 out of 5 stars Best DTS documentation and more, December 10, 1999

By A Customer

This review is from: Microsoft OLAP Unleashed with CDROM (Paperback)

I have several books on data warehousing and OLAP, most of which I find to be too theoretical and lacking the basic recipes and plans for developing OLAP cubes. I found this book's descriptions and strategies for multidimensional modeling to be excellent.

This book also provides the best published information on DTS that I have found.

12 of 13 people found the following review helpful:

4.0 out of 5 stars Overall good, but not enough, April 29, 2000

By A Customer

This review is from: Microsoft OLAP Unleashed with CDROM (Paperback)

I read this book and the Wrox book on MS OLAP. The two books seem to complement each other with some overlaps of course. While this book has many good exmaples on DTS, MDX, and client access to OLAP data, the Wrox book is more organized and has better discussions of OLAP cubes and other aspects of DW as well as a better coverage of MDX. Maybe it is crazy, but it would have been a good idea if the authors of both books combined their efforts and produced one book (wishful thinking).