5.3.Aggregating 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

---

• VLOOKUP for data aggregation
• Use JOINS to aggregate data in SQL
• Work with subqueries
• Weekly challenge 3