{"id":10482,"date":"2024-08-21T08:57:33","date_gmt":"2024-08-21T08:57:33","guid":{"rendered":"https:\/\/emergingmarketft.com\/virtual_training\/?post_type=dt_courses&#038;p=10482"},"modified":"2024-08-21T09:01:29","modified_gmt":"2024-08-21T09:01:29","slug":"data-analysis-and-visualization","status":"publish","type":"dt_courses","link":"https:\/\/emergingmarketft.com\/virtual_training\/courses\/data-analysis-and-visualization\/","title":{"rendered":"Data Analysis and Visualization"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_empty_space height=&#8221;40px&#8221;]<div id=\"advanced-tabs-desc-wrap-5165\" class=\"ult_tabs \" style=\" \" data-tabsstyle=\"style1\"\r\n data-titlebg=\"#808080\" data-titlecolor=\"#ffffff\" data-fullheight=\"off\"\r\n data-titlehoverbg=\"#ffffff\" data-titlehovercolor=\"#808080\"\r\n data-rotatetabs=\"0\" data-responsivemode=\"Both\" data-animation=\"Slide\"\r\ndata-activetitle=\"#ffffff\" data-activeicon=\"\" data-activebg=\"#f99d20\"  data-respmode=\"Tabs\" data-respwidth=\"400\" data-scroll = \"on\" data-activeindex=\"1\"><ul id=advanced-tabs-wrap-4549 class=\"ult_tabmenu style1 Style_5\" style=\"color:transparent;border-bottom-color:transparent;border-bottom-width:0px;border-bottom-style:solid;border-bottom-width:0px;\"><li class=\"ult_tab_li ult_tab_style_5 \" data-iconcolor=\"#74777b\" data-iconhover=\"#ffffff\" style=\"background-color:#808080;border-top-left-radius:10px;\">\r\n\t\t\t\t\t<a href=\"#1589891825736-3\"  id=\"1589891825736-3\"  style=\"color:#ffffff;;border-color:#ffffff;   \" class=\"ult_a ult_tab_style_5 \">\r\n\t\t\t\t\t     <span class=\"ult_tab_main Both \">\r\n\t\t\t\t\t \t\t <span class=\"ult_tab_section\">\r\n\t\t\t\t\t   \t\t\t<span  data-ultimate-target='#advanced-tabs-wrap-4549 .ult-span-text'  data-responsive-json-new='{\"font-size\":\"desktop:15px;\",\"line-height\":\"\"}'  class=\"ult-span-text no_icon ult_tab_display_text ult-responsive\" style=\";\">Overview<\/span>\r\n\t\t\t\t\t   \t\t<\/span>\r\n\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t<\/a>\r\n\t\t\t\t\t<\/li><li class=\"ult_tab_li ult_tab_style_5 \" data-iconcolor=\"#74777b\" data-iconhover=\"#ffffff\" style=\"background-color:#808080;border-top-right-radius:10px;\">\r\n\t\t\t\t\t<a href=\"#1589891825767-0\"  id=\"1589891825767-0\"  style=\"color:#ffffff;;border-color:#ffffff;   \" class=\"ult_a ult_tab_style_5 \">\r\n\t\t\t\t\t     <span class=\"ult_tab_main Both \">\r\n\t\t\t\t\t \t\t <span class=\"ult_tab_section\">\r\n\t\t\t\t\t   \t\t\t<span  data-ultimate-target='#advanced-tabs-wrap-4549 .ult-span-text'  data-responsive-json-new='{\"font-size\":\"desktop:15px;\",\"line-height\":\"\"}'  class=\"ult-span-text no_icon ult_tab_display_text ult-responsive\" style=\";\">Course Outline<\/span>\r\n\t\t\t\t\t   \t\t<\/span>\r\n\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t<\/a>\r\n\t\t\t\t\t<\/li><\/ul><div  data-ultimate-target='#advanced-tabs-desc-wrap-5165 .ult_tabcontent .ult_tab_min_contain  p'  data-responsive-json-new='{\"font-size\":\"\",\"line-height\":\"\"}' class=\"ult_tabcontent ult-responsive style1\" style=\"color:#74777b;\"><div class=\"ult_tab_min_contain \" >\n\t\t\t<div  class=\"ult_tabitemname\"  >\n\t\t\t\t[vc_column_text]<\/p>\n<h3>Course Description<\/h3>\n<p data-ccp-props=\"{&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559683&quot;:0,&quot;335559685&quot;:0,&quot;335559731&quot;:0,&quot;335559737&quot;:0,&quot;335562764&quot;:2,&quot;335562765&quot;:1.14999,&quot;335562766&quot;:2,&quot;335562767&quot;:0,&quot;335562768&quot;:2,&quot;335562769&quot;:0}\"><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">This program is designed to help participants understand the key principles and <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">concepts of Data Analytics and Visualization. The\u00a0detailed content covering analytical <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">and visualization tools and techniques to interpret data is designed based on <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">industry related data they would analyze and interpret on MS Excel. <\/span>\u200b<\/p>\n<p data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559683&quot;:0,&quot;335559685&quot;:0,&quot;335559731&quot;:0,&quot;335559737&quot;:0,&quot;335562764&quot;:2,&quot;335562765&quot;:1,&quot;335562766&quot;:2,&quot;335562767&quot;:0,&quot;335562768&quot;:2,&quot;335562769&quot;:0}\"><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">Applying these principles on a case study with the guidance of an experienced <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">facilitator will help ensure the\u00a0best possible outcome for participants.<\/span>\u200b<\/p>\n<p>\u200b<\/p>\n<h3><b><span data-contrast=\"none\">Learning Outcome<\/span><\/b><\/h3>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Acquire an understanding of Data Analytics and its importance in the context of the organization&#8217;s industry.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Understand the application of Excel in Data Analytics and Visualization.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Acquire proficiency in crafting impactful dashboards for effective data representation.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Explore and grasp the array of Data Analysis tools within the Excel platform.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Develop the skills to navigate common pitfalls encountered in the process of conducting Data Analysis.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Investigate how various banks leverage Data Analysis through the analysis of real-world use case.<\/span>\u200b<\/li>\n<\/ul>\n<p>[\/vc_column_text]\n\t\t\t<\/div>\n\t\t\t<div  class=\"ult_tabitemname\"  >\n\t\t\t\t[vc_row_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<h4><strong>01. <span class=\"TextRun BCX8 SCXP52952499\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP52952499\">Overview of Data Analytics<\/span><\/span><span class=\"EOP SCXP171883538 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Why are we talking about data now? Industry 4.0 <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Value of data analytics to a business <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The role of data in decision making \u2013 what can and <\/span><span data-usefontface=\"false\" data-contrast=\"none\">can\u2019t we do with data? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The Five Data Types <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The case we are going to tackle during the course <\/span><\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>02. <span class=\"TextRun SCXP115373249 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP115373249 BCX8\">Principles of Data Analysis on Excel<\/span><\/span><span class=\"EOP SCXP115373249 BCX8\">\u200b<\/span><span class=\"EOP SCXP181976218 BCX8\">\u200b<\/span><\/b><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How does Excel see the world? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Navigating Excel\u2019s tools <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How to clean data so you and Excel can both <\/span><span data-usefontface=\"false\" data-contrast=\"none\">understand it <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Mastering Excel formulae <\/span>\u200b<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>03. <span class=\"TextRun SCXP180902231 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP180902231 BCX8\">Principles of Data Visualization and <\/span><\/span><span class=\"TextRun SCXP180902231 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP180902231 BCX8\">Dashboard Strategy<\/span><\/span><span class=\"EOP SCXP180902231 BCX8\">\u200b<\/span><span class=\"EOP SCXP111941606 BCX8\">\u200b<\/span><\/b><strong><span class=\"EOP SCXP203309297 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Why we create dashboards <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Storytelling in data <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Major steps in formulating a dashboard strategy <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The major types of visuals and the number of <\/span><span data-usefontface=\"false\" data-contrast=\"none\">parameters they require <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How to design a dashboard so it is understandable<\/span><\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>04. <span class=\"TextRun SCXP72830863 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP72830863 BCX8\">Review of the Case Study<\/span><\/span><span class=\"EOP SCXP72830863 BCX8\">\u200b<\/span><span class=\"EOP SCXP180902231 BCX8\">\u200b<\/span><span class=\"EOP SCXP111941606 BCX8\">\u200b<\/span><\/b><strong><span class=\"EOP SCXP203309297 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What is the business problem? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What are the questions we want to answer? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What sort of dashboard can answer these <\/span><span data-usefontface=\"false\" data-contrast=\"none\">questions? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What data do we need to create these visuals? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What challenges do we face on the data?\u00a0<\/span><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<h4><strong>05. <span class=\"TextRun SCXP56242669 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP56242669 BCX8\">Analyzing the Data<\/span><\/span><span class=\"EOP SCXP56242669 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data preparation <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data analysis using the various tools in Excel: <\/span>\u200b\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Toolpak<\/span> \u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Sort <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Filter <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Lookup <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"7\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Conditional formatting<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><strong>06. <span class=\"TextRun BCX8 SCXP117420732\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP117420732\">Avoiding Pitfalls and Mitigating <\/span><\/span><span class=\"TextRun BCX8 SCXP117420732\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP117420732\">Unforced Errors<\/span><\/span><span class=\"EOP SCXP160513642 BCX8\">\u200b<\/span><span class=\"EOP SCXP235333453 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data validation<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Theory overload<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Common pitfalls in Data Analytics<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Understanding your data<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Looking beyond the data<\/span>\u200b<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><strong><span class=\"EOP SCXP235333453 BCX8\">07. <span class=\"TextRun SCXP46360534 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP46360534 BCX8\">Graphs, Visualization and Assembling the Dashboard<\/span><\/span><span class=\"EOP SCXP46360534 BCX8\">\u200b<\/span><span class=\"EOP SCXP46639057 BCX8\">\u200b<\/span><span class=\"EOP SCXP232836006 BCX8\">\u200b<\/span>\u200b<\/span><\/strong><\/h4>\n<h4><\/h4>\n<h4><strong><span class=\"EOP SCXP235333453 BCX8\">08. <span class=\"TextRun BCX8 SCXP13603369\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP13603369\">Final Takeaways<\/span><\/span><\/span><\/strong><\/h4>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What further business areas can we use these <\/span><span data-usefontface=\"false\" data-contrast=\"none\">principles on? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Formulate an action plan on 3 areas where the data <\/span><span data-usefontface=\"false\" data-contrast=\"none\">analytics can help your role<\/span><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner]\n\t\t\t<\/div><\/div><\/div><\/div><div class=\"ult_acord advanced-tabs-desc-wrap-5165\">\r\n   <div class=\"ult-tabto-accordion \" style=\"width:;\"\r\n    data-titlecolor=\"#ffffff\"  data-titlebg=\"#808080\"\r\n     data-titlehoverbg=\"#ffffff\" data-titlehovercolor=\"#808080\" data-animation=\"Slide\"\r\n     data-activetitle=\"#ffffff\" data-activeicon=\"\" data-activebg=\"#f99d20\" data-scroll = \"on\" data-activeindex=\"1\" >\r\n     <dl><dt class=\"\">\r\n\t        \t<a class=\"ult-tabto-actitle withBorder ult_a \" id=\"1589891825736-3\" style=\"color:#ffffff;border-color:#ffffff;;background-color:#808080;border-bottom-color:transparent;border-bottom-width:0px;border-bottom-style:solid;\" href=\"#1589891825736-3\">\r\n\t        \t\t<i class=\"accordion-icon\"><\/i>\r\n\t        \t\t\t<span class=\"ult_tab_main ult_ac_main ult_noacordicnBoth\">\r\n\r\n\t\t\t\t\t\t<span  data-ultimate-target='#advanced-tabs-wrap-4549 .ult-span-text'  data-responsive-json-new='{\"font-size\":\"desktop:15px;\",\"line-height\":\"\"}'  class=\"ult-span-text no_icon ult_acordian-text ult-responsive\" style=\";color:inherit \" >Overview<\/span>\r\n\t\t\t\t\t\t<\/span><\/a><\/dt>\r\n\t            \t\t<dd class=\"ult-tabto-accordionItem ult-tabto-accolapsed\">\r\n\t\t\t\t            <div class=\"ult-tabto-acontent\" style=\"color:#74777b;\">\r\n\t\t\t\t               [vc_column_text]<\/p>\n<h3>Course Description<\/h3>\n<p data-ccp-props=\"{&quot;335551550&quot;:1,&quot;335551620&quot;:1,&quot;335559683&quot;:0,&quot;335559685&quot;:0,&quot;335559731&quot;:0,&quot;335559737&quot;:0,&quot;335562764&quot;:2,&quot;335562765&quot;:1.14999,&quot;335562766&quot;:2,&quot;335562767&quot;:0,&quot;335562768&quot;:2,&quot;335562769&quot;:0}\"><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">This program is designed to help participants understand the key principles and <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">concepts of Data Analytics and Visualization. The\u00a0detailed content covering analytical <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">and visualization tools and techniques to interpret data is designed based on <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">industry related data they would analyze and interpret on MS Excel. <\/span>\u200b<\/p>\n<p data-ccp-props=\"{&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559683&quot;:0,&quot;335559685&quot;:0,&quot;335559731&quot;:0,&quot;335559737&quot;:0,&quot;335562764&quot;:2,&quot;335562765&quot;:1,&quot;335562766&quot;:2,&quot;335562767&quot;:0,&quot;335562768&quot;:2,&quot;335562769&quot;:0}\"><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">Applying these principles on a case study with the guidance of an experienced <\/span><span data-scheme-color=\"@FFFFFF,0,\" data-usefontface=\"true\" data-contrast=\"none\">facilitator will help ensure the\u00a0best possible outcome for participants.<\/span>\u200b<\/p>\n<p>\u200b<\/p>\n<h3><b><span data-contrast=\"none\">Learning Outcome<\/span><\/b><\/h3>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Acquire an understanding of Data Analytics and its importance in the context of the organization&#8217;s industry.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Understand the application of Excel in Data Analytics and Visualization.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Acquire proficiency in crafting impactful dashboards for effective data representation.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Explore and grasp the array of Data Analysis tools within the Excel platform.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Develop the skills to navigate common pitfalls encountered in the process of conducting Data Analysis.<\/span>\u200b<\/li>\n<li data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Investigate how various banks leverage Data Analysis through the analysis of real-world use case.<\/span>\u200b<\/li>\n<\/ul>\n<p>[\/vc_column_text]\r\n\t\t\t\t            <\/div>\r\n\t        \t\t\t<\/dd><dt class=\"\">\r\n\t        \t<a class=\"ult-tabto-actitle withBorder ult_a \" id=\"1589891825767-0\" style=\"color:#ffffff;border-color:#ffffff;;background-color:#808080;border-bottom-color:transparent;border-bottom-width:0px;border-bottom-style:solid;border-bottom-color:transparent;border-bottom-width:0px;border-bottom-style:solid;\" href=\"#1589891825767-0\">\r\n\t        \t\t<i class=\"accordion-icon\"><\/i>\r\n\t        \t\t\t<span class=\"ult_tab_main ult_ac_main ult_noacordicnBoth\">\r\n\r\n\t\t\t\t\t\t<span  data-ultimate-target='#advanced-tabs-wrap-4549 .ult-span-text'  data-responsive-json-new='{\"font-size\":\"desktop:15px;\",\"line-height\":\"\"}'  class=\"ult-span-text no_icon ult_acordian-text ult-responsive\" style=\";color:inherit \" >Course Outline<\/span>\r\n\t\t\t\t\t\t<\/span><\/a><\/dt>\r\n\t            \t\t<dd class=\"ult-tabto-accordionItem ult-tabto-accolapsed\">\r\n\t\t\t\t            <div class=\"ult-tabto-acontent\" style=\"color:#74777b;\">\r\n\t\t\t\t               [vc_row_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<h4><strong>01. <span class=\"TextRun BCX8 SCXP52952499\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP52952499\">Overview of Data Analytics<\/span><\/span><span class=\"EOP SCXP171883538 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Why are we talking about data now? Industry 4.0 <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Value of data analytics to a business <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The role of data in decision making \u2013 what can and <\/span><span data-usefontface=\"false\" data-contrast=\"none\">can\u2019t we do with data? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The Five Data Types <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The case we are going to tackle during the course <\/span><\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>02. <span class=\"TextRun SCXP115373249 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP115373249 BCX8\">Principles of Data Analysis on Excel<\/span><\/span><span class=\"EOP SCXP115373249 BCX8\">\u200b<\/span><span class=\"EOP SCXP181976218 BCX8\">\u200b<\/span><\/b><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How does Excel see the world? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Navigating Excel\u2019s tools <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How to clean data so you and Excel can both <\/span><span data-usefontface=\"false\" data-contrast=\"none\">understand it <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Mastering Excel formulae <\/span>\u200b<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>03. <span class=\"TextRun SCXP180902231 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP180902231 BCX8\">Principles of Data Visualization and <\/span><\/span><span class=\"TextRun SCXP180902231 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP180902231 BCX8\">Dashboard Strategy<\/span><\/span><span class=\"EOP SCXP180902231 BCX8\">\u200b<\/span><span class=\"EOP SCXP111941606 BCX8\">\u200b<\/span><\/b><strong><span class=\"EOP SCXP203309297 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Why we create dashboards <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Storytelling in data <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Major steps in formulating a dashboard strategy <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">The major types of visuals and the number of <\/span><span data-usefontface=\"false\" data-contrast=\"none\">parameters they require <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">How to design a dashboard so it is understandable<\/span><\/li>\n<\/ul>\n<h4><\/h4>\n<h4><b>04. <span class=\"TextRun SCXP72830863 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP72830863 BCX8\">Review of the Case Study<\/span><\/span><span class=\"EOP SCXP72830863 BCX8\">\u200b<\/span><span class=\"EOP SCXP180902231 BCX8\">\u200b<\/span><span class=\"EOP SCXP111941606 BCX8\">\u200b<\/span><\/b><strong><span class=\"EOP SCXP203309297 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What is the business problem? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What are the questions we want to answer? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What sort of dashboard can answer these <\/span><span data-usefontface=\"false\" data-contrast=\"none\">questions? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What data do we need to create these visuals? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What challenges do we face on the data?\u00a0<\/span><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<h4><strong>05. <span class=\"TextRun SCXP56242669 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP56242669 BCX8\">Analyzing the Data<\/span><\/span><span class=\"EOP SCXP56242669 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data preparation <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data analysis using the various tools in Excel: <\/span>\u200b\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Toolpak<\/span> \u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Sort <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Filter <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Lookup <\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"7\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Conditional formatting<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><strong>06. <span class=\"TextRun BCX8 SCXP117420732\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP117420732\">Avoiding Pitfalls and Mitigating <\/span><\/span><span class=\"TextRun BCX8 SCXP117420732\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP117420732\">Unforced Errors<\/span><\/span><span class=\"EOP SCXP160513642 BCX8\">\u200b<\/span><span class=\"EOP SCXP235333453 BCX8\">\u200b<\/span><\/strong><\/h4>\n<ul style=\"font-weight: 400;\">\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Data validation<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Theory overload<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Common pitfalls in Data Analytics<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Understanding your data<\/span>\u200b<\/li>\n<li data-charcodes=\"8226\" data-font=\"Arial,Sans-Serif\" data-buautonum=\"8\" data-margin=\"270\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Looking beyond the data<\/span>\u200b<\/li>\n<\/ul>\n<h4><\/h4>\n<h4><strong><span class=\"EOP SCXP235333453 BCX8\">07. <span class=\"TextRun SCXP46360534 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun SCXP46360534 BCX8\">Graphs, Visualization and Assembling the Dashboard<\/span><\/span><span class=\"EOP SCXP46360534 BCX8\">\u200b<\/span><span class=\"EOP SCXP46639057 BCX8\">\u200b<\/span><span class=\"EOP SCXP232836006 BCX8\">\u200b<\/span>\u200b<\/span><\/strong><\/h4>\n<h4><\/h4>\n<h4><strong><span class=\"EOP SCXP235333453 BCX8\">08. <span class=\"TextRun BCX8 SCXP13603369\" lang=\"EN-US\" xml:lang=\"EN-US\" data-scheme-color=\"@273383,,\" data-usefontface=\"true\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXP13603369\">Final Takeaways<\/span><\/span><\/span><\/strong><\/h4>\n<ul>\n<li data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">What further business areas can we use these <\/span><span data-usefontface=\"false\" data-contrast=\"none\">principles on? <\/span>\u200b<\/li>\n<li data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-usefontface=\"false\" data-contrast=\"none\">Formulate an action plan on 3 areas where the data <\/span><span data-usefontface=\"false\" data-contrast=\"none\">analytics can help your role<\/span><\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner]\r\n\t\t\t\t            <\/div>\r\n\t        \t\t\t<\/dd>\r\n    \t<\/dl>\r\n    <!--<div class=\"extraborder\" style=\"background-color:#ffffff\"><\/div>-->\r\n<\/div>\r\n\r\n<\/div>[\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_empty_space height=&#8221;40px&#8221;][\/vc_column][\/vc_row]<\/p>\n","protected":false},"author":1,"featured_media":10484,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-10482","dt_courses","type-dt_courses","status-publish","has-post-thumbnail","hentry","course_category-data-analysis-and-visualization"],"acf":[],"_links":{"self":[{"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/dt_courses\/10482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/dt_courses"}],"about":[{"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/types\/dt_courses"}],"author":[{"embeddable":true,"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/comments?post=10482"}],"version-history":[{"count":1,"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/dt_courses\/10482\/revisions"}],"predecessor-version":[{"id":10483,"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/dt_courses\/10482\/revisions\/10483"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/media\/10484"}],"wp:attachment":[{"href":"https:\/\/emergingmarketft.com\/virtual_training\/wp-json\/wp\/v2\/media?parent=10482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}