Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

by Sivakumar Harinath
Released October 2012
Publisher(s): Wrox
ISBN: 9781118101100

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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

  1. Cover
  2. Part I: Introduction
    1. Chapter 1: Introduction
      1. BISM Multidimensional Mode
      2. BISM Tabular Mode
      3. SQL Server Analysis Services 2012
      4. Summary
  3. Part II: Designing Multidimensional BISM
    1. Chapter 2: A First Look at Multidimensional BISM
      1. Development, Administrative, and Client Tools
      2. Upgrading to Analysis Services 2012
      3. Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications
      4. Using SQL Server Management Studio
      5. Querying Using the MDX Query Editor
      6. Summary
    2. Chapter 3: Understanding MDX
      1. What Is MDX?
      2. MDX Concepts
      3. MDX Queries
      4. MDX Expressions
      5. MDX Operators
      6. MDX Functions
      7. MDX Scripts
      8. Restricting Cube Space/Slicing Cube Data
      9. Parameterized MDX Queries
      10. MDX Comments
      11. Summary
    3. Chapter 4: Data Sources and Data Source Views
      1. Data Sources
      2. Data Source Views
      3. Data Source Views in Depth
      4. Multiple Data Sources Within a DSV
      5. Summary
    4. Chapter 5: Dimension Design
      1. Working with the Dimension Wizard
      2. Working with the Dimension Designer
      3. Browsing the Dimension
      4. Sorting Members of a Level
      5. Optimizing Attributes
      6. Defining Translations in Dimensions
      7. Creating a Snowflake Dimension
      8. Creating a Time Dimension
      9. Creating a Parent-Child Hierarchy
      10. Summary
    5. Chapter 6: Cube Design
      1. The BISM Multidimensional mode
      2. Creating a Cube Using the Cube Wizard
      3. Cube Dimensions
      4. Measures and Measure Groups
      5. Calculated Members
      6. Creating Perspectives
      7. Creating Translations
      8. Browsing Perspectives and Translations
      9. Summary
    6. Chapter 7: Administration and Management
      1. Administration Using SQL Server 2012 Tools
      2. Online Mode
      3. Programmatic and Advanced Administration
      4. Analysis Management Objects (AMO)
      5. Resource and Activity Monitoring
      6. HTTP Connectivity to Analysis Services
      7. Analysis Services and FailOver Clustering
      8. Summary
  4. Part III: Advanced Topics in BISM
    1. Chapter 8: Advanced Dimension Design
      1. Custom Rollups
      2. Enhancements to Parent-Child Hierarchies
      3. Using Properties to Customize Dimensions
      4. Dimension Intelligence Using the Business Intelligence Wizard
      5. Server Time Dimension
      6. Dimension Writeback
      7. Summary
    2. Chapter 9: Advanced Cube Design
      1. Measure Groups and Measures
      2. Adding and Enhancing Dimensions
      3. Adding Calculations to Your Cube
      4. Key Performance Indicators (KPIS)
      5. Drillthrough
      6. Actions
      7. Adding Intelligence to the Cube
      8. Working with Partitions
      9. Real-Time Cubes
      10. Defining Security
      11. Cell Writeback
      12. AMO Warnings
      13. Summary
    3. Chapter 10: Designing Mulitdimensional BISM for Performance
      1. Optimizing Multidimensional BISM Design
      2. Optimizing for Processing
      3. Designing Aggregations
      4. Managing Aggregation Designs
      5. Scalability Optimizations
      6. Summary
    4. Chapter 11: Optimizing Query Performance
      1. How OLAP Enhances Performance
      2. The Calculation Model
      3. Query Execution Architecture
      4. Performance Analysis and Tuning Tools
      5. Analyzing Query Performance Issues
      6. Query Optimization Techniques
      7. Scale Out with Read-Only Database
      8. Writeback Query Performance
      9. Summary
    5. Chapter 12: Data Mining, Multidimensional BISM, and Data Mining Add-ins for Office 2010
      1. The Data Mining Process
      2. Real-World Applications
      3. Data Mining Algorithms in SQL Server Analysis Services 2012
      4. Working with Mining Models
      5. Using Data Mining with Office 2010
      6. Summary
    6. Chapter 13: SQL Integration Services and SQL Server Reporting Services with Multidimensional BISM Models
      1. SQL Server Integration Services
      2. SQL Server Reporting Services
      3. Summary
    7. Chapter 14: Securing Multidimensional BISM
      1. Securing Your Source Data
      2. Securing Your Dimension Data
      3. Securing Your Cube Data
      4. Summary
  5. Part IV: PowerPivot and Tabular BISM
    1. Chapter 15: Self-Service Business Intelligence and Introduction to PowerPivot
      1. SQL Server 2012
      2. Self-Service Business Intelligence
      3. PowerPivot: Microsoft's Implementation of SSBI
      4. Summary
    2. Chapter 16: A First Look at Tabular BISM
      1. Tabular Mode Projects in SSDT
      2. Creating a Tabular Project Using SQL Server Data Tools
      3. Importing Data
      4. The Tabular Designer
      5. Relationships
      6. Adding Calculations to Your Tabular Model
      7. Browsing the Model
      8. Modeling and Deploying
      9. Administering Your Tabular Model Using SSMS
      10. Summary
    3. Chapter 17: Enhancing Your Tabular BISM
      1. Sourcing Data for Your Model
      2. Refining Your Tabular Model
      3. Enhancing Your Model with Hierarchies
      4. Enhancing Measures
      5. Creating KPIs
      6. Creating Perspectives
      7. Creating Partitions
      8. Processing a Tabular Database
      9. Creating and Applying Security Roles
      10. Summary
    4. Chapter 18: Introduction to DAX
      1. Sample Data
      2. DAX Fundamental Concepts
      3. DAX Operators and Blank Values
      4. DAX Function Categories with Examples
      5. DAX as a Query Language
      6. DAX and MDX
      7. Summary
    5. Chapter 19: Advanced Topics in DAX
      1. Parent-Child Hierarchies
      2. Cross-Filtering with Many-to-Many Relationships
      3. Multiple Relationships Between Tables
      4. Time-Based Analysis
      5. Non-Aggregatable Columns
      6. Summary
    6. Chapter 20: Analyzing Multidimensional and Tabular BISMs In Excel
      1. Analyzing Data in Excel 2010
      2. Summary
    7. Chapter 21: PowerPivot for SharePoint
      1. SharePoint 2010
      2. Key Servers in PowerPivot for SharePoint
      3. Key Services in PowerPivot for SharePoint
      4. Services Architecture Workflow Scenarios
      5. What's New
      6. PowerPivot for SharePoint
      7. Optional Setup Steps
      8. BI Appliances
      9. Summary
  6. Part V: Advanced Topics with Tabular BISM and Integration with PowerView
    1. Chapter 22: Introduction and Configuration of Power View
      1. Reporting Services Power View
      2. Installing Reporting Services for SharePoint
      3. Preparing Model Connection for Power View Tutorial
      4. Configuring Data Source Connections
      5. Summary
    2. Chapter 23: Visual Analytics with Power View
      1. Introduction to Power View
      2. Visual Analytics with Power View
      3. Summary
  7. Introduction
  8. Advertisements

Product information

  • Title: Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
  • Author(s): Sivakumar Harinath
  • Release date: October 2012
  • Publisher(s): Wrox
  • ISBN: 9781118101100