Download the 2007 Office release

Play Demo 

(Or download the demo.)

(You may experience a delay while the demo is loading.)

Business intelligence (BI) is the process of aggregating, storing, analyzing, and reporting on business data in order to support informed business decisions. Microsoft Office SharePoint Server 2007 provides a number of tools that can help you extract data from a variety of sources and present that data in ways that facilitate analysis and decision making. In this demo, you'll see how employees at a fictitious company called Adventure Works use a Report Center site to create and manage reports, dashboards, and key performance indicators (KPIs).

How to do it (text version):

• Introduction to business intelligence in SharePoint Server 2007
• Share Excel 2007 workbooks as interactive reports
• Working with a Report Center site
• Share and manage connections to external data
• Create and publish Key Performance Indicators (KPIs)
• Share Excel 2007 worksheets and KPIs by using dashboards
• Work with filter Web Parts
• Introduction to Excel Services and Excel Web Access

 Problems watching the video? Try our troubleshooting tips.