Lesson 20 Aggregate data for analysis

Google Data Analytics - Course 5 - Analyze Data to Answer Questions
Lesson 20 Aggregate data for analysis

As part of your analysis, you’ll often have to combine data in order to gain insights and complete business objectives. In this part of the course, you’ll explore the functions, procedures, and syntax involved in combining, or aggregating, data. You’ll learn how to do this from multiple cells in spreadsheets and from multiple database tables using SQL queries.

Learning Objectives
Demonstrate an understanding of functions and procedures that may be used to combine data from multiple cells in a spreadsheets
Demonstrate an understanding of functions and syntax to create SQL queries for combining data from multiple database tables
Use VLOOKUP to query data, trim data, convert text data to numeric data, and create a summary table from a queried information