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.

• Demonstrate an understanding of functions and procedures that may be used to combine data from multiple cells in a spreadsheet
• 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

• The process of gathering data from multiple sources in order to combine it into a single summarized collection

Prepare

USE

Problems

• 只會回傳第一個找到的
• 忘記鎖定搜尋的範圍（忘記加 $）

Use JOINS to aggregate data in SQL

Work with subqueries