Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
- 16h 14m
- Denny Guang-Yeu Lee, John Sirmon, Robert M. Bruckner, Ronald Pihlgren, Sivakumar Harinath
- John Wiley & Sons (US)
- 2012
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.
About the Authors
Sivakumar Harinath is a senior program manager with the SQL Server Analysis Services team.
Ronald Pihlgren is a senior tester with the SQL Server Analysis Services team.
Denny Guang-Yeu Lee is a principal program manager with the SQL Customer Advisory Team.
John Sirmon is a senior program manager with the SQL Server Customer Advisory Team at Microsoft.
Robert M. Bruckner is a principal architect with the SQL Server Reporting Services team.
In this Book
-
Introduction
-
A First Look at Multidimensional BISM
-
Understanding MDX
-
Data Sources and Data Source Views
-
Dimension Design
-
Cube Design
-
Administration and Management
-
Advanced Dimension Design
-
Advanced Cube Design
-
Designing Mulitdimensional BISM for Performance
-
Optimizing Query Performance
-
Data Mining, Multidimensional BISM, and Data Mining Add-ins for Office 2010
-
SQL Integration Services and SQL Server Reporting Services with Multidimensional BISM Models
-
Securing Multidimensional BISM
-
Self-Service Business Intelligence and Introduction to PowerPivot
-
A First Look at Tabular BISM
-
Enhancing Your Tabular BISM
-
Introduction to DAX
-
Advanced Topics in DAX
-
Analyzing Multidimensional and Tabular BISMs in Excel
-
PowerPivot for SharePoint
-
Introduction and Configuration of Power View
-
Visual Analytics with Power View
