2026 NEW UPDATE D465 Data Applications Module 1-4 Overview and Key Functions Western Governors University
Module 1 Analysis – process used to make sense of the data collected 4 phases of analysis 1. Organize Data Two methods used are Sorting and filtering 2. Format and adjust data 3. Get input from others 4.Transform Data SQL structured query language- is a language for accessing and manipulating databases Where clause works like filtering in SQL Asterisk under select- will use all the data I.e. Select * From ‘Title of the data sheet ‘ Where Genere=’Comedy’ Sorting Funtion SORT- involves arranging data into a meaningful order Function =SORT (A2:D6, 2, TRUE-orFALSE) A2:D6 is the range of cells used