Business Intelligence

SQL Server Developer Center

SQL Server 2005 provides a robust set of Business Intelligence capabilities. This section provides you resources to fully exploit these features.

	Download 8 New SQL Server 2005 Report Packs These free report packs will simplify your report tasks, improve your business visibility and speed your decision making.
	SQL Server Business Intelligence Webcasts View live or on-demand webcasts and learn how to transform data into decisions with SQL Server business intelligence.

SQL Server Business Intelligence Technologies

Analysis Services
Microsoft SQL Server 2005 Analysis Services delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets you design, create, and visualize data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms.

SQL Server 2005 Data Mining
Data mining is frequently described as "the process of extracting valid, authentic, and actionable information from large databases." In other words, data mining derives patterns and trends that exist in data. These patterns and trends can be collected together and defined as a mining model. Mining models can be applied to specific business scenarios.

Integration Services
Learn more about SQL Server Integration Services (SSIS), the successor to DTS in SQL Server 2005. SSIS is an all-new application that provides a data integration platform from easy-to-use tasks and transforms for the non-developer to a robust object model to support creation of custom tasks and data transformations.

SQL Server 2005 Notification Services
Microsoft SQL Server 2005 Notification Services is a platform for developing and deploying applications that generate and send notifications. You can use Notification Services to generate and send timely, personalized messages to thousands or millions of subscribers, and can deliver the messages to a wide variety of devices.

SQL Server 2005 Reporting Services
SQL Server 2005 Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

SQL Server Business Intelligence Forums

SQL Server Analysis Services

Discussions relating to MDX and other Analysis Services or OLAP questions.

Data Mining

All questions and discussions related to data-mining in SQL Server.

SQL Server Integration Services

All questions related to SSIS, transforms/data flow, control flow, and other related topics.

SQL Server Notification Services

Look here for questions, answers, and advice on using SQL Notification Services.

SQL Server Reporting Services

Report Server, Report Designer, Report Builder, and other reporting-related discussions.