{"id":167613,"date":"2023-04-11T10:10:00","date_gmt":"2023-04-11T09:10:00","guid":{"rendered":"https:\/\/liora.io\/en\/?p=167613"},"modified":"2026-02-06T09:04:45","modified_gmt":"2026-02-06T08:04:45","slug":"data-analyst-tools","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/data-analyst-tools","title":{"rendered":"What tools does a Data Analyst use on a daily basis?"},"content":{"rendered":"What is the job of a data analyst? There are many ways to answer this question:\n\nA data analyst is part storytelling scientist, part coder, and part business consultant.\n\nHe uses <b>different computer tools<\/b> <b>and codes <\/b>to extract data from various sources, analyzes this data by making sense of it, and presents these results often in a visual way. In this article, we will talk about several tools that a data analyst may use on a daily basis.\n\n<style><br \/>\n.elementor-column .elementor-spacer-inner{height:var(--spacer-size)}.e-con{--container-widget-width:100%}.e-con-inner>.elementor-widget-spacer,.e-con>.elementor-widget-spacer{width:var(--container-widget-width,var(--spacer-size));--align-self:var(--container-widget-align-self,initial);--flex-shrink:0}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container,.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer,.e-con>.elementor-widget-spacer>.elementor-widget-container,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer{height:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner{height:var(--container-widget-height,var(--spacer-size))}<\/style>\n<style><br \/>\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style>\n<h3>Data sources and queries<\/h3>\nTo access the data, the data analyst can use different tools. BigQuery allows for massive interactive analysis of large data sets in collaboration with the Google data warehouse.\n\nAmazon Redshift is a <a href=\"https:\/\/liora.io\/en\/data-warehouse-2\"><b>data warehouse<\/b><\/a> product that is part of the Amazon Web Services cloud computing platform. And the classic MySQL which is a relational database management system.\n\nMost of the time, to have access to data, we write queries in <a href=\"https:\/\/liora.io\/en\/sql-learn-all-about-the-programming-language-for-databases\"><b>SQL language<\/b><\/a> (Structured Language Query). Let&#8217;s say the company you work for has a large database with <b>different information<\/b> about customers, employees, partners, etc., and your manager wants to answer the following question: &#8220;What were the sales last quarter?&#8221;\n\nTo answer this question I may need to use SQL to <b>drill down<\/b> into the data and do further research.\n\nThe SQL language is used in <a href=\"https:\/\/liora.io\/en\/acid-in-database-management\"><b>DBMSs<\/b><\/a>, which are DataBase Management Systems. Among the data management systems are MySQL, PostgreSQL, ORACLE, SQL Server, etc. These systems allow you to use the SQL language to <b>manage databases<\/b>. Thanks to the SQL language you can: store data, and manipulate data (perform queries and procedures).\n\nTo simplify, SQL is a language that allows you to <b>link your computer and a DBMS<\/b>. A data analyst must be able to use SQL to access and analyze data.\n<h3>Processing data and displaying results<\/h3>\nNow that we have access to the data, we will <b>go through a data processing<\/b> and results display step. This time we would like to answer the following question: &#8220;Why was there such a <b>big difference<\/b> between the sales of the last two quarters?\n\nWe can try to answer this question using Excel, but if the database is much too large or we need to make more complex modifications, the <a href=\"https:\/\/liora.io\/en\/python-or-r-which-to-choose\"><b>Python or R languages<\/b><\/a> (not only) allow us to go further and study the data more flexibly.\n\n<a href=\"https:\/\/liora.io\/en\/python-the-most-popular-programming-language\"><b>Python is a versatile language<\/b><\/a> that is quite easy to use and learn. It has many libraries for scientific computing and if you already work for a company, it is likely that the company already uses it for other tasks.\n\nAnaconda is a distribution of the Python and R programming languages for <b>scientific computing<\/b>, which aims to simplify package management and deployment. The distribution includes packages for Windows, Linux, and macOS.\n\n<a href=\"https:\/\/liora.io\/en\/pandas-the-python-library\"><b>Pandas<\/b><\/a> is an open-source Python library that is most widely used for <b>data science<\/b>, data analysis, and <b>machine learning tasks<\/b>. The library is built on top of another library called <a href=\"https:\/\/liora.io\/en\/numpy-the-python-library-in-data-science\"><b>Numpy<\/b><\/a>, which provides support for multidimensional arrays. Pandas is one of the most popular data processing packages and works well with <b>many other data science modules<\/b> in the Python ecosystem.&nbsp;\n\nThe stats models package has functions that allow you to do more <b>advanced statistics<\/b> on data. If we are looking for data that is accessible on websites we can do <b>web scraping<\/b> with the Selenium library.&nbsp;\n\nTo sum up, Python allows you to do a lot of different things and that&#8217;s why it&#8217;s one of the <b>most popular languages<\/b> in the data world today.\n<h3>Low-code and No-code tools<\/h3>\nLow\/no-code platforms provide a development environment used to create software applications through a graphical user interface.&nbsp;\n\nAmong these tools, <b>Bubble<\/b> makes it possible to program complex applications and websites without coding, while the <b>Microsoft Power Platform<\/b> range of software applications enables application development and application connectivity.\n\nOne of the main advantages of <b>low\/no code tools<\/b> is that you save development time to get a working application that meets a need.\n<h3>Visualization Dashboards<\/h3>\nAfter several steps, we would like to create a <b>dashboard<\/b> for the whole team so that everyone can follow the analysis.\n\nWith the recovered data we can display graphs that allow us to transmit relevant information to people who are not necessarily comfortable with code.\n\n<b>Power BI<\/b> is an interactive reporting platform. It can easily handle a wide variety of data types and <b>massive amounts of data<\/b>.\n\nOne can use PowerBI either to create reports, work with data, or simply visualize reports to make decisions.\n\n<b>Kibana is a data visualization extension<\/b> for Elasticsearch. It allows you to search and visualize data indexed in Elasticsearch.&nbsp;\n\nOne of the hottest solutions right now is<b> Amazon QuickSight<\/b>, which allows users to query data in natural language to generate visualizations in just seconds.\n\nSo now you know more about the tools that data analysts use daily.\n\nAnd if you want to learn more about the <a href=\"https:\/\/liora.io\/en\/data-analyst-job-description\"><b>Data Analyst job<\/b><\/a>, check out our training page!\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><div class=\"wp-block-button \"><a class=\"wp-block-button__link wp-element-button \" href=\"\/en\/courses\/data-ai\/data-analyst\">Discover our Data Analyst training<\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is the job of a data analyst? There are many ways to answer this question: A data analyst is part storytelling scientist, part coder, and part business consultant. He uses different computer tools and codes to extract data from various sources, analyzes this data by making sense of it, and presents these results often [&hellip;]<\/p>\n","protected":false},"author":80,"featured_media":167614,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-167613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/167613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=167613"}],"version-history":[{"count":1,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/167613\/revisions"}],"predecessor-version":[{"id":206428,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/167613\/revisions\/206428"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/167614"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=167613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=167613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}