Book description
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.
Table of contents
- Cover
- Part I: Introduction
- Part II: Designing Multidimensional BISM
-
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
- Introduction
- Advertisements
Product information
- Title: Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
- Author(s):
- Release date: October 2012
- Publisher(s): Wrox
- ISBN: 9781118101100
You might also like
book
SQL Server Analysis Services 2012 Cube Development Cookbook
If you prefer the instructional approach to a lot of theory, this cookbook is for you. …
book
Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
Build agile and responsive Business Intelligence solutions Analyze tabular data using the BI Semantic Model (BISM) …
book
The Microsoft® Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft® Business Intelligence Toolset, Second Edition
Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse …
book
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, …