In the context of this lesson, what are some tools that a data analyst uses?
Data analysts have a variety of tools that they use, which can depend on the task they must accomplish. A few of the tools which they utilize are as follows.
Probably one of the most important tools that a data analyst uses is a Database management system, such as MySQL, SQLite, or Oracle. Database management systems let data analysts write queries to perform things like create and manipulate databases, calculate aggregates, or combine multiple tables together. With this functionality, we can determine specific things such as the web traffic attribution of a site, or create usage funnels.
Another important tool that data analysts use is a programming language, such as R or Python, or usually both. These languages are used to perform more specific calculations used in statistics, or to create visualizations in the form of graphs and charts.