Microsoft? OLAP Solutions
| Author | : | |
| Rating | : | 4.13 (621 Votes) |
| Asin | : | 0471332585 |
| Format Type | : | paperback |
| Number of Pages | : | 528 Pages |
| Publish Date | : | 2015-03-05 |
| Language | : | English |
DESCRIPTION:
His e-mail address is erik@dsslab. DICK CHASE is a Senior Consultant for Decision Support Technology (a part of the Condor Technology Solutions family) and has developed numerous decision support solutions for clients in such industries as retail, healthcare, insurance, and financial services. GEORGE SPOFFORD is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of
It offers good wizards and tools to simplify creation and maintenance of a data warehouse. 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. Database (DB) analysts know that Microsoft OLAP is the proverbial new kid on the block when it comes to data warehousing. 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. --Richard DraganTopics
"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(r) OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Practical. Topics covered in detail include: * The storage and operational architecture of Microsoft OLAP server * Using the MDX language with Microsoft OLAP server * Using Microsoft OLAP server to access and update data * Specifying calculations * Optimizing server performance * Securing the server On the CD-ROM you'll find: * All the sample applications and databases described in the book * Additional software for working with Microsoft OLAP server Wiley Computer Publishing Timely. Visit
A Customer said OLAP for the elite. This book is for programmers with substantial experience with OLAP tools with syntactical development capabilities. Experienced programmers who may not have used OLAP technology but who have a good grasp of advanced technical issues related to report generation will benefit from the book too.The book is written in a dense academic style with poor organization. (You will see this right away in their first chapter when they start discussing more esoteric design issues while giving the reader minimal context as to why they bring up these points at that time.) However, the authors know their stuff. Martin Harwar said Essential (and I mean Essential) reading!. Warehousing has been around for years, but many professionals will be interested in the new Microsoft OLAP cubes for ultimate performance. This book clearly and unambiguously describes what they are, how to design them and then (most importantly at this time) how to use them. For traditional data warehouse professionals, the idea of an OLAP cube may not be easy to grasp - I teach the Microsoft official courses on the subject and it never comes easy to the student. However, this book does a good job of explaining the concepts of Dimensions, Measures, Facts, Members, etc If, like another reviewe. A Customer said Great book from the gurus. This book is what you really want if you are serious about developing using Microsoft Analysis Services. Today with Microsoft Analysis Services ranking as the most widely implemented OLAP/analysis solution this is the best source to get started on Microsoft OLAP services from none other than Erik Thomsen the OLAP guru and George Spofford. The authors were kind enough to answer readers queries by email that makes a big difference to somebody getting into a new technology. The book points the strengths and limitations thereby preparing you to have workarounds for the limitations. I rate 5 stars