- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
* When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.* Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions* Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more
Contents
Introduction. Part IWarehousing and SQL Server 2008 Analysis Services. Chapter 2: First Look at Analysis Services 2008. Chapter 3: Introduction to MDX. Chapter 4: Working with Data Sources and Data Source Views. Chapter 5: Dimension Design. Chapter 6: Cube Design. Chapter 7: Administering Analysis Services. Part II: Advanced Topics. Chapter 8: Advanced Dimension Design. Chapter 9: Advanced Cube Design. Chapter 10: Advanced Topics in MDX. Chapter 11: Extending MDX Using External Functions. Chapter 12: Data Writeback. Part III: Advanced Administration and Performance Optimization. Chapter 13: Programmatic and Advanced Administration. Chapter 14: Designing for Performance. Chapter 15: Analyzing and Optimizing Query Performance. Part IV: Integration with Microsoft Products. Chapter 16: Data Mining. Chapter 17: Analyzing Cubes Using Microsoft Office Components. Chapter 18: Using Data Mining with Office 2007. Chapter 19: Integration Services. Chapter 20: Reporting Services. Part V: Scenarios. Chapter 21: Designing Real-Time Cubes. Chapter 22: Securing Your Data in Analysis Services. Chapter 23: Inventory Scenarios. Chapter 24: Financial Scenarios. Chapter 25: Web Analytics. Appendix A: MDX Functions. Index.
