Professional Microsoft SQL Server analysis services 2008 with MDX

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 beused 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 canbe 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 willbe nearly 50% new 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.

• ISBN: 978-0-470-24798-3
• Editorial: John Wiley & Sons
• Encuadernacion: Rústica
• Páginas: 1056
• Fecha Publicación: 13/03/2009
• Nº Volúmenes: 1
• Idioma: Inglés