Business Intelligence

From SQLServerPedia

Jump to: navigation, search

Because we've got so much Business Intelligence content here at SQLServerPedia, we're splitting the section out into three new ones, each with their own individual editor:

SQL Server Analysis Services Section

Although packaged with the relational database engine, Microsoft SQL Server Analysis Services (SSAS) works very differently from other technologies making up SQL Server. SSAS has matured over multiple releases and experienced wide adoption over a relatively short time span. Recent versions of SSAS provide better tools and more guidance for performance tuning than their predecessors.

SQL Server Integration Services Section

SQL Server Integration Services (SSIS) is a high performance data extraction, transformation and loading (ETL) tool included with SQL Server 2005 family of products. It can be thought of as the next generation of Data Transformation Services (DTS) - the tool available with the previous versions of SQL Server. In fact many SSIS executables retain the DTS acronym because the new name wasn't introduced until later stages of the product development cycle.

SQL Server Reporting Services Section

SQL Server Reporting Services (SSRS) is a reporting platform that provides functionality for a variety of data sources. SSRS includes tools to create, manage and deliver reports. With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. You can publish reports, schedule report processing, or access reports on-demand. Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site.