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 ...
Get SharePoint 2007: The Definitive Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
