9780735658189

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

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.

Foreword
Introduction
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
Security
Interfacing with Tabular
Tabular Deployment
Optimizations and Monitoring
DAX Functions Reference
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are 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.

Amazon no longer offers textbook rentals. We do!

Microsoft SQL Server 2012 Analysis Services The BISM Tabular Model

Microsoft SQL Server 2012 Analysis Services The BISM Tabular Model

0735658188

Summary

Author Biography

Table of Contents

Supplemental Materials