Book description
Build agile and responsive Business Intelligence solutions
Analyze tabular data using the BI Semantic Model (BISM) in Microsoft SQL Server 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model’s in-memory database enables you to perform rapid analytics—whether you’re a professional BI developer new to Analysis Services or familiar with its multidimensional model.
Discover how to:
Determine when a tabular or multidimensional model is right for your project
Build a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2010
Integrate data from multiple sources into a single, coherent view of company information
Use the Data Analysis eXpressions (DAX) language to create calculated columns, measures, and queries
Choose a data modeling technique that meets your organization’s performance and usability requirements
Optimize your data model for better performance with xVelocity storage engine
Manage complex data relationships, such as multicolumn, banding, and many-to-many
Implement security by establishing administrative and data user roles
Table of contents
- Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
- Dedication
- A Note Regarding Supplemental Files
- Foreword
- Introduction
- 1. Introducing the Tabular Model
- 2. Getting Started with the Tabular Model
-
3. Loading Data Inside Tabular
- Understanding Data Sources
- Understanding Impersonation
- Understanding Server-Side and Client-Side Credentials
- Working with Big Tables
- Loading from SQL Server
- Opening Existing Connections
- Loading from Access
- Loading from Analysis Services
- Loading from an Excel File
- Loading from a Text File
- Loading from the Clipboard
- Loading from a Reporting Services Report
- Loading from a Data Feed
- Loading from SharePoint
- Loading from the Windows Azure DataMarket
- Choosing the Right Data-Loading Method
- Understanding Why Sorting Data Is Important
- Summary
- 4. DAX Basics
-
5. Understanding Evaluation Context
- Evaluation Context in a Single Table
- Understanding the EARLIER Function
- Understanding Evaluation Context in Multiple Tables
- Summary
-
6. Querying Tabular
- Tools for Querying Tabular
- DAX Query Syntax
- Using CALCULATETABLE and FILTER
- Using ADDCOLUMNS
- Using SUMMARIZE
- Using CROSSJOIN, GENERATE, and GENERATEALL
- Using ROW
- Using CONTAINS
- Using LOOKUPVALUE
- Defining Measures Inside a Query
- Parameters in DAX Query
- Querying by Using MDX
- Choosing Between DAX and MDX
- Summary
- 7. DAX Advanced
- 8. Understanding Time Intelligence in DAX
-
9. Understanding xVelocity and DirectQuery
- Tabular Model Architecture in Analysis Services 2012
- In-Memory Mode and xVelocity
- Using DirectQuery and Hybrid Modes
- Summary
- 10. Building Hierarchies
- 11. Data Modeling in Tabular
- 12. Using Advanced Tabular Relationships
- 13. The Tabular Presentation Layer
- 14. Tabular and PowerPivot
- 15. Security
- 16. Interfacing with Tabular
- 17. Tabular Deployment
- 18. Optimizations and Monitoring
- A. DAX Functions Reference
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
- Author(s):
- Release date: July 2012
- Publisher(s): Microsoft Press
- ISBN: 9780735670099
You might also like
book
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business …
book
Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
Prepare for Microsoft Exam 70-778-and help demonstrate your real-world mastery of Power BI data analysis and …
book
Exam Ref 70-767 Implementing a SQL Data Warehouse
Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. …
book
Exam Ref AZ-900: Microsoft Azure Fundamentals, First Edition
Prepare for Microsoft Exam AZ-900–and help demonstrate your real-world mastery of cloud services and how they …