Data aggregation - Aleksandr Kosenko Digital

Aleksandr Kosenko Digital

Sign in Subscribe

Data aggregation

A collection of 3 posts

Explore how SQL JOINs work

Data Analitics Study Notes

Explore how SQL JOINs work

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

Aggregate data for analysis

Data Analitics Study Notes

Aggregate data for analysis

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'

VLOOKUP {data aggregation}

Data Analitics Study Notes

VLOOKUP {data aggregation}

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