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