Short 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. This book shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services.
Long description
Professional SQL Server Analysis Services 2008 with MDX shows readers how to build sophisticated business intelligence solutions using SQL Server Analysis Services, along with SQL Server Integration Services and Reporting Services. The authors begin with an overview showing how Analysis Services and MDX can be used to build data warehouses and multi-dimensional databases. They then quickly move to a tutorial that describes the development process for building dimensions and cubes from various data sources. The authors next show how MDX can be used to query databases to provide sophisticated analysis of business problems. They will demonstrate a variety of techniques against real-world case scenarios. They will also show how Analysis Services can be used with other components of SQL Server, including Integration Services, Reporting Services, and Data Mining to provide comprehensive, end-to-end solutions. The 2008 book will be nearly 50ew and revised to cover new features and enhancements, including: Improved integration with Office and Excel 2007 Query performance enhancements Improvements to aggregation designer, dimension designer, cube and dimension wizards, cell writeback Extensibility and personalization Data mining New features such as Extensibility support, and possibly read-only databases Extensive changes and enhancements in the SQL Server Analysis Services Tools in Business Intelligence Development Studio / SQL Server Management Studio.