Professional Microsoft SQL Server 2012 Analysis Services With MDX and DAX

Professional sql server 2012 analysis services with mdx and dax shows readers how to build sophisticated business intelligence solutions using sql server analysis services, along with sql server integration and reporting services. The authors begin with an overview showing how analysis services 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 show how mdx and the more simplified version of mdx, dax, 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 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.