Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

Understand Microsoft’s dramatically updated new release of its premier toolset for business intelligence

The first major update to Microsoft’s state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the product’s development team? If you’re a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft’s new SQL Server 2012 Analysis Services and related tools.

Discover how to solve real-world BI problems by leveraging a slew of powerful new Analysis Services features and capabilities. These include the new DAX language, which is a more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsoft’s new Business Intelligence Semantic Model; and much more.

• Serves as an authoritative guide to Microsoft’s new SQL Server 2012 Analysis Services BI product and is written by key members of the Microsoft Analysis Services product development team
• Covers SQL Server 2012 Analysis Services, a major new release with a host of powerful new features and capabilities
• Topics include using the new DAX language, a simplified, more user-friendly version of MDX; PowerPivot, a new tool for performing simplified analysis of data; BISM, Microsoft’s new Business Intelligence Semantic Model; and a new, yet-to-be-named BI reporting tool
• Explores real-world scenarios to help developers build comprehensive solutions

Get thoroughly up to speed on this powerful new BI toolset with the timely and authoritative Professional Microsoft SQL Server 2012 Analysis Services with MDX.

From the Back Cover
Get up to speed on the premier business intelligence toolset

SQL Server 2012 is packed with powerful new Analysis Services features that will dramatically enhance business intelligence. Written by key members of Microsoft’s product team, this book shows you how to apply these new capabilities to create sophisticated BI solutions. In order to accomplish this, you’ll learn how to design, build, and work with the multidimensional and tabular Business Intelligence Semantic Model (BISM) using SQL Server Analysis Services. You’ll then use MDX and DAX to query those databases so you can provide advanced analysis of business problems and build end-to-end solutions to meet your needs.

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX:

• Shows how to utilize SQL Server Data Tools to build Analysis Services multidimensional and tabular databases
• Shares fundamental concepts of DAX and MDX and dives into advanced concepts such as parent-child hierarchies and time-based analysis
• Demonstrates methods for analyzing and optimizing DAX and MDX query performance
• Describes how to use Excel 2010 in conjunction with Analysis Services to analyze data and effectively use PowerPivot® for SharePoint®
• Explains Power View setup and configuration and presents real-world scenarios to help simplify reporting

Table of Contents
Part I: Introduction
Chapter 1. Introduction

Part II: Designing Multidimensional BISM
Chapter 2. A First Look at Multidimensional BISM
Chapter 3. Understanding MDX
Chapter 4. Data Sources and Data Source Views
Chapter 5. Dimension Design
Chapter 6. Cube Design
Chapter 7. Administration and Management

Part III: Advanced Topics in BISM
Chapter 8. Advanced Dimension Design
Chapter 9. Advanced Cube Design
Chapter 10. Designing Mulitdimensional BISM for Performance
Chapter 11. Optimizing Query Performance
Chapter 12. Data Mining, Multidimensional BISM, and Data Mining Add-ins for Office 2010
Chapter 13. SQL Integration Services and SQL Server Reporting Services with Multidimensional BISM Models
Chapter 14. Securing Multidimensional BISM

Part IV: PowerPivot and Tabular BISM
Chapter 15. Self-Service Business Intelligence and Introduction to PowerPivot
Chapter 16. A First Look at Tabular BISM
Chapter 17. Enhancing Your Tabular BISM
Chapter 18. Introduction to DAX
Chapter 19. Advanced Topics in DAX
Chapter 20. Analyzing Multidimensional and Tabular BISMs In Excel
Chapter 21. PowerPivot for SharePoint

Part V: Advanced Topics with Tabular BISM and Integration with PowerView
Chapter 22. Introduction and Configuration of Power View
Chapter 23. Visual Analytics with Power View

Book Details

• Paperback: 1176 pages
• Publisher: Wrox (October 2012)
• Language: English
• ISBN-10: 1118101103
• ISBN-13: 978-1118101100