BI Encyclopedia

Analysis Grid

What is Analysis Grid?

Use the Analysis Grid to answer important questions from your data.

Powerful, Flexible Data Analysis

The Analysis Grid is one of the most powerful–yet easy to use–data-analysis tools available today. It is a feature that allows developers to create a grid of data for business users to analyze and query in multiple and powerful ways. It is a managed reporting feature giving end users virtual ad hoc capability.

Although Web-based, the Analysis Grid offers the interactivity of a dedicated desktop application. It is composed of three main parts:

The data grid itself, i.e. a table of data to be analyzed

A number of action buttons at the top, allowing the user to perform actions such as:

Create new columns with custom calculations

Hide and move columns

Sort columns

Filter data

Add groupings

Perform aggregations

Add charts

Add cross-tab views

Control paging

And the ability to export the grid to Excel, CSV or PDF format

The Benefits of the Analysis Grid

After it’s mastered, which is generally a quick and intuitive process, the Analysis Grid can yield a tremendous amount of answers to business questions. Among the many benefits of this analysis feature, here are the most salient:

Giving end-users virtual ad-hoc analysis capability on their data

Allowing end-users to create custom columns and perform complex calculations at the click of a mouse

Making it easy to perform what-if analysis through features like filtering

Making data-presentation impactful through visualization features including heat maps

Letting the user save his analysis grid report and reuse it whenever needed

Letting the user export his findings in other formats such as Excel, CSV and PDF