DEV Community

Gabriel Njoroge
Gabriel Njoroge

Posted on

Tools Required for Data Analysis and Data Science

Basic Data Analyst Toolkit

  1. Excel-It is a spreadsheet tool widely used for Data Analysis. It helps analysts organize, clean, analyze and visualize data using tables, formulas and charts.
  2. Power BI-It is a Business Intelligence and Data Visualization tool used to analyze data and create interactive dashboards and reports
  3. Anaconda-It is a software platform used for Data Analysis, Data Science. It provides an easy way to install python, libraries and tools needed for Data Analysis e. g Jupyter Notebooks, Spyder.
  4. DBeaver-It is a free and open-source database management tool used by data analysts, data administrators to work with databases easily.
  5. Aiven-It is a cloud platform that provides fully managed open-source data services. It helps companies run databases and data tools without managing the servers themselves.
  6. Postgresql/Mysql-These are widely used databases for storing structured data.
  7. Github-It is an online platform to showcase your projects/portfolio
  8. GitBash-It is a terminal(command-line interface)that lets you run Git Commands and Linux-style commands on windows. It is installed together with Git. 9.VS Code-It is a free-code editor developed by Microsoft. It is widely used by developers, data analysts, and programmers to write, edit and run code.

Top comments (0)