Book description
Business Intelligence (BI) software is everywhere. It is the code and tools that allow you to view different components of a business using a single visual platform, making comprehending mountains of data easier. With SharePoint 2010, Microsoft has married one of the most-used team collaboration tools with its business intelligence products, including PerformancePoint Services and Excel Services. Now, users of SharePoint can have a single place to get a view of their business, its organization and processes, and its financial performance.
Constructing this type of portal is a process unique to each business. With Pro SharePoint 2010 Business Intelligence Solutions, authors Sahil Malik and Srini Sistla take you through the different tools, services, and frameworks available for building a BI portal atop SharePoint 2010. With comprehensive coverage of Visio Services, PerformancePoint, Excel Services, and a practical look at building scorecards, dashboards, and other reporting solutions, this book answers the fundamental questions about why and how BI can work for your business.
Table of contents
- Copyright
- About the Authors
- Acknowlegments
- Introduction
-
1. Business Intelligence Basics
- 1.1. Introduction
- 1.2. What Will You Learn?
- 1.3. Why Intelligence?
- 1.4. Understanding BI
- 1.5. OLTP vs. OLAP
- 1.6. The BI Foundation
- 1.7. Tools
- 1.8. SQL Server 2008 R2 Parallel Data Warehouse
- 1.9. SharePoint and Business Intelligence
- 1.10. Summary
- 1.11. What's Next?
-
2. Visio Services
- 2.1. Introduction
- 2.2. What Will You Learn?
-
2.3. Presenting Visio Services
- 2.3.1. Setting up Visio Services
- 2.3.2. Visio Services Features
- 2.3.3. Architecture
- 2.3.4. The Visio 2010 Client's Data Tab
-
2.3.5. Integrating Visio with SharePoint
- 2.3.5.1. Using the Visio Web Access Web Part
- 2.3.5.2. Visio Web Access Web Part Connections
- 2.3.5.3. Using a SQL Server Data Source
- 2.3.5.4. Secure Store Services
- 2.3.5.5. Using Visio with SQL Server and SSS
- 2.3.5.6. Visio Services JavaScript Mashup API
- 2.3.5.7. Working with SharePoint Designer 2010
- 2.3.5.8. Creating Your Own Custom Data Providers
-
2.4. Administration of Visio Services
-
2.4.1.
- 2.4.1.1. Creating a New Visio Graphics Service Application
- 2.4.1.2. Deleting an Existing Visio Graphics Service Application
- 2.4.1.3. List all Existing Visio Graphics Service Applications
- 2.4.1.4. Creating a New Visio Graphics Service Application Proxy
- 2.4.1.5. Delete an Existing Visio Graphics Service Application Proxy
- 2.4.1.6. List All Existing Visio Graphics Service Application Proxies
- 2.4.1.7. Setting Up Visio Graphics Service Global Settings
- 2.4.1.8. Setting Up a Graphics Service Trusted Data Provider
- 2.4.2. Factors Affecting the Performance of Visio Services
-
2.4.1.
- 2.5. Summary
- 2.6. What's Next?
-
3. Reporting Services
- 3.1. What Will You Learn in This Chapter?
- 3.2. Software Prerequisites
- 3.3. Introduction
- 3.4. Architecture
- 3.5. Installation
- 3.6. Building and Publishing a Basic Report
- 3.7. Access Services
-
4. Business Connectivity Services
- 4.1. What Will You Learn in This Chapter?
- 4.2. Software Prerequisites
- 4.3. BCS Terminology
- 4.4. Introduction
-
4.5. Setting Up Business Data Connectivity Services
- 4.5.1.
- 4.5.2. Creating Your First ECT Using SharePoint Designer
- 4.5.3. Authoring an ECT Using Visual Studio with a .NET Connector
- 4.5.4. BDC Runtime
- 4.5.5. Integration with Office Applications
- 4.5.6. PowerShell Commands
- 4.5.7. Summary
- 4.5.8. What's Next?
-
5. Excel Services
- 5.1. What Will You Learn in This Chapter?
- 5.2. Software Prerequisites
-
5.3. Introduction
- 5.3.1. Architecture
- 5.3.2. Setting up Excel Services
- 5.3.3. Authoring Your First Excel Sheet and Publishing it to Excel Services
- 5.3.4. What's New in Excel Services 2010
- 5.3.5. PowerShell Commands
- 5.3.6. Authoring and Publishing
- 5.3.7. Excel Services REST API
- 5.3.8. Excel Services SOAP API
- 5.3.9. Excel Services and SSAS
- 5.3.10. PowerPivot for Excel
- 5.3.11. Excel Services and ECMAScript
- 5.3.12. Plan and Know Excel Services
- 5.3.13. Summary
- 5.3.14. What's Next?
-
6. PerformancePoint Services
- 6.1. What Will You Learn in This Chapter?
- 6.2. Software Prerequisites
- 6.3. Introduction
- 6.4. PerformancePoint Services Architecture
- 6.5. Setting Up PerformancePoint Services
- 6.6. Managing PerformancePoint with PowerShell
-
6.7. Authoring and Publishing PerformancePoint Solutions
- 6.7.1. Deploying the Business Intelligence Center
- 6.7.2. Creating a Dashboard Designer Workspace
- 6.7.3. Creating a Data Source
- 6.7.4. Creating Key Performance Indicators
- 6.7.5. Creating a Scorecard
- 6.7.6. Creating Filters
- 6.7.7. Creating Reports
- 6.7.8. Creating a Dashboard
- 6.7.9. Deploying the Solution to SharePoint, and Exploring
- 6.8. Advanced Report Types
- 6.9. Summary
Product information
- Title: Pro SharePoint 2010 Business Intelligence Solutions
- Author(s):
- Release date: December 2010
- Publisher(s): Apress
- ISBN: 9781430232858
You might also like
book
Not-for-Profit Financial Reporting
Through a combination of practical guidance and case studies, the author provides insight into what makes …
book
Crystal Reports® 2008 For Dummies®
A report is only useful if those who receive it understand what it means. Knowing how …
book
Public Budgeting in Context
Public budgeting structure, process, legal framework and policy with examples from industrialized and developing countries Public …
book
Windows® SharePoint® Services 3.0 Inside Out
Learn everything you need to know for working with Microsoft Windows SharePoint Services Version 3.0. This …