Data Filtering is the process of choosing a smaller part of a Data Set and using that subset for viewing or analysis.
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. Data Filtering can also be referred to as Data subsetting 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 it in a form that makes it easier to comprehend the story the Data is telling.
Data Filtering and Sorting
The Data Filter Designer is a powerful tool to help with the design and application of Data Filters and Data Sorting on Data Columns.
Select the Data Columns to filter and / or sort from the drop-down lists.
Click the 'Execute' button to apply the Data Filters and view the filtered Data.