BI Analyzer

BI-Metrix's Excel Analyzer is a powerful analytical reporting tool that allows business users to easily query and manipulate the information in Microsoft Analysis Services cubes.

BI-Analyzer works as a Microsoft Excel add-in to seamlessly retrieve Analysis Services  data and returns that information for use in Excel’s spreadsheet—not a PivotTable. Its free-form approach allows users to quickly define and modify reports without the need for complex scripts or formulas. 

Features of BI-Analyzer:

Works in Excel

• Perform advanced analytics and reporting inside a familiar environment
• Leverage all of Excels graphing, formatting and built-in advanced analytical functionalities
• Reduce implementation and training costs

Simple connection interface to your cubes directly from Excel

• Allows you to control when to connect, read, and disconnect the cubes
• Facilitates changing a report to read a backup copy, test cube, or other similar cube
• Retains the most recent connection information for each worksheet

Robust reporting and analytical operations

• Drill-down to lower levels of detail and contracts back again
• Keeps or eliminates members or sections
• Pivots dimensions between the page, row and column headers
• Rank or sort on any dimension to isolate different areas of your business for better decision making

Powerful planning, forecasting and what-if analysis

• Enables timely and thorough what-if analysis
• Provide users with a simple and intuitive way to plan across multiple dimensions (e.g., product, geography, customer, etc.)
• Easily build, modify, and maintain multidimensional financial models directly in Excel

Drill-through to lower levels of detail

• Facilitates drill-through to view the underlying detailed data for a selected cell
• Presents friendly interface to confirm drill-through selection and limits
• Places drill-through data on a neighboring worksheet

Formula-free report definitions

• Does not depend on cell formulas to link Excel cells to the cube data
• Uses the cell positions within a report layout to determine the requested data
• Eliminates incorrect reporting as a result of corrupted formulas or misdirected cell references

No intrusive formatting on the worksheet

• Does not impose visible pick lists, buttons or layout borders
• Reports can be formatted any way you want for viewing and printing
• Allows you to insert extra rows and columns that can contain Excel formulas or other text inside of a report