OLAP Solutions: Building Multidimensional Information Systems by Erik Thomsen  (21)
$65.85
|
MDX Solutions: With Microsoft SQL Server Analysis Services by George Spofford  (11)
$34.99
|
The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy  (18)
$43.95
|
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) by Ralph Kimball (26)
$52.51
|
The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses by Ralph Kimball (49)
$60.61
|
This item is not eligible for Amazon Prime, but millions of other items are. Join Amazon Prime today. Already a member? Sign in.
Customers Who Bought This Item Also Bought
Editorial Reviews
Amazon.com Review
Written for analysts who have at least some previous experience with data warehousing, Microsoft OLAP Solutions provides a working guide to analyzing legacy data with the new Microsoft online analytical processing (OLAP) Services. This book assumes you understand the fundamentals of what data warehousing is and how it works; if you do, this guide masterfully presents the strengths (and limitations) of OLAP technology.
Written for analysts who have at least some previous experience with data warehousing, Microsoft OLAP Solutions provides a working guide to analyzing legacy data with the new Microsoft online analytical processing (OLAP) Services. This book assumes you understand the fundamentals of what data warehousing is and how it works; if you do, this guide masterfully presents the strengths (and limitations) of OLAP technology.
Database (DB) analysts know that Microsoft OLAP is the proverbial new kid on the block when it comes to data warehousing. It offers good wizards and tools to simplify creation and maintenance of a data warehouse. While the authors of Microsoft OLAP Solutions dutifully explain some of the technical terminology related to OLAP (like cubes and dimensions) and design, many readers will likely seize on the chapters that examine actually using OLAP wizards and tools for building warehouses. Moreover, the reference to MDX (OLAP's data-analysis language) will be invaluable here.
This book presents some warehousing theory first, and then it focuses on specifics, including two excellent case studies (for analyzing databases for health care and a grocery store) at the end of the book. It also offers chapters on implementing changes and optimizing OLAP databases once they are up and running.
There's little doubt that with the weight of Microsoft behind it, OLAP will be a reasonable option for many corporate data warehouses. This book gives you all the information you need to apply your data warehouse knowledge to this new Microsoft platform. --Richard Dragan
Topics covered: Microsoft OLAP, datahouse warehousing design, dimensions and cubes, pure OLAP (MOLAP), relational OLAP (ROLAP), hybrid OLAP (HOLAP), Multidimensional Expressions (MDX), maintenance, and optimization.
Product Description
The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services.--Bill Baker, Microsoft Corporation. Microsoft OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application a