- Shopping Bag ( 0 items )
From Barnes & Noble
The Barnes & Noble ReviewWith SQL Server 7.0, Microsoft delivered all the tools needed to start with OLAP and data warehousing—for an initial investment of under $2,000. In a marketplace used to multi-million-dollar data warehousing projects, this was a revolution. Of course, if you're a developer, there's the "minor" matter of mastering Microsoft's tools. Microsoft OLAP Unleashed will help you square away that detail.
The book starts by showing you what OLAP can accomplish in the real world, and presenting a "fly-over" perspective on Microsoft's OLAP tools. Next, prepare your data, mastering star schemas and Data Transformation Services (DTS), Microsoft's toolset for moving data, eliminating errors, and improving consistency.
In Part III, the authors introduce the OLAP Server, which offers a model for constructing multidimensional OLAP cubes—ROLAP, MOLAP, HOLAP, or all of the above. There's a very readable high-level introduction to OLAP cubes—as well as several chapters on delivering them through Microsoft Excel, web clients, and other means.
Microsoft Olap Unleashed contains four detailed chapters on Microsoft's Multidimensional Expressions (MDX) language for querying cubes; a detailed look at using Microsoft Repository to store metadata; chapters on performance, indexing, and security, and more. It's as thorough a guide to Microsoft-based OLAP as you can find.
Overview