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
RETURN TO THE BI ENCYCLOPEDIA