Spredsheets

Data Analitics Study Notes

Get started with data calculations

* As a data analyst, familiar tools and processes are frequently used, but learning new ones is essential for growth. * SQL can significantly improve efficiency when pulling data and conducting analysis. * Spreadsheets, conditional formulas, the SUMPRODUCT function, and pivot tables are useful tools for performing calculations in data analysis. * Pivot tables

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