Data Analysis

Data analysis is the process of examining, transforming, and arranging data in a specific way to generate useful information based on it. It also allows for reaching certain outcomes and conclusions through analytical and logical reasoning.

Note

This functionality will be introduced in Ignite UI for Angular as external package in order to ease the configuration and limit the required code at minimum

Data Analysis Button

The data analysis button is the outlet to visualize your selected data in various ways:

This way every range selection performed in the grid can be easily analyzed in a single click.

The button is rendered on every range selection at the bottom-right of the selection and hides when the selection is inactive. Horizontal and vertical scrolling reposition the button so that it is always rendered at its designated position.

Chart Integration

This section introduces Grid's integration with charting functionality, which allows the end user to visualize a chart based on Grid's selected data and choose different chart types if needed.

The chart will be shown by selecting a range of cells and by clicking on the show analysis button.

Note

The chart creation option is only available when there are numeric values in the selected data.

We currently support the following Chart types:

Conditional Cell Formatting

If you have a Grid with thousands of rows of data it would be very difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines, Conditional formatting provides another way to visualize data and make it easier to understand.

Understanding conditional formatting - it allows for applying formatting such as colors and data bars to cells based on their value in the range selection. The sample below demonstrates how you can configure the Grid to apply Conditional Formatting. It depends on the Conditional formatting selection type what condition rules will be shown. Below you will find the predefined styles (presets) that you can use in order to quickly apply conditional formatting to your data. The formatting of a range gets cleared when performing formatting on different range or through the clear button. The clear button is only active when there is an applied formatting.

Number range selection

  • Data Bars - Data bars can help you spot larger and smaller numbers, such as top-selling and bottom-selling products. This preset makes it very easy to visualize values in a range of selected cells. A longer bar represents a higher value. A cell that holds value of 0 has no data bar all other cells are filled proportionally. Positive values are with green color and negative values will be red

  • Color Scale - The shade of the color represents the value in the cell. The cells that hold values below the *Lowest threshold will be colored in red. The cells that are above the *Highest threshold will be colored in green. And all the cells that are between the Lowest and Highest threshold will be colored in yellow.

Lowest threshold - Below 33% of the maximum cell value in range selection.

Highest threshold - Above 66% of the maximum cell value in range selection.

  • Top 10% - Use this preset to highlight the values which are equivalent to top 10% of the selected data.

  • Greater than - This preset marks all values Greater than the avarege
  • Duplicate values - Marks all duplicate values.
  • Unique values - All cell values that are unique will be marked (blue background color).

  • Empty- Marks all cells with undefined values

Text range selection

  • Text contains - Marks all cells that contain the cell value from the top-left most selected cell. Example:

  • Duplicate values - Marks all duplicate values.
  • Unique values - All cell values that are unique will be marked (blue background color).
  • Empty- Marks all cells with undefined values

Demo

Useful resources