Exploring Data Analyst Tools

 

There are 3 major tools required by a data analyst:

• Spreadsheets

• MS Excel and google sheets
• Identify patterns and piece the data together in a way that works for each specific data project.

• It is a digital worksheet that stores, organises and sorts data.

• There are two main parts of a spreadsheet:

• Formula: A set of instructions that performa a specific calculation using the data in a spreadsheet.

• Function: A preset command that automatically performs a specific process or task using the data in a spreadsheet.

• Query languages for databases

• A query language is a computer programming language that allows you to retrieve and manipulate data from a database.
• A database is a collection of structured data stored in a computer system.
• Query languages allow analysts to isolate specific information from a database(s).
• They make it easier for you to learn and understand the requests made to databases.
• They allow analysts to select, create, add, or download data from a database for analysis.

• SQL : Structured Query Language

• With SQL data analysts can access data by making a query.

• Visualisation tools

• Data Visualisation : The graphical representation off information.
• These tools turn complex numbers into a story that people can understand.
• They help stakeholders come up with conclusions that lead to informed decisions and effective business strategies.

• Graphs, Maps, Tables etc.

• Tableau, Looker







A career as a data analyst also involves using programming languages, like R and Python, which are used a lot for statistical analysis, visualisation, and other data analysis.