BI for Everyday Decisions

Powerful analytics and reporting functionality.

Meeting the Needs of a Broad Range of Industries

The Excel Add-in for Analysis Services has the power and versatility to address critical business issues across a wide range of industries, including:

Financial Services: Reduce transaction costs and respond more quickly to new opportunities.
Government: Improve the visibility and flow of information among agencies and their constituents.
Healthcare: Enhance patient safety and improve the efficiency of healthcare delivery.
Manufacturing: Optimize alignment of manufacturing processes and strategic objectives.
Retail: Track changing market and consumer dynamics in real time.
Telecommunications: Improve customer service and increase customer retention.

Key Technical Features

Tightly integrated with Microsoft SQL Server 2005/8 and Analysis Services, the Excel Add-in for Analysis Services extends the reporting and analysis features and native functionality of Microsoft Office Excel. The add-in provides a comprehensive set of tools that makes it easy to link to disparate data sources, manage queries, build sophisticated reports in multiple layouts, perform write back, and much more.

The key components of the Excel Add-in for Analysis Services include:

Cube Metadata Manager: Retrieves and shares OLAP cube information.
Query Manager: Consolidates and executes queries and returns the results; also performs write back to cubes.
Report Builder User Interface: The "task pane" interface used to build reports.
Report Metadata Manger: Maintains report layout and enables report interactions like focus, eliminate, expand/collapse, and drillup/drilldown.
Report Manager: Creates and manages formulas and presents query results in Excel cells.

System Requirements
The Microsoft Office Excel Add-in for SQL Server Analysis Services is based on the following Microsoft products and technologies: