Data Analitics Study Notes
Common JOINs * INNER JOIN: a function that returns records with matching values in both tables * LEFT JOIN: a function that returns all the records from the left table (first mentioned) and only the matching records from the right table (second mentioned) * RIGHT JOIN: a function that returns all records from
Data Analitics Study Notes
Data aggregation The process of gathering data from multiple sources in order to combine it into a single summarized collection * Puzzle pieces = data * Organization = aggregation * Pile of pieces = summary * Putting the pieces together = gaining insights The aggregation process helps to identify trends, make comparisons, and gain insights that wouldn'
Data Analitics Study Notes
VLOOKUP core concepts Spreadsheet functions can be used to quickly find information and perform calculations using specific values. VLOOKUP, or Vertical Lookup, is one such function that vertically searches for a certain value in a column to return a corresponding piece of information. In this reading, you’ll examine the