{"id":5130,"date":"2024-11-26T06:42:20","date_gmt":"2024-11-26T06:42:20","guid":{"rendered":"https:\/\/coursesmantra.com\/?post_type=lp_course&#038;p=5130"},"modified":"2024-11-28T09:36:33","modified_gmt":"2024-11-28T09:36:33","slug":"data-analytics","status":"publish","type":"lp_course","link":"https:\/\/coursesmantra.com\/?lp_course=data-analytics","title":{"rendered":"Data Analytics"},"content":{"rendered":"<h4 id=\"ms_cc1\">1. About Data Analytics<\/h4>\n<ul>\n<li>Unlock the power of data with our Data Analytics Fundamentals course! In today&#8217;s data-driven world, organisations rely on skilled data analysts to make informed decisions and gain a competitive edge. This course is designed to equip you with the essential knowledge and practical skills needed to excel in the field of data analytics.<\/li>\n<\/ul>\n<h4 id=\"ms_cc1\">2. Excel(Basic+Advanced)<\/h4>\n<ul>\n<li>Introduction<\/li>\n<li>Basic Data Entry in Excel<\/li>\n<li>Basic calculation using (Sum, Subtract, Division, Multiplication, Percentage)<\/li>\n<li>Intermediate Excel formula use case (sum if, count if, Average if,Mod , Floor, Ceiling, Mod, power, max, min,len etc)<\/li>\n<li>Conditional Formating<\/li>\n<li>Different filter option<\/li>\n<li>Duplication identification and removal<\/li>\n<li>VLOOKUP<\/li>\n<li>Xlookup<\/li>\n<li>IF, ELSE, Nested if with different logical operators<\/li>\n<li>Time intelligence formula and use case<\/li>\n<li>Data cleaning using (Right, Left, Mid,Trim)<\/li>\n<li>Power query for data modelling and data cleaning<\/li>\n<li>Pivot table and Pivot chat<\/li>\n<li>Use of Slicer with different Pivot chat<\/li>\n<li>Data extrac????on, Transforma????on and load<\/li>\n<li>Creating pivot using two or multiple sheets<\/li>\n<li>Data-modelling and data connection<\/li>\n<li>Basic statistics<\/li>\n<li>Project based on sales data , procurement data , financial data from scratch ( that include Data cleaning , Vlookup, Pivot table and Pivot chat).<\/li>\n<\/ul>\n<h4 id=\"ms_cc2\">3. Power Bi<\/h4>\n<ul>\n<li>Overview of Power bi<\/li>\n<li>Use case of Power bi<\/li>\n<li>Data injection in power bi<\/li>\n<li>ETL Using Power query<\/li>\n<li>Table connection<\/li>\n<li>Creating Measure and Calculated Columns using DAX<\/li>\n<li>Use case of Various chat in power query<\/li>\n<li>Time intelligence use case and formula<\/li>\n<\/ul>\n<h4 id=\"ms_cc2\">4. SQL(Structure Query Language)<\/h4>\n<ul>\n<li>Overview of SQL.<\/li>\n<li>Overview of Database<\/li>\n<li>Difference b\/w OLAP and OLTP<\/li>\n<li>Basic SQL query<\/li>\n<li>Use of where clause, group by clause, logic operator , sort by ,in , between<\/li>\n<li>Various joint of SQL (Le????, Right, Full, Union)<\/li>\n<li>Nested query<\/li>\n<li>Window func????on<\/li>\n<li>Creating function<\/li>\n<li>Temporary Table.<\/li>\n<\/ul>\n<h4 id=\"ms_cc2\">5. Python for DataAnalyics<\/h4>\n<ul>\n<li>Basic python<\/li>\n<li>Different type of datatype<\/li>\n<li>List and it\u2019s opera????on (indexing, appending, slicing upda????ng.)<\/li>\n<li>Tuple<\/li>\n<li>Dictionary<\/li>\n<li>Set<\/li>\n<li>For and while loops<\/li>\n<li>Lambda map, reducer,zip functions<\/li>\n<li>Pandas, Numpy , Matplotlib ,seabon package<\/li>\n<li>Importing data from excel, csv, mysql<\/li>\n<li>Performing various analytics task such as handling null value, Casting datatype, extracting data , custom column creating , exporting data into excel . creating various graph using matplotlib and seaborn<\/li>\n<\/ul>\n<h4 id=\"ms_cc2\">6. Other support<\/h4>\n<ul>\n<li>Resume building<\/li>\n<li>Moc interview<\/li>\n<li>Linkedin account creating<\/li>\n<li>Github repository creation<\/li>\n<li>Migration of project into github<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. About Data Analytics Unlock the power of data with our Data Analytics Fundamentals course! In today&#8217;s data-driven world, organisations [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5546,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"course_category":[29],"course_tag":[],"class_list":["post-5130","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-courses","course"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Analytics - Coursesmantra<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/coursesmantra.com\/?lp_course=data-analytics\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Analytics - Coursesmantra\" \/>\n<meta property=\"og:description\" content=\"1. About Data Analytics Unlock the power of data with our Data Analytics Fundamentals course! In today&#8217;s data-driven world, organisations [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/coursesmantra.com\/?lp_course=data-analytics\" \/>\n<meta property=\"og:site_name\" content=\"Coursesmantra\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-28T09:36:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/coursesmantra.com\/wp-content\/uploads\/2024\/11\/Data-Analytics-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics\",\"url\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics\",\"name\":\"Data Analytics - Coursesmantra\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/coursesmantra.com\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Data-Analytics-1.jpg\",\"datePublished\":\"2024-11-26T06:42:20+00:00\",\"dateModified\":\"2024-11-28T09:36:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics#primaryimage\",\"url\":\"https:\\\/\\\/coursesmantra.com\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Data-Analytics-1.jpg\",\"contentUrl\":\"https:\\\/\\\/coursesmantra.com\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/Data-Analytics-1.jpg\",\"width\":1000,\"height\":700},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/?lp_course=data-analytics#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/coursesmantra.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Courses\",\"item\":\"https:\\\/\\\/coursesmantra.com\\\/?post_type=lp_course\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#website\",\"url\":\"https:\\\/\\\/coursesmantra.com\\\/\",\"name\":\"Coursesmantra\",\"description\":\"Courses Site\",\"publisher\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/coursesmantra.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#organization\",\"name\":\"Coursesmantra\",\"url\":\"https:\\\/\\\/coursesmantra.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/coursesmantra.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/logo.jpg\",\"contentUrl\":\"http:\\\/\\\/coursesmantra.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/logo.jpg\",\"width\":1000,\"height\":1000,\"caption\":\"Coursesmantra\"},\"image\":{\"@id\":\"https:\\\/\\\/coursesmantra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Analytics - Coursesmantra","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/coursesmantra.com\/?lp_course=data-analytics","og_locale":"en_US","og_type":"article","og_title":"Data Analytics - Coursesmantra","og_description":"1. About Data Analytics Unlock the power of data with our Data Analytics Fundamentals course! In today&#8217;s data-driven world, organisations [&hellip;]","og_url":"https:\/\/coursesmantra.com\/?lp_course=data-analytics","og_site_name":"Coursesmantra","article_modified_time":"2024-11-28T09:36:33+00:00","og_image":[{"width":1000,"height":700,"url":"https:\/\/coursesmantra.com\/wp-content\/uploads\/2024\/11\/Data-Analytics-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics","url":"https:\/\/coursesmantra.com\/?lp_course=data-analytics","name":"Data Analytics - Coursesmantra","isPartOf":{"@id":"https:\/\/coursesmantra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics#primaryimage"},"image":{"@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics#primaryimage"},"thumbnailUrl":"https:\/\/coursesmantra.com\/wp-content\/uploads\/2024\/11\/Data-Analytics-1.jpg","datePublished":"2024-11-26T06:42:20+00:00","dateModified":"2024-11-28T09:36:33+00:00","breadcrumb":{"@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/coursesmantra.com\/?lp_course=data-analytics"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics#primaryimage","url":"https:\/\/coursesmantra.com\/wp-content\/uploads\/2024\/11\/Data-Analytics-1.jpg","contentUrl":"https:\/\/coursesmantra.com\/wp-content\/uploads\/2024\/11\/Data-Analytics-1.jpg","width":1000,"height":700},{"@type":"BreadcrumbList","@id":"https:\/\/coursesmantra.com\/?lp_course=data-analytics#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/coursesmantra.com\/"},{"@type":"ListItem","position":2,"name":"Courses","item":"https:\/\/coursesmantra.com\/?post_type=lp_course"},{"@type":"ListItem","position":3,"name":"Data Analytics"}]},{"@type":"WebSite","@id":"https:\/\/coursesmantra.com\/#website","url":"https:\/\/coursesmantra.com\/","name":"Coursesmantra","description":"Courses Site","publisher":{"@id":"https:\/\/coursesmantra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/coursesmantra.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/coursesmantra.com\/#organization","name":"Coursesmantra","url":"https:\/\/coursesmantra.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/coursesmantra.com\/#\/schema\/logo\/image\/","url":"http:\/\/coursesmantra.com\/wp-content\/uploads\/2025\/01\/logo.jpg","contentUrl":"http:\/\/coursesmantra.com\/wp-content\/uploads\/2025\/01\/logo.jpg","width":1000,"height":1000,"caption":"Coursesmantra"},"image":{"@id":"https:\/\/coursesmantra.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/lp_course\/5130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5130"}],"version-history":[{"count":0,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/lp_course\/5130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=\/wp\/v2\/media\/5546"}],"wp:attachment":[{"href":"https:\/\/coursesmantra.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5130"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=5130"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/coursesmantra.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=5130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}