Executing Data Manipulation Techniques
Goals
- Work with the whole data set.
- Use functions to manipulate data.
- Create and recode variables.
Work with thee Whole Data Set
- Sorting Data
- Filtering Data
- Filtering Data on Dashboards and Visuals
- Date range filters
- hard-coded filters
- interactive filters
- Aggregate Functions in SQL
- Add and Average
- Reduction in Data Sets
- aggregate data
- sampling data
Use Functions to Manipulate Data
- Using Functions to Manipulate Data
- Cleaning String Functions
- Date and Time Functions
- Date Table
- Combining Data Fields
- Parsing Strings for Information
- Correcting String Data
- standardization
- RegEx