The Skills You Need to Develop OLAP Solutions with SQL Server2000This one-of-a-kind book teaches you everything you need to knowto use Microsoft’s Analysis Services software to build, implement, and manage effective OLAP solutions. Expert advice and in-depthexplanations combine to help you and your company take fulladvantage of the affordable power of SQL Server’s built-in OLAPfunctionality.Coverage Includes:* Analyzing large volumes of data effectively with Analysis Services* Architecting and designing data analysis applications* Querying OLAP data using MDX* Programming applications using ADO/MD* Managing Analysis Services servers with DSO* Building data mining solutions with Analysis Services* Using English Query for natural language querying of OLAPdata* Choosing appropriate client tools for exploring OLAP data* Using the Pivot Table Service for client-side data analysis Note: CD-ROM/DVD and other supplementary materials arenot included as part of e Book file.
Inhaltsverzeichnis
Introduction.Chapter 1: OLAP and Data Mining Concepts.Chapter 2: Analysis Services Architecture.Chapter 3: Analysis Services Lifecycle.Chapter 4: Using Analysis Services.Chapter 5: Advanced Analysis Services.Chapter 6: Querying Analysis Services with MDX.Chapter 7: Building Analysis Services Applications with ADO/MDPart I: Cube Schema Objects.Chapter 8: Building OLAP Services Applications with ADO/MD Part II: Query Retrieval Objects.Chapter 9: Advanced Usage of the Pivot Table Service.Chapter 10: Managing an Analysis Services Environment Using DSO.Chapter 11: Building Data Mining Solutions with Analysis Services.Chapter 12: Supporting Natural Language Queries with English Query.Appendix A: MDX Reference.Appendix B: ADO/MD Object Model.Appendix C: DSO Object Model.Appendix D: English Query Object Model.Index.
Über den Autor
Mike Gunderloy is an internationally recognized databasedeveloper and is the coauthor of the best-selling Mastering SQLServer 2000 and Access Developer’s Handbook. He alsowrote Visual Basic Developer’s Guide to ADO.Tim Sneath, an MCSD and MCSE, has worked on many OLAPServices projects. He works part-time for Microsoft’s U.K.community development team, presenting at seminars across thecountry. He has been a regular speaker at Tech Ed, Developer Days, and the Software Developer conference.