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 AnalysisServices* 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 PivotTable Service for client-side data analysisNote: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
Autorentext
Mike Gunderloy is an internationally recognized database developer and is the coauthor of the best-selling Mastering SQL Server 2000 and Access Developer's Handbook. He also wrote Visual Basic Developer's Guide to ADO.
Tim Sneath, an MCSD and MCSE, has worked on many OLAP Services projects. He works part-time for Microsoft's U.K. community development team, presenting at seminars across the country. He has been a regular speaker at TechEd, Developer Days, and the Software Developer conference.
Klappentext
The Skills You Need to Develop OLAP Solutions with SQL Server 2000
This one-of-a-kind book teaches you everything you need to know to use Microsoft's Analysis Services software to build, implement, and manage effective OLAP solutions. Expert advice and in-depth explanations combine to help you and your company take full advantage of the affordable power of SQL Server’s built-in OLAP functionality.
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 OLAP data
- Choosing appropriate client tools for exploring OLAP data
- Using the PivotTable Service for client-side data analysis
Inhalt
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/MD Part I: Cube Schema Objects.
Chapter 8: Building OLAP Services Applications with ADO/MD Part II: Query Retrieval Objects.
Chapter 9: Advanced Usage of the PivotTable 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.