Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model

by Marco Russo and Alberto Ferrari

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:

Genres: Bisexual

656 pages, Paperback

First published May 22, 2012

Reviews

[Jamie Belanger · Rating 3 out of 5]

I finished this a couple years ago. Wasn't easy... it's definitely a textbook, and while there's tons of interesting info in here, not much applies to my job so I doubt I'll ever use this knowledge.

[Ron Pihlgren · Rating 5 out of 5]

Hands down the best book for those who want in-depth understanding of the Analysis Services BISM Tabular Model. The authors have done a great job of researching, understanding, and explaining how the Tabular Model works and how to work with it. Their coverage is comprehensive:

-Setting up the development environment
-Loading data
-DAX (especially good coverage here)
-Querying
-Direct query mode
-Working with relationships, hierarchies
-Power View and PowerPivot
-Security
-Programmatic access to tabular models
-Processing approaches
-Optimizing for performance and memory footprint
-Monitoring

If you work with the Analysis Services Tabular Model in any degree of depth this book is a must have.