{"id":1085,"date":"2022-07-31T11:30:52","date_gmt":"2022-07-31T15:30:52","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1085"},"modified":"2022-07-31T11:30:52","modified_gmt":"2022-07-31T15:30:52","slug":"data-analysis-what-to-learn","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1085","title":{"rendered":"Data Analysis: What to Learn"},"content":{"rendered":"<ol>\n<li>Applied <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=statistics\">statistics<\/a> (not software, but good old math) including general understanding of machine learning (artificial intelligence).<\/li>\n<li>R and\/or <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=Python\">Python<\/a> with libraries like <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=numpy\">NumPy<\/a> and\/or <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=pandas\">pandas<\/a>.<\/li>\n<li>Structured Query Language (SQL) with a broad understanding of <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=extensions\">extensions<\/a> (vendor-specific <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=syntax\">syntax<\/a>) depending on the relational database management system (<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=RDBM\">RDBMS<\/a>) that the company (your employer) has like <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=Oracle\">Oracle<\/a>, <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=MySQL\">MySQL<\/a>, <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=PostgreSQL\">PostgreSQL<\/a> and\/or <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=SQL+Server\">SQL Server<\/a>.<\/li>\n<li>Data <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=visualization\">visualization<\/a> applications like Tableau, SSRS and\/or Crystal Reports.<\/li>\n<li>Data <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/?s=normalization\">normalization<\/a> (how to clean dirty data using SQL).<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Applied statistics (not software, but good old math) including general understanding of machine learning (artificial intelligence). R and\/or Python with libraries like NumPy and\/or pandas. Structured Query Language (SQL) with a broad understanding of extensions (vendor-specific syntax) depending on the relational database management system (RDBMS) that the company (your employer) has like Oracle, MySQL, PostgreSQL [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[3,1,17,2],"tags":[],"class_list":["post-1085","post","type-post","status-publish","format-standard","hentry","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1085"}],"version-history":[{"count":5,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions"}],"predecessor-version":[{"id":1090,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1085\/revisions\/1090"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}