Contents
Chapter 1: Business Intelligence Basics
Introduction to Business Intelligence
Online Transaction Processing System
Online Analytical Processing System
Decision Support Systems and Data Mining
SQL Server 2012 Analysis Services Tabular Model
SharePoint and Business Intelligence
What’s New in SharePoint 2013?
Introduction to Visio Services
The Visio 2013 Client’s Data Tab
Integrating Visio with SharePoint
Using the Visio Web Access Web Part
Visio Web Access Web Part Connections
Using a SQL Server Data Source
Configuring Secure Store Services
Using Visio with SQL Server and SSS
Visio Services JavaScript Mashup API
Understanding the assets.js Code
Working with SharePoint Designer 2013
Creating Your Own Custom Data Providers
Administration of Visio Services
Creating a New Visio Graphics Service Application
Deleting an Existing Visio Graphics Service Application
List all Existing Visio Graphics Service Applications
Creating a New Visio Graphics Service Application Proxy
Delete an Existing Visio Graphics Service Application Proxy
List All Existing Visio Graphics Service Application Proxies
Setting Up Visio Graphics Service Global Settings
Setting Up a Graphics Service Trusted Data Provider
Factors Affecting the Performance of Visio Services
What Will You Learn in This Chapter?
Introduction to Reporting Services
Reporting Services Add-in Features
Reporting Services Local Mode vs. Connected Mode
Building and Publishing a Basic Report
Using Report Builder to Edit a Published Report
Loading Reports Using the Report Viewer Web Part
Reporting Services Content Types
Integration with a SharePoint List
Interacting with Power View Reports
Chapter 4: Business Connectivity Services
What Will You Learn in This Chapter?
Setting Up Business Data Connectivity Services
Set Up a New BDC Service Application
Creating Your First ECT Using SharePoint Designer
Authoring an ECT Using Visual Studio with a .NET Connector
Creating an ECT Using SharePoint Designer and a .NET Type
Integration with Office Applications
What Will You Learn in This Chapter?
Trusted Data Connection Libraries
User-Defined Function Assemblies
Authoring Your First Excel Sheet and Publishing It to Excel Services
What’s New in Excel Services 2013
Configuring Secure Store Services
Interacting with Excel Services Workbook
Chapter 6: PerformancePoint Services
Introduction to PerformancePoint Services
PerformancePoint Services Architecture
Service Components and Interfaces
Securing PerformancePoint Solutions
Business Intelligence Solution Components
Setting Up PerformancePoint Services
Authoring and Publishing PerformancePoint Solutions
Deploying the Business Intelligence Center
Creating a Dashboard Designer Workspace
Creating Key Performance Indicators
Deploying the Solution to SharePoint, and Exploring