Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Business Intelligence Basics
What Will You Learn?
Software Prerequisites
Introduction to Business Intelligence
Why Intelligence?
Understanding BI
OLTP vs. OLAP
Online Transaction Processing System
Online Analytical Processing System
The BI Foundation
Data Warehouses
Data Marts
Decision Support Systems and Data Mining
Tools
SQL Server Management Studio
SQL Server Data Tools
SQL Server 2012 Analysis Services Tabular Model
SharePoint and Business Intelligence
What’s New in SharePoint 2013?
Summary
What’s Next?
Chapter 2: Visio Services
What Will You Learn?
Software Prerequisites
Introduction to Visio Services
Why Visio?
Presenting Visio Services
Setting Up Visio Services
Visio Services Features
Architecture
The Visio 2013 Client’s Data Tab
Link Data to Shapes
Data Graphics
Automatically Link
Refresh All
Insert Legend
Shape Data Window
External Data window
Integrating Visio with SharePoint
Using the Visio Web Access Web Part
Visio Web Access Web Part Connections
Using a SQL Server Data Source
Secure Store Services
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
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
Summary
What’s Next?
Chapter 3: Reporting Services
What Will You Learn in This Chapter?
Software Prerequisites
Introduction to Reporting Services
Architecture
Choosing the Right SSRS Mode
Setting Up the Infrastructure
Reporting Services Add-in Features
Reporting Services Local Mode vs. Connected Mode
Report Life Cycle
Data Source Management
Authoring Tools
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
Creating a Report Data Source
Subscription to Reports
Integration with a SharePoint List
Power View
Creating a Power View Report
Interacting with Power View Reports
Summary
What’s Next?
Chapter 4: Business Connectivity Services
What Will You Learn in This Chapter?
Software Prerequisites
BCS Terminology
Introduction to BCS Concepts
Setting Up Business Data Connectivity Services
Set Up a New BDC Service Application
BDC Models View
External Systems View
External Content Types View
Tools Decision Tree
External Content Types
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
BDC Runtime
Integration with Office Applications
Integration with Office Word
App-Scoped ECTs
Working with OData Sources
PowerShell Commands
Summary
What’s Next?
Chapter 5: Excel Services
What Will You Learn in This Chapter?
Software Prerequisites
Introduction
Architecture
Setting Up Excel Services
Global Settings
Trusted File Locations
Trusted Data Providers
Trusted Data Connection Libraries
User-Defined Function Assemblies
Data Model Settings
Authoring Your First Excel Sheet and Publishing It to Excel Services
What’s New in Excel Services
Backup and Recovery Operation
Authoring and Publishing
Excel Services REST API
Excel Services OData API
Excel Services SOAP API
Excel Services and SSAS
Configuring Secure Store Services
Interacting with Excel Services Workbook
Data Connection
PowerPivot for Excel
Setting Up PowerPivot
Excel Services and ECMAScript
Summary
What’s Next?
Chapter 6: PerformancePoint Services
What Will You Learn?
Software Prerequisites
Introduction to PerformancePoint Services
PerformancePoint Services Architecture
Service Components and Interfaces
Securing PerformancePoint Solutions
Business Intelligence Solution Components
Setting Up PerformancePoint Services
Application Settings
Trusted Data Source Locations
Trusted Content Locations
Authoring and Publishing PerformancePoint Solutions
Deploying the Business Intelligence Center
Creating a Dashboard Designer Workspace
Creating a Data Source
Creating Key Performance Indicators
Creating a Scorecard
Creating Filters
Creating Reports
Creating a Dashboard
Deploying the Solution to SharePoint, and Exploring
Advanced Report Types
Create an Excel Services Report
Create a Strategy Map Report
Summary
Index
← Prev
Back
Next →
← Prev
Back
Next →