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. 

"BI-Analyzer has been an outstanding addition to our tool set. Since its introduction, we have experienced exponential productivity gains in report preparation and analysis. ...(read more) What used to take us hours is now reduced to minutes. BI-Analyzer is easy to use and seamlessly integrates into Excel - and the nice thing is you don't need to be an Excel expert to use the tool! It is so flexible and intuitive yet powerful, that it can be used for complex reports. With this product, no analyst need ever fear time-challenged demands by their managers for data or analysis - the answer is just a few clicks away."

Manager, Accounting and Strategic Measures
Chang School of Continuing Education Ryerson University

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