2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
|
Business Intelligence (BI) just became a lot easier! The release of the 2007 Microsoft Office system, used in conjunction with Microsoft SQL Server 2005, delivers numerous benefits in terms of Return on Investment (ROI) for a company, design and implementation for its Information Technology (IT) department, and ease of use for end-users.
According to the research firm IDC, Microsoft’s BI tools are growing at more than twice the rate of the overall market. Microsoft technologies are at the forefront of the BI market and are continuing to grow in breadth and capabilities. This paper discusses the important drivers, reasons, and technology features when integrating SQL Server 2005 and the 2007 Office system. To keep this paper as brief as possible, it references some additional Web sites that you can visit for more information.
This paper is divided into two main sections. The first shows an overview of the three main BI integration points between Microsoft SQL Server 2005 and the 2007 Microsoft Office system:
| • | Microsoft SQL Server 2005 Reporting Services and Microsoft Office SharePoint Server 2007 |
| • | Microsoft SQL Server 2005 Analysis Services and Microsoft Office Excel 2007 |
| • | Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007 |
The second part of the paper breaks down each of the above integration points by showing what software components are needed, features and benefits, how to install and configure the components, and how to use them.
