Data Filtering is the process of choosing a smaller
part of a Data Set and using that subset for viewing
Filtering may be used to:-
- Look at results for a particular period of time.
- Calculate results for particular groups of interest.
- Exclude erroneous or bad observations
from an analysis.
- Train and validate statistical models.
Filtering requires a specific a rule or logic to identify
the cases you want to included or excluded in the analysis.
Filtering can also be referred to as subsetting
data, or a data drill-down.
Data Sorting is the process that involves rearranging
the Data into some meaningful order to make it easier
to understand, analyze or visualize.
Data Source Mapping can be used to map data and add
additional custom Data Columns to a Data Table using
formulas, expressions and queries.
When working with Data, sorting is a common method
used for visualizing data in a form that makes it easier
to comprehend the story the Data is telling.
Sorting can be done with raw data (across all records)
or at an aggregated level (in a table, chart, or some
other aggregated or summarized output).
Data Filtering and Sorting allows Data to be Filtered
and Sorted by Data Columns using rules to Filter and
Sort as required.