Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

1. Auflage 2012
ISBN: 978-1-118-10110-0
Verlag: John Wiley & Sons Inc

Buch, Englisch, 1176 Seiten, Format (B × H): 192 mm x 238 mm, Gewicht: 1936 g

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.

Autoren/Hrsg.

Harinath, Sivakumar

Pihlgren, Ronald

Lee, Denny Guang-Yeu

Sirmon, John

Bruckner, Robert M.

Inhaltsverzeichnis

INTRODUCTION xxxv
PART I: INTRODUCTION
CHAPTER 1: INTRODUCTION 3
PART II: DESIGNING MULTIDIMENSIONAL BISM
CHAPTER 2: A FIRST LOOK AT MULTIDIMENSIONAL BISM 25
CHAPTER 3: UNDERSTANDING MDX 65
CHAPTER 4: DATA SOURCES AND DATA SOURCE VIEWS 103
CHAPTER 5: DIMENSION DESIGN 129
CHAPTER 6: CUBE DESIGN 173
CHAPTER 7: ADMINISTRATION AND MANAGEMENT 209
PART III: ADVANCED TOPICS IN BISM
CHAPTER 8: ADVANCED DIMENSION DESIGN 269
CHAPTER 9: ADVANCED CUBE DESIGN 315
CHAPTER 10: DESIGNING MULITDIMENSIONAL BISM FOR PERFORMANCE 419
CHAPTER 11: OPTIMIZING QUERY PERFORMANCE 479
CHAPTER 12: DATA MINING, MULTIDIMENSIONAL BISM, AND DATA MINING ADD-INS FOR OFFICE 2010 513
CHAPTER 13: SQL INTEGRATION SERVICES AND SQL SERVER REPORTING SERVICES WITH MULTIDIMENSIONAL
CHAPTER 14: SECURING MULTIDIMENSIONAL BISM 671
PART IV: POWERPIVOT AND TABULAR BISM
CHAPTER 15: SELF-SERVICE BUSINESS INTELLIGENCE AND INTRODUCTION TO POWERPIVOT 719
CHAPTER 16: A FIRST LOOK AT TABULAR BISM 741
CHAPTER 17: ENHANCING YOUR TABULAR BISM 773
CHAPTER 18: INTRODUCTION TO DAX 813
CHAPTER 19: ADVANCED TOPICS IN DAX 867
CHAPTER 20: ANALYZING MULTIDIMENSIONAL AND TABULAR BISMS IN EXCEL 907
CHAPTER 21: POWERPIVOT FOR SHAREPOINT 969
PART V: ADVANCED TOPICS WITH TABULAR BISM AND INTEGRATION WITH POWER VIEW
CHAPTER 22: INTRODUCTION AND CONFIGURATION OF POWER VIEW 999
CHAPTER 23: VISUAL ANALYTICS WITH POWER VIEW 1031
INDEX 1077

Über Autor(innen)

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.