Microsoft SQL Server 2012 Analysis Services The BISM Tabular Model

by ; ;
  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 7/15/2012
  • Publisher: Microsoft Press
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $59.99 Save up to $2.40
  • eBook
    Add to Cart


Supplemental Materials

What is included with this book?

  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


Create Business Intelligence (BI) solutions with the Business Intelligence Semantic Model (BISM) Tabular model-and discover a simpler method for analyzing business data. Led by three BI experts, you'll learn how to use several BISM tools, such as the Vertipaq in-memory storage engine, the DAX programming language, and the semantic model that enables data navigation. Whether you're experienced with the BISM Multidimensional model or a SQL Server developer new to Analysis Services, this book is the ideal way to get started with the BISM Tabular model. Topics include: BISM architecture Loading data inside the tabular model Basics of the DAX language Understanding evaluation contexts Querying tabular Understanding time intelligence in DAX

Author Biography

Alberto Ferrari is a Business Intelligence consultant whose two main interests are in a methodological approach to the BI development lifecycle, and performance tuning of ETL and SQL code. His activities are related to designing and implementing solutions based on Integration Services and Analysis Services for the financial, manufacturing and statistical areas. He is also a book author and a speaker in international conferences such as PASS Summit, SQLRally and SQLBits. Alberto holds an SSAS Maestro certification.

Table of Contents

Introducing the Tabular Model
Getting Started with the Tabular Model
Loading Data Inside Tabular
DAX Basics
Understanding Evaluation Context
Querying Tabular
DAX Advanced
Understanding Time Intelligence in DAX
Understanding xVelocity and DirectQuery
Building Hierarchies
Data Modeling in Tabular
Using Advanced Tabular Relationships
The Tabular Presentation Layer
Tabular and PowerPivot
Interfacing with Tabular
Tabular Deployment
Optimizations and Monitoring
DAX Functions Reference
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review