Professional Microsoft Sql Server Analysis Services 2008 With Mdx - Tapa blanda

The book 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 demonstrate a variety of techniques against real-world case scenarios and 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. Part i: introduction. Part ii: advanced topics. Part iii: advanced administration and performance optimization. Part iv: integration with microsoft products. Part v: scenarios.