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