Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling

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 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 ModelPART I: PERSONAL BI WITH POWERPIVOT FOR EXCELChapter 2: Personal BI BasicsChapter 3: Importing DataChapter 4: Refining the ModelChapter 5: Analyzing DataChapter 6: Implementing CalculationsPART II: TEAM BI WITH POWERPIVOT FOR SHAREPOINTChapter 7: Team BI BasicsChapter 8: SharePoint InsightsChapter 9: Managing PowerPivot for SharePointPART III: ORGANIZATIONAL BI WITH ANALYSIS SERVICES TABULARChapter 10: Organizational BI BasicsChapter 11: Designing Storage and SecurityChapter 12: Managing Tabular Models

Author: Teo Lachev

Learn more