Average Reviews:
(More customer reviews)This Step by Step guide serves as a great starting point for getting familiar with Microsoft's Analysis services. It starts with a quick introduction to data warehousing (without resorting to giving an entire history of the subject, as seems so common today) and how it relates to OLAP and then moves right into the Analysis Servies tools.
The chapters are well written and get you the information you need, without missing any major details. Even if you don't plan to take the "step by step" approach, this book is worth having by your side.
All right... now for the downsides. At best this book is good for beginners. These are some of the areas where I found it came up short:
- Sizing systems that will support Analysis Services. The book talks a bit about how big cubes are, but there is no information about cube performance/cube sizing, etc. Basically, this book won't help you develop a hardware plan for hosting Analysis Services.
- Accessing Analysis Services via the web. All of Microsoft's literature talks about how SQL Server 2000's great support for the web/XML. Strangely, it is very hard to find this information for Analysis Services, and this book doesn't provide any guidance. Right now it seems that the best you can do to find this information is hunt around Microsoft's site.
Overall I still think this is good book. However, if you are going to be building a large Analysis Services system, expect to be looking for other sources to answer all of your questions.
Click Here to see more reviews about: Microsoft® SQL Server(TM) 2000 Analysis Services Step by Step (DV-DLT Fundamentals)
MICROSOFT® SQL SERVER™ 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You'll discover why these services make it easier to analyze huge amounts of data quickly, and you'll learn how to develop a wide range of advanced dimensional-data applications-from enterprise reporting tools to advanced decision-support systems. The book's easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson.
This title shows you how to:
Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes.
Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors. Use Microsoft Excel PivotTable® Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office.
Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data.
Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
