Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling [Paperback]

Teo Lachev (Author)

Book Description

Publication Date: February 16, 2012

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 www.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

Editorial Reviews

About the Author

Teo Lachev (MVP, MCSD, MCT, MCITP) is a consultant, author, and mentor, with a focus on Microsoft Business Intelligence. His Atlanta-based company "Prologika" helps organizations make sense of data by effectively applying Microsoft Business Intelligence technologies. Teo has authored and co-authored several SQL Server Business Intelligence books and he has been leading the Atlanta Business Intelligence group. Microsoft has recognized Teo's experience in Business Intelligence and contributions to the technical community by awarding him the Microsoft Most Valuable Professional (MVP) status for six years.

Product Details

• Paperback: 416 pages
• Publisher: Prologika Press (February 16, 2012)
• Language: English
• ISBN-10: 0976635356
• ISBN-13: 978-0976635352
• Product Dimensions: 7 x 1.2 x 9.1 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #451,672 in Books (See Top 100 in Books)

More About the Author

Teo Lachev, MVP (SQL Server), MCSD, MCT, is a developer, author, and mentor with a focus on Microsoft Business Intelligence. Through his company, Prologika (www.prologika.com), he helps organizations make sense of data by applying the latest Business Intelligence technologies for reporting, multi-dimensional analysis, and data mining. Teo lives with his family in Atlanta, Georgia.

Most Helpful Customer Reviews

2 of 2 people found the following review helpful

5.0 out of 5 stars Great book for learning the new tabular model in SSAS April 1, 2012

By Robert

Format:Paperback

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.

1 of 1 people found the following review helpful

5.0 out of 5 stars If you want to buy only one PowerPivot/SSAS Tabular Book, this is it May 29, 2012

By Rob Kerr

Format:Paperback

It's not easy to find a technical book that provides an accessible introduction to a new technology while also including the necessary details to thoroughly understand and deploy it. This book is the rare find that accomplishes both.

The title contains the word "Applied", and the book delivers on this promise. It teaches how to design and use Tabular models using SQL Server 2012, how to use DAX and how to design Power View reports. But it also provides excellent guidance on how various techniques, tools and deployment strategies should best be applied in personal, workgroup and enterprise scenarios.

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.

0 of 1 people found the following review helpful

5.0 out of 5 stars Authoritative and the best to get from zero to hero May 19, 2012

By Alejandro Leguizamo

Format:Paperback

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.

He tenido la posibilidad de leer los libros de Teo a lo largo de los años, y son siempre una fuente de conocimiento, detallados y sobretodo, útiles. este no es una excepción, y mantiene el nivel de la tradición con la alta calidad que uno espera. Teo es uno de los autores que suelo recomendar cuando en mis charlas o conferencias alguien me pregunta por un libro completo acerca de las tecnologias de BI Microsoft.Si a este libro le agregas el de Alberto y Marco acerca de DAX , estarás preparado para divertirte con SQL 2012