{"id":11685,"date":"2024-07-17T15:19:31","date_gmt":"2024-07-17T13:19:31","guid":{"rendered":"https:\/\/www.answerthecall.co.za\/learning\/?post_type=lp_course&#038;p=11685"},"modified":"2024-10-11T09:05:58","modified_gmt":"2024-10-11T07:05:58","slug":"data-analytics-essentials","status":"publish","type":"lp_course","link":"https:\/\/www.answerthecall.co.za\/learning\/course\/data-analytics-essentials\/","title":{"rendered":"Data Analytics Essentials"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"11685\" class=\"elementor elementor-11685\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d048d46 elementor-section-boxed elementor-section-height-default elementor-section-height-default exad-glass-effect-no exad-sticky-section-no\" data-id=\"d048d46\" data-element_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=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ac8087d exad-glass-effect-no exad-sticky-section-no\" data-id=\"ac8087d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bea06e7 exad-sticky-section-no exad-glass-effect-no elementor-widget elementor-widget-text-editor\" data-id=\"bea06e7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.14.0 - 26-06-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>Course Description:<\/strong><\/p><p>This data analytics essentials course teaches you the fundamental tools of a data analyst. You will learn to transform, organize, and visualize data with spreadsheet tools such as Excel. You will also learn how to query data from a relational database using SQL and how to improve your data presentations using powerful business intelligence tools like Tableau. By the end of the course, you will have an analytics portfolio complete with an analysis of the popular movies dataset, showcasing your skills in Excel, SQL and Tableau..<\/p><p><strong>What Skills Will You Learn?<\/strong><\/p><ul><li>You are able to create and share your project portfolio and you are aware of more advanced tools.<\/li><li>You recognize the prevalence of bias and ethical issues that arise from the misuse of data.<\/li><li>You are able to create a dashboard that provides data supported conclusions.<\/li><li>You are able to combine data from two or more tables using SQL.<\/li><li>You can perform basic queries using Structured Query Language (SQL) to analyze data.<\/li><li>You are able to use statistics and create visualizations to interpret data.<\/li><li>You can organize and transform data in Excel using advanced techniques to uncover data insights.<\/li><li>You can explain the characteristics of data and utilize Excel to perform basic data cleaning.<\/li><li>You are able to import data into Excel and perform simple calculations.<\/li><li>You research how to create a project portfolio with Github and start a blog.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29ff01d elementor-align-center exad-sticky-section-no exad-glass-effect-no elementor-widget elementor-widget-button\" data-id=\"29ff01d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/youtu.be\/vELQlA5g6xU\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Click here to learn more<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-3165737 elementor-section-boxed elementor-section-height-default elementor-section-height-default exad-glass-effect-no exad-sticky-section-no\" data-id=\"3165737\" data-element_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=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-26243d1 exad-glass-effect-no exad-sticky-section-no\" data-id=\"26243d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2720a37 elementor-widget__width-initial exad-sticky-section-no exad-glass-effect-no elementor-widget elementor-widget-image\" data-id=\"2720a37\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.14.0 - 26-06-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"640\" src=\"https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-1024x1024.png\" class=\"attachment-large size-large wp-image-10443\" alt=\"\" srcset=\"https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-1024x1024.png 1024w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-300x300.png 300w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-150x150.png 150w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-768x768.png 768w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-600x600.png 600w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f-100x100.png 100w, https:\/\/www.answerthecall.co.za\/learning\/wp-content\/uploads\/2024\/05\/52517717-589b-4c76-977d-27a53952379f.png 1216w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6808f57 exad-glass-effect-no exad-sticky-section-no\" data-id=\"6808f57\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Course Description:<br \/>\nThis data analytics essentials course teaches you the fundamental tools of a data analyst. You will learn to transform, organize, and visualize data with spreadsheet tools such as Excel. You will also learn how to query data from <\/p>\n","protected":false},"author":3,"featured_media":9870,"comment_status":"open","ping_status":"closed","template":"","course_category":[35],"course_tag":[112],"class_list":["post-11685","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-data-analytics","course_tag-data","pmpro-has-access","course"],"_links":{"self":[{"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/lp_course\/11685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/comments?post=11685"}],"version-history":[{"count":13,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/lp_course\/11685\/revisions"}],"predecessor-version":[{"id":12178,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/lp_course\/11685\/revisions\/12178"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/media\/9870"}],"wp:attachment":[{"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/media?parent=11685"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/course_category?post=11685"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/www.answerthecall.co.za\/learning\/wp-json\/wp\/v2\/course_tag?post=11685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}