You are previewing Pro SharePoint 2013 Business Intelligence Solutions.
O'Reilly logo
Pro SharePoint 2013 Business Intelligence Solutions

Book Description

To get ahead in today's hyper-competitive marketplace, your business has to take advantage of the data you already have and mine that data to give you new insight, metrics, and clues to what drives successful customer interactions. In Pro SharePoint 2013 Business Intelligence Solutions, you'll learn exactly how to unlock that magic, build business intelligence facilities on SharePoint, and glean insights from data to propel your business to the next level.

To understand the various business intelligence offerings in SharePoint 2013, you need to understand the core SQL Server business intelligence concepts, and the first part of the book presents a comprehensive tutorial on those fundamentals. Pro SharePoint 2013 Business Intelligence Solutions then focuses on specific SharePoint business intelligence investments including:

  • Visio Services

  • Excel Services

  • SQL Server Reporting Services

  • Business Connectivity Services

  • Power View and PerformancePoint Services

  • Authors Manpreet Singh, Sha Anandan, Sahil Malik, and Steve Wright walk you through all of this material comprehensively in practical, hands-on format, with plenty of examples to empower you to use these products in your real-life projects.

    As compelling as SharePoint and SQL Server business intelligence are together, the challenge always has been finding people who understand both SharePoint and SQL Server well enough to deliver such business intelligence solutions. With this book in hand, you become part of that select group. Get your copy of Pro SharePoint 2013 Business Intelligence Solutions today!

    Table of Contents

    1. Title Page
    2. Dedication
    3. Contents at a Glance
    4. Contents
    5. About the Authors
    6. About the Technical Reviewer
    7. Acknowledgments
    8. Introduction
    9. CHAPTER 1: Business Intelligence Basics
      1. What Will You Learn?
      2. Software Prerequisites
      3. Introduction to Business Intelligence
      4. Why Intelligence?
      5. Understanding BI
      6. OLTP vs. OLAP
      7. The BI Foundation
      8. Tools
      9. SQL Server 2012 Analysis Services Tabular Model
      10. SharePoint and Business Intelligence
      11. Summary
      12. What’s Next?
    10. CHAPTER 2: Visio Services
      1. What Will You Learn?
      2. Software Prerequisites
      3. Introduction to Visio Services
      4. Why Visio?
      5. Presenting Visio Services
      6. The Visio 2013 Client’s Data Tab
      7. Integrating Visio with SharePoint
      8. Secure Store Services
      9. Visio Services JavaScript Mashup API
      10. Working with SharePoint Designer 2013
      11. Creating Your Own Custom Data Providers
      12. Administration of Visio Services
      13. Summary
      14. What’s Next?
    11. CHAPTER 3: Reporting Services
      1. What Will You Learn in This Chapter?
      2. Software Prerequisites
      3. Introduction to Reporting Services
      4. Architecture
      5. Setting Up the Infrastructure
      6. Data Source Management
      7. Authoring Tools
      8. Building and Publishing a Basic Report
      9. Power View
      10. Summary
      11. What’s Next?
    12. CHAPTER 4: Business Connectivity Services
      1. What Will You Learn in This Chapter?
      2. Software Prerequisites
      3. BCS Terminology
      4. Introduction to BCS Concepts
      5. Setting Up Business Data Connectivity Services
      6. Tools Decision Tree
      7. External Content Types
      8. Authoring an ECT Using Visual Studio with a .NET Connector
      9. Creating an ECT Using SharePoint Designer and a .NET Type
      10. BDC Runtime
      11. Integration with Office Applications
      12. App-Scoped ECTs
      13. PowerShell Commands
      14. Summary
      15. What’s Next?
    13. CHAPTER 5: Excel Services
      1. What Will You Learn in This Chapter?
      2. Software Prerequisites
      3. Introduction
      4. Setting Up Excel Services
      5. Authoring Your First Excel Sheet and Publishing It to Excel Services
      6. Excel Services REST API
      7. Excel Services SOAP API
      8. Excel Services and SSAS
      9. PowerPivot for Excel
      10. Excel Services and ECMAScript
      11. Summary
      12. What’s Next?
    14. CHAPTER 6: PerformancePoint Services
      1. What Will You Learn?
      2. Software Prerequisites
      3. Introduction to PerformancePoint Services
      4. PerformancePoint Services Architecture
      5. Setting Up PerformancePoint Services
      6. Authoring and Publishing PerformancePoint Solutions
      7. Advanced Report Types
      8. Summary
    15. Index