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.
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.