Organize data: Purpose and common practices (sorting, filtering, slicing, transposing, appending, truncating, etc.).Clean data: Purpose and common practices (handling NULL, special characters, trimming spaces, inconsistent formatting, removing duplicates, imputing data, etc.) validating data.Import, store, and export data: Fundamental understanding of ETL (extract, transform and load) processes, data manipulation tools (SQL, R, Python, Microsoft Excel including aspects of Power Query), and common data storage file formats (delimited data files, XML, JSON).Describe data categories (Qualitative, quantitative, structured, unstructured, metadata, big data).Describe basic structures used in data analytics (Tables, rows, columns, lists).Describe basic data variable types (Boolean, numeric, string).