Explore Data Analyst Tools

• tools include —

  • spreadsheets

  • query languages for databases

  • visualization tools

Spreadsheets — digital worksheet that stores, organizes, and sorts data

• microsoft excel

• google sheets

Formula — set of instructions that performs a specific calculation using the data in a spreadsheet

• add, subtract, multiply and divide

• find the average of a number set

• look up a particular value

• return the sum of a set of values that meets a particular rule

Function — a preset command that automatically performs a specific process or task using the data in a spreadsheet

• can make you more effcient

Query Language — a computer programming language that allows you to retrieve and manipulate data from a database

• most commonly known as SQL

• SQL (structured query language) — language that lets data analysts communicate with a database

Database — collection of data stored in a computer system

• use SQL to insert, delete, select, or update data

Data Visualization — the graphical representation of information

• graphs, maps, and tables

• helps data analysts communicate their insights to others

• can be understood and shared

• makes it easier for stakeholders to draw conclusions

• tools include — Tableau and Looker

Tableau — simple drag and drop feature lets users create interactive graphs in dashboards and worksheets

Looker — communicates directly with a database, allowing you to connect your data right to the visual tool you choose.