fbpx Skip to content
insight Encyclopedia

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