Business Intelligence in SharePoint 2010

Composites Capabilities for SharePoint 2010

Business intelligence applications and tools enable you to organize your vision of organizational goals, processes, and performance requirements in a useful manner and to present that data as meaningful information.

Understanding BI:
Choose a business intelligence tool in SharePoint Server 2010
Overview of SQL Server Reporting Services reports in SharePoint
Data warehousing, OLAP, and Analysis Services for SharePoint 2010

BI example farm deployment with four servers

This illustration shows a farm deployment with four servers. The front-end Web servers run on IIS and host the Web Parts for business intelligence services, Web services, and proxy that are required for communication between the client and the service applications.

SharePoint 2010 Business Intelligence - Farm Deployment with 4 servers

Business Intelligence Basics

Architecture for business intelligence in SharePoint Server 2010

Configuring Kerberos authentication for SharePoint 2010, including business intelligence scenarios

Secure Store for Business Intelligence service applications

Overview of SQL Server Reporting Services reports in SharePoint

Introduction to Business Intelligence Indexing Connector

How to Choose the Right Business Intelligence Technology to Suit Your Style

Trying to decide on which Business Intelligence application is best for your business? This white paper "How to Choose the Right Business Intelligence Technology to Suit Your Style" will help you with those questions and more.

Read about the five different styles of BI -- Self-Service Analysis, Business Reporting, Parameterized & Operational Reporting, Performance Monitoring, and Scorecarding -- download white paper.

Business Intelligence Scenarios

Microsoft business intelligence (BI) expands the reach of your investments in the Microsoft productivity platform, data infrastructure, and collaboration tools you already own. The Microsoft solution delivers business intelligence by integrating the strengths of these products on a single platform to empower informed business decisions.

This collection of BI scenarios provides end-to-end guidance on how to implement these solutions in your organization.

Analyze Sales Performance by using a Dashboard Built on SharePoint Server, SQL Server, and Office

Create a Self-Service Analytics Solution for Sales Data by using PowerPivot for Excel and SharePoint

Create Reports and Subscriptions by using SQL Server Reporting Services, and Analyze Data in Excel

Configure Excel and Excel Services by using SQL Server Analysis Services on SharePoint Server 2010

Track Project Resource Usage by using a Dashboard Built on SharePoint Server and Project Server

Monitor SharePoint Server by using Visio Services and System Center Operations Manage

SQL Server 2008 R2 Business Intelligence Training Course

The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn how to build your first Microsoft Business Intelligence solution. SQLInsights is a great resource for developers, consultants and evangelists who need to learn the basics of how to build solutions that deliver integrated reporting, analytics and dashboard experiences. It contains a rich set of videos and hands-on labs that are perfect for self-paced learning.

  • Introduction to Microsoft Business Intelligence
  • Introduction to BI Modeling Techniques
  • Introduction to SQL Server 2008 R2 Integration Services
  • Introduction to SQL Server 2008 R2 Reporting Services
  • Publishing and Accessing SQL Server 2008 R2 Reporting Services Reports
  • Introduction to SQL Server 2008 R2 Analysis Services
  • Introduction to SQL Server 2008 R2 Analysis Services Query Syntax
Magic Quadrant for Business Intelligence Platforms - Gartner

Microsoft recognized by Gartner as a leader in business intelligence based on ability to execute and completion of vision. read summary

Microsoft BI

For the latest news and happenings on BI for Office 2010, SharePoint 2010 and SQL Server 2008 R2 visit official site

PerformancePoint Services Resource Center

Find overviews, how-to topics, and other resources to help you develop custom extensions for PerformancePoint Services in Microsoft SharePoint Server 2010. visit site

PerformancePoint Dashboard Designer

The latest version of PerformancePoint Dashboard Designer makes it easier than ever to create, publish, and maintain your PerformancePoint dashboards. New features include tighter integration with Microsoft SharePoint Server 2010, more robust key performance indicators (KPIs) and scorecards, and new and improved report types. Get started with PerformancePoint Dashboard Designer

SQL Server Reporting Services (SSRS) Resource Center

SQL Server Reporting Services (SSRS) resources and information on the installation and management of Reporting Services and creation and deployment of reports. visit site.

SQL Server Reporting Services (SSRS) Report Builder is a report authoring environment for business users who prefer to work in an environment similar to Microsoft Office. For Report Builder specific resources, visit Report Builder

Business Intelligence in Project Server 2010

Learn about business intelligence (BI) in Microsoft Project Server 2010, built on Microsoft SharePoint Server 2010. visit site

Business Intelligence SharePoint 2010 Models Poster