Developing Business Intelligence Solutions

Microsoft SQL Server 2005 provides a comprehensive set of components, such as Microsoft SQL Server 2005 Database Engine, Microsoft SQL Server 2005 Analysis Services (SSAS), Microsoft SQL Server 2005 Integration Services (SSIS), and Microsoft SQL Server 2005 Reporting Services (SSRS), as well as an integrated set of development and administration tools, such as Business Intelligence Development Studio and SQL Server Management Studio. In combination, these components and tools let you easily develop and manage scalable, highly interoperable business solutions that are accessible to every person at every level of an organization.

However, there is more to successfully designing, deploying, and maintaining a business solution than just components and tools. You also need information on how to use those components and tools to resolve business issues and best practices on how to implement common business solutions.

The following sections provide guidance on how to implement business solutions in a variety of categories, and describe common business issues and solutions, using SQL Server 2005 components and tools.

Designing and Creating Databases

Using Native XML Web Services in SQL Server 2005

Working with Online Analytical Processing (OLAP)

Working with Data Mining

Designing and Creating Integration Services Packages

Designing and Creating Reports

Managing and Working With Published Reports