Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling

by Teo Lachev, Edward Price (Editor)

An insightful tour that provides an authoritative yet independent view of this exciting technology, this guide introduces the Tabular side of the innovative Business Intelligence Semantic Model (BISM) that promotes rapid professional and self-service BI. Business analysts and power users will learn how to integrate data from multiple data sources, implement personal BI applications with Excel, and deploy them to SharePoint. BI professionals and database administrators will discover how to build Tabular models that deliver supreme performance with large data volumes, and how to implement a wide range of solutions for the entire spectrum of personal-team-organizational BI needs. Ideal for experienced BI professionals and beginners, this book features step-by-step instructions and demos for integrating data from various data sources and gaining insights from the data in reports and dashboards.

Visit the book’s website at prologika.com for sample chapters, source code, a discussion forum (with personal support from the author), and online video tutorials.

WHAT'S INSIDE:
Chapter 1: Introducing Business Intelligence Semantic Model

PART I: PERSONAL BI WITH POWERPIVOT FOR EXCEL
Chapter 2: Personal BI Basics
Chapter 3: Importing Data
Chapter 4: Refining the Model
Chapter 5: Analyzing Data
Chapter 6: Implementing Calculations

PART II: TEAM BI WITH POWERPIVOT FOR SHAREPOINT
Chapter 7: Team BI Basics
Chapter 8: SharePoint Insights
Chapter 9: Managing PowerPivot for SharePoint

PART III: ORGANIZATIONAL BI WITH ANALYSIS SERVICES TABULAR
Chapter 10: Organizational BI Basics
Chapter 11: Designing Storage and Security
Chapter 12: Managing Tabular Models

649 pages, Kindle Edition

First published December 1, 2011