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:
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.
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.
Microsoft's solution for creating and delivering managed reports. Reporting Web Parts allow SSRS to display SQL report information directly in a SharePoint site.
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.
See Learning SQL on SQL Server 2005, by Richard Earp and ...