Business intelligence scenarios and solutions

Published: July 29, 2010

The articles in this section are intended to help you apply and integrate Microsoft SharePoint Server 2010 Service applications to solve your business intelligence needs.

In this section:

• Analyze data from SQL Server Analysis Services by using Excel

• Case Study: Edgenet and self-service business intelligence (SharePoint Server 2010)

• Configuring a BI infrastructure: Hands-on labs

• Configure a SharePoint Server 2010 farm for business intelligence by using NTLM

• Configure extranet access for PerformancePoint Services 2010 (white paper)

• Configure Kerberos authentication for SharePoint 2010 Products (white paper)

• Create a Balanced Scorecard by using Dashboard Designer

• Excel Services data refresh flowchart

• Monitor SharePoint Server by using Visio Services and System Center Operations Manager

• PerformancePoint Services process diagram

• PerformancePoint Services SuperFlows

• Review and track workbooks on a PowerPivot Gallery by using SharePoint approval workflows

• Self-service business intelligence with Excel, PowerPivot for Excel, and Excel Services

• Store and manage business intelligence content in a central location

• Track and analyze sales by using a PerformancePoint dashboard (SharePoint Server 2010)

• Understanding business intelligence planning solutions and scenarios (SharePoint Server 2010)

• Use custom extensions with PerformancePoint Services (SharePoint Server 2010)

• Use Excel Services with Secure Store (SharePoint Server 2010)

• Use Project Server with PerformancePoint Services (SharePoint Server 2010)

• Use Secure Store with SQL Server Authentication (SharePoint Server 2010)

• Use Visio Services with complex data queries

• Use Visio Services with Secure Store

• Use Visio Services with SharePoint lists (SharePoint Server 2010)

• Viewing reports and scorecards on Apple iPad devices (SharePoint Server 2010)