{"id":2278,"date":"2020-02-24T04:34:35","date_gmt":"2020-02-24T04:34:35","guid":{"rendered":"http:\/\/kusuaks7\/?p=1883"},"modified":"2024-01-04T10:46:05","modified_gmt":"2024-01-04T10:46:05","slug":"most-in-demand-tech-skills-for-data-analysts","status":"publish","type":"post","link":"https:\/\/www.experfy.com\/blog\/bigdata-cloud\/most-in-demand-tech-skills-for-data-analysts\/","title":{"rendered":"Most In Demand Tech Skills for Data Analysts"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2278\" class=\"elementor elementor-2278\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-591e6885 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"591e6885\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-74d959b8\" data-id=\"74d959b8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d6df17f elementor-widget elementor-widget-heading\" data-id=\"d6df17f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><h3 style=\"color: #aaa;font-style: italic\">Which technology skills are employers looking for in data analysts? How do they compare to the skills desired for data engineers and data scientists?<\/h3><\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-c18fe0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c18fe0c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bedba25\" data-id=\"bedba25\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d81021f elementor-widget elementor-widget-image\" data-id=\"d81021f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efabca1 elementor-widget elementor-widget-text-editor\" data-id=\"efabca1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"1b05\" data-selectable-paragraph=\"\">I analyzed online job listings from January 2020 to find the answers. In this article, I\u2019ll share the answers and provide a suggested learning path for aspiring data analysts.<\/p>\n<p id=\"7d5a\" data-selectable-paragraph=\"\">This is my third article looking at technology skills in data-intensive positions. See the previous articles on data scientists here\u00a0and data engineers here.<\/p>\n<p id=\"8bfc\" data-selectable-paragraph=\"\">Without further ado, here are the top 10 technologies from data analyst job listings as of January 2020.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0283a4d elementor-widget elementor-widget-image\" data-id=\"0283a4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-245305d elementor-widget elementor-widget-heading\" data-id=\"245305d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><h2 id=\"ef5f\" data-selectable-paragraph=\"\">Data Analyst Role<\/h2>\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04e4927 elementor-widget elementor-widget-text-editor\" data-id=\"04e4927\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"8ade\" data-selectable-paragraph=\"\">Data analysts turn data into information. They play a vital role by making data actionable for decision makers.<\/p>\n<p id=\"3275\" data-selectable-paragraph=\"\">Data analysts often take data provided by data engineers, analyze it, and make recommendations. They create visualizations to display their findings in dashboards and presentation.<\/p>\n<p id=\"ac09\" data-selectable-paragraph=\"\">Unlike data scientists, data analysts don\u2019t usually create predictive models based on machine learning algorithms.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ffada3b elementor-widget elementor-widget-heading\" data-id=\"ffada3b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\"><h1 id=\"0123\" data-selectable-paragraph=\"\">Method<\/h1>\n<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e0040e elementor-widget elementor-widget-text-editor\" data-id=\"8e0040e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"20ad\" data-selectable-paragraph=\"\">I scraped information from\u00a0<a href=\"https:\/\/www.simplyhired.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\" class=\"broken_link\">SimplyHired<\/a>,\u00a0<a href=\"https:\/\/www.indeed.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\" class=\"broken_link\">Indeed<\/a>, and\u00a0<a href=\"https:\/\/www.monster.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\" class=\"broken_link\">Monster<\/a>, to see which keywords appeared with \u201cData Analyst\u201d in job listings in the United States. I used the\u00a0<a href=\"https:\/\/requests.readthedocs.io\/en\/master\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Requests<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.crummy.com\/software\/BeautifulSoup\/bs4\/doc\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Beautiful Soup<\/a>\u00a0Python libraries.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e999d33 elementor-widget elementor-widget-image\" data-id=\"e999d33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85a0c07 elementor-widget elementor-widget-image\" data-id=\"85a0c07\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aef15d5 elementor-widget elementor-widget-image\" data-id=\"aef15d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0668bff elementor-widget elementor-widget-text-editor\" data-id=\"0668bff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"3984\" data-selectable-paragraph=\"\">I used the same keywords gleaned from my analysis of\u00a0<a href=\"https:\/\/towardsdatascience.com\/the-most-in-demand-tech-skills-for-data-scientists-d716d10c191d\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">data scientist<\/a>\u00a0and\u00a0<a href=\"https:\/\/towardsdatascience.com\/most-in-demand-tech-skills-for-data-engineers-58f4c1ca25ab\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">data engineer<\/a>\u00a0job listings. LinkedIn was not searched because it previously locked me out of my account after scraping its site.<\/p>\n<p id=\"4069\" data-selectable-paragraph=\"\">For each job search website, I calculated the percentage of total data analyst job listings for that site that each keyword appeared in. Then I averaged those percentages across the three sites for each keyword.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4b419b elementor-widget elementor-widget-heading\" data-id=\"c4b419b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\"><h1 id=\"09e2\" data-selectable-paragraph=\"\">Results<\/h1><\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84ccb68 elementor-widget elementor-widget-text-editor\" data-id=\"84ccb68\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"7f33\" data-selectable-paragraph=\"\">Here is an expanded chart showing the 30 most common technologies.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef571b5 elementor-widget elementor-widget-image\" data-id=\"ef571b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-507f90a elementor-widget elementor-widget-text-editor\" data-id=\"507f90a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"11e2\" data-selectable-paragraph=\"\">Here\u2019s the same data in tabular form.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b57f374 elementor-widget elementor-widget-image\" data-id=\"b57f374\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65591b8 elementor-widget elementor-widget-text-editor\" data-id=\"65591b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"678f\" data-selectable-paragraph=\"\">Many other technology keywords were searched; these were the 30 highest scoring. Let\u2019s look at the most common technologies.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea02271 elementor-widget elementor-widget-heading\" data-id=\"ea02271\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\"><h1 id=\"22be\" data-selectable-paragraph=\"\">Discussion<\/h1><\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1cd8a32 elementor-widget elementor-widget-image\" data-id=\"1cd8a32\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c34f6c5 elementor-widget elementor-widget-text-editor\" data-id=\"c34f6c5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"74f1\" data-selectable-paragraph=\"\"><a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">SQL<\/a>\u00a0is short for Structured Query Language. It shows up in over half of all listings. SQL is used for working with relational databases. SQL comes in many flavors, including MySQL, Oracle, SQL Server, PostgreSQL, and SQLite. Each version shares most of the same core API. There are quality free offerings.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0829429 elementor-widget elementor-widget-image\" data-id=\"0829429\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-068ab0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"068ab0c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ea5938c\" data-id=\"ea5938c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-786d33a elementor-widget elementor-widget-text-editor\" data-id=\"786d33a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"1dde\" data-selectable-paragraph=\"\">Excel is almost as common as SQL. It\u2019s the dominant spreadsheet program. It\u2019s part of the\u00a0<a href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Microsoft Office 365<\/a>\u00a0suite of software tools. Although it can\u2019t handle huge quantities of data like SQL databases, Excel is great for doing analysis quickly.\u00a0<a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Google Sheets<\/a>\u00a0is a competitor with a free version and similar core functionality.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-432660e elementor-widget elementor-widget-image\" data-id=\"432660e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f648e38 elementor-widget elementor-widget-text-editor\" data-id=\"f648e38\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"c4a3\" data-selectable-paragraph=\"\"><a href=\"https:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\" class=\"broken_link\">Tableau<\/a>\u00a0shows up in about a quarter of listings. It\u2019s drag-and-drop business intelligence software that makes it easy to create visualizations and dashboards. Tableau\u2019s visualization capabilities are far better than Excel\u2019s. Tableau has a free public version, but if you want to keep data private you need to shell out some money.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f00a6f8 elementor-widget elementor-widget-image\" data-id=\"f00a6f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc2da11 elementor-widget elementor-widget-text-editor\" data-id=\"fc2da11\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"1896\" data-selectable-paragraph=\"\"><a href=\"https:\/\/www.python.org\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Python<\/a>\u00a0shows up in about a quarter of listings. It\u2019s a very popular free open source programming language for working with data, websites, and scripting. It\u2019s the primary language for machine learning.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9302af3 elementor-widget elementor-widget-image\" data-id=\"9302af3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b19802a elementor-widget elementor-widget-text-editor\" data-id=\"b19802a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"4023\" data-selectable-paragraph=\"\"><a href=\"https:\/\/www.r-project.org\/about.html\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">R<\/a>\u00a0is also in over 20% of listings. It\u2019s a popular free open source language for statistics, especially in academia.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8ea8c3b elementor-widget elementor-widget-heading\" data-id=\"8ea8c3b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\"><h1 id=\"d702\" data-selectable-paragraph=\"\">Comparison with Data Engineer and Data Scientist<\/h1><\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-4a0256a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4a0256a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ae1b082\" data-id=\"ae1b082\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3401f50 elementor-widget elementor-widget-text-editor\" data-id=\"3401f50\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"ff9f\" data-selectable-paragraph=\"\">In previous articles I looked at the most in demand tech skills for\u00a0<a href=\"https:\/\/towardsdatascience.com\/the-most-in-demand-tech-skills-for-data-scientists-d716d10c191d?source=post_stats_page---------------------------\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">data scientists<\/a>\u00a0and\u00a0<a href=\"https:\/\/towardsdatascience.com\/most-in-demand-tech-skills-for-data-engineers-58f4c1ca25ab\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">data engineers<\/a>. How do the data analyst results compare?<\/p>\n<p id=\"f9c8\" data-selectable-paragraph=\"\">The overall number of listings were 16,325 for\u00a0<em>Data Analyst<\/em>, for 12,013 for\u00a0<em>Data Engineer<\/em>, and 9,396 for\u00a0<em>Data Scientist.\u00a0<\/em>So data analyst jobs are relatively common.<\/p>\n<p id=\"11a9\" data-selectable-paragraph=\"\">The chart below shows the 10 most common technologies for data analyst listings. The scores for data scientist and data engineer listings are shown for each keyword, too.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97dce30 elementor-widget elementor-widget-image\" data-id=\"97dce30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-940cb58 elementor-widget elementor-widget-text-editor\" data-id=\"940cb58\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n \t<li id=\"d895\" data-selectable-paragraph=\"\">SQL is very popular for all three job positions.<\/li>\n \t<li id=\"1119\" data-selectable-paragraph=\"\">Excel is over four times more common in data analyst listings than data scientist and data engineer listings.<\/li>\n \t<li id=\"2d21\" data-selectable-paragraph=\"\">Python, while found in about a quarter of data analyst listings, is about three times more popular in data scientist and data engineer job listings.<\/li>\n \t<li id=\"5a42\" data-selectable-paragraph=\"\">R is much less common in data analyst and data engineer positions than in data scientist job listings.<\/li>\n \t<li id=\"fea6\" data-selectable-paragraph=\"\">PowerPoint is much more commonly found in data analyst listings.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f4a4f0 elementor-widget elementor-widget-text-editor\" data-id=\"5f4a4f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"b589\" data-selectable-paragraph=\"\">In terms of trends, my\u00a0<a href=\"https:\/\/towardsdatascience.com\/the-most-in-demand-tech-skills-for-data-scientists-d716d10c191d\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">analysis of data scientist job listings<\/a>\u00a0showed that both R and SAS had large drops in popularity from 2018 to 2019.<\/p>\n<p id=\"ebe6\" data-selectable-paragraph=\"\">It\u2019s worth noting that many more technologies were mentioned in data engineer job listings than were mentioned in data analyst job listings.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7072a17 elementor-widget elementor-widget-heading\" data-id=\"7072a17\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\"><h1 id=\"0390\" data-selectable-paragraph=\"\">Advice<\/h1>\n<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-6d09e73 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d09e73\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5577df3\" data-id=\"5577df3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d6bfe35 elementor-widget elementor-widget-text-editor\" data-id=\"d6bfe35\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"208e\" data-selectable-paragraph=\"\">If you want to become a data analyst or make yourself more marketable, I suggest you learn the following technologies, in order of priority.<\/p>\n<p id=\"56ba\" data-selectable-paragraph=\"\">Learn\u00a0<strong>Excel<\/strong>. It\u2019s quicker to pick up than SQL. I knew Excel from school and work, but I learned it better by studying for a Microsoft Excel certification exam. If you are a self-directed learner,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/mos-excel-2019\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">the official certification<\/a>\u00a0or a MOOC course could be worth your time.<\/p>\n<p id=\"b2d9\" data-selectable-paragraph=\"\">Learn\u00a0<strong>SQL<\/strong>. If you don\u2019t know a programming language, it\u2019s a good first one to learn. .<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-559c865 elementor-widget elementor-widget-image\" data-id=\"559c865\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb685c6 elementor-widget elementor-widget-text-editor\" data-id=\"cb685c6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"5c67\" data-selectable-paragraph=\"\">Learn\u00a0<strong>Tableau<\/strong>. Tableau allows you to make great visualizations quickly with a drag and drop interface. .<\/p>\n<p id=\"0aee\" data-selectable-paragraph=\"\">Show you can make a\u00a0<strong>PowerPoint<\/strong>\u00a0presentation. There are many MOOCs that teach Microsoft PowerPoint.<\/p>\n<p id=\"8628\" data-selectable-paragraph=\"\">If you have demonstrated you can use the above technologies to analyze and communicate you should be a decent candidate for many entry level positions.<\/p>\n<p id=\"18f0\" data-selectable-paragraph=\"\">If you know the above skills and want to learn new skills or qualify for more positions, I suggest you learn\u00a0<strong>Python<\/strong>. Python is great if you want to move into data engineering and data science.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0549286 elementor-widget elementor-widget-text-editor\" data-id=\"0549286\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"50fb\" data-selectable-paragraph=\"\">My\u00a0<a href=\"https:\/\/memorablepython.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Memorable Python<\/a>\u00a0book is designed for beginners. It\u2019s available for Kindle and hard copy from\u00a0<a href=\"https:\/\/www.amazon.com\/Memorable-Python-Learn-Faster-ebook\/dp\/B07ZXJKKSN\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">Amazon<\/a>\u00a0and in .epub and .pdf form\u00a0<a href=\"https:\/\/memorablepython.com\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">here<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a81bd6 elementor-widget elementor-widget-image\" data-id=\"7a81bd6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d3ddad elementor-widget elementor-widget-text-editor\" data-id=\"1d3ddad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"8b86\" data-selectable-paragraph=\"\">Once you know basic Python, learn\u00a0<a href=\"https:\/\/pandas.pydata.org\/\" target=\"_blank\" rel=\"noopener nofollow noreferrer\"><strong>pandas<\/strong><\/a>. Pandas is<strong>\u00a0<\/strong>a Python library for working with data. If you are looking for a data job that requires Python, you will probably be expected to have pandas skills, too.<\/p><p style=\"text-align: center;\" data-selectable-paragraph=\"\">\u00a0<\/p><p id=\"12cb\" data-selectable-paragraph=\"\">\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46d09e0 elementor-widget elementor-widget-image\" data-id=\"46d09e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2020\/02\/Home-448x253_5.png\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fbb29cd elementor-widget elementor-widget-text-editor\" data-id=\"fbb29cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"12cb\" data-selectable-paragraph=\"\">That might sound like a long list, but just take it one step at a time. Recognize that it will take time and there will be ups and downs. You can do it \u2014 just persist!<\/p>\n<p id=\"bf78\" data-selectable-paragraph=\"\">I suggest you learn and demonstrate your skills by working on projects you can include in a personal portfolio. Then you can learn by doing things you like! You\u2019ll also have a body of work that shows potential employers your skills. For a quick guide to setting up a portfolio site, see\u00a0<a href=\"https:\/\/towardsdatascience.com\/build-a-portfolio-website-in-a-flash-9d5ec30a73a7\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">this article<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1804811 elementor-widget elementor-widget-heading\" data-id=\"1804811\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">\n<h1 id=\"7660\" data-selectable-paragraph=\"\">Wrap<\/h1><\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19167df elementor-widget elementor-widget-text-editor\" data-id=\"19167df\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"841f\" data-selectable-paragraph=\"\">I hope you found this guide to the most in demand technologies for data analysts useful.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Data analysts turn data into information. They play a vital role by making data actionable for decision makers. &nbsp;Data analysts often take data provided by data engineers, analyze it, and make recommendations. They create visualizations to display their findings in dashboards and presentation. &nbsp;Unlike data scientists, data analysts don&rsquo;t usually create predictive models based on machine learning algorithms.If you want to become a data analyst or make yourself more marketable, this article suggests you learn the certain technologies, in order of priority.<\/p>\n","protected":false},"author":369,"featured_media":23695,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-post-2.php","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[187],"tags":[94],"ppma_author":[2134],"class_list":["post-2278","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bigdata-cloud","tag-data-science"],"authors":[{"term_id":2134,"user_id":369,"is_guest":0,"slug":"jeff-hale","display_name":"Jeff Hale","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","user_url":"","last_name":"Hale","first_name":"Jeff","job_title":"","description":"Jeff Hale is a co-founder of Rebel Desk, where he oversees technology, finance, and operations for this company. He&nbsp;is an experienced entrepreneur who has managed technology, operations, and finances for several companies.&nbsp;"}],"_links":{"self":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/2278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/users\/369"}],"replies":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/comments?post=2278"}],"version-history":[{"count":7,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/2278\/revisions"}],"predecessor-version":[{"id":35382,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/2278\/revisions\/35382"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media\/23695"}],"wp:attachment":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media?parent=2278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/categories?post=2278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/tags?post=2278"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=2278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}