APPLIED MICROSOFT SQL SERVER 2012 ANALYSIS SERVICES
 (TABULAR MODELING)

book2Learn how to implement rapid solutions for personal, team, and organizational BI.

  • Publication date: 3/1/2012
  • Size: 416 pages, 7″ x 9 1/4″
  • Price: $49.95
  • ISBN 10: 0-9766353-5-6
  • ISBN 13: 978-0-9766353-5-2

Introduces the Tabular side of the innovative Business Intelligence Semantic Model (BISM) that promotes rapid professional and self-service BI application development.

Business analysts and power users will learn how to integrate data from multiple data sources, implement self-service BI applications with Excel, and deploy them to SharePoint. Business intelligence professionals and database administrators will discover how to build corporate solutions powered by BISM Tabular, delivering 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.


Synopsis

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 application development. Business analysts and power users will learn how to integrate data from multiple data sources, implement self-service BI applications with Excel, and deploy them to SharePoint. Business intelligence professionals and database administrators will discover how to build corporate solutions powered by BISM Tabular, delivering 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 or beginners, this book features step-by-step instructions and demos for building reports and dashboards, deploying and managing tabular models, and integrating data from various sources. The online video tutorials include over 3 hours of recorded content that demonstrates selected book exercises.


What’s inside

  • Implement personal BI models with PowerPivot for Excel
  • Share PowerPivot models and gain insights with PowerPivot for SharePoint
  • Implement scalable and secure organizational models with Analysis Services Tabular

Resources

Front matterSample chapter (Chapter 1)Errata
IndexSource codeOld Forum
Back coverVideo demos

Reviews

“This is a great book for getting up and running quickly with the new tabular data model available in SQL Server Analysis Services 2012. I was able to read this book fairly quickly, good for a busy IT Professional. The book covers PowerPivot, PowerView, and the various ways to create the new tabular projects. If you are looking for something that will cover all aspects of the new tabular abilities in SSAS 2012, I’d recommend this book without hesitation.”

Robert Cain
SQL Server MVP

“Many IT Professionals getting started with PowerPivot for Excel , PowerPivot for SharePoint or Analysis Services in Tabular mode will find this is the only book they need to launch their first successful Tabular project.”

Rob Kerr
SQL Server MVP

“I have had the chance to read Teo’s books over the years, and they happen to be insightful, detailed and more than anything, absolutely helpful. This one is no exception, and keeps the bar on tradition with the high quality you expect. Teo is one of those authors that I use to reference when after, one of my conferences, someone asks me for a good comprehensive book on Microsoft’s BI stack. Mix this one with Alberto and marco on DAX and you will be ready for some fun.”

Alejandro Leguizamo
SQL Server MVP

How to purchase

We don’t offer an e-book version of this book at this point.