O'Reilly logo

SharePoint 2007: The Definitive Guide by Christopher J. Regan, Piotr Prussak, Christopher Pragash, Joris Poelmans, Nilesh Mehta, Jason Medero, Michael Lotter, Murray Gordon, Bob Fox, Christopher M. Buechler, James Pyles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Warehousing

The Microsoft SQL Server 2005 data warehousing solution is the core source for BI information. SQL Server has a proven track record as a reliable, scalable, and productive database platform. Analysis and Reporting are at the heart of SQL Server's use as a BI tool:

Microsoft SQL Server 2005 Analysis Services (SSAS)

Offers OLAP services and data mining, letting you specify particular dimensions in multidimensional data such as time and trend analysis views, and aiding you in the construction of complex analytical models. This technology is a completely new approach to administering, modeling, and querying data.

Tip

OLAP is a class of applications used to analyze data in a database. This software usually runs on a server placed between the user and the SQL Server, accessing the database in response to the user's request and providing the required analytics.

SQL Server 2005 Reporting Services (SSRS)

Microsoft's solution for creating and delivering managed reports. Reporting Web Parts allow SSRS to display SQL report information directly in a SharePoint site.

SQL Server Business Intelligence Development Studio

Provides a completely integrated software development environment. Built on Visual Studio 2005 and specifically designed for the BI developer, Business Intelligence Development Studio can be used to develop such BI solutions as analysis services, database engines, integrations services, and reporting services.

Tip

See Learning SQL on SQL Server 2005, by Richard Earp and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required