{"id":23546,"date":"2013-05-14T10:49:37","date_gmt":"2013-05-14T05:19:37","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=23546"},"modified":"2024-04-12T14:17:19","modified_gmt":"2024-04-12T08:47:19","slug":"etl","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/","title":{"rendered":"Business Intelligence Tutorial | ETL (Extract, Transform, Load)"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-business-intelligence-professional\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to Tutorial<\/a><\/p>\n\n\n<div class=\"apply\">\n<pre><a href=\"https:\/\/www.vskills.in\/practice\/business-intelligence\" target=\"_blank\" rel=\"noopener\"><strong>Free Business Intelligence Practice Tests - BI ETL<\/strong><\/a><\/pre>\n<\/div>\n<p>ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it involves three processes to enter data into data warehouse. Let\u2019s discuss these steps now.<\/p>\n<ul>\n<li>Extract: It is the process of extracting data from external source. The external source could be as simple as an application interface to collect data or could be as complex as another data warehouse. In this step we collect the information for external source which could be useful to us as well as we may be interested in saving this information for future use. But at this point, the information is raw and could make our data warehouse unstable or unnecessary for our use.<\/li>\n<li>Transform: It is the phase where we convert the raw information to our need. We define the business logic here and transform the information extracted from external source so that we can use it. In this phase we implement the business logic to calculate the exact information we need for our data warehouse and which is useful to us. In short we modify or filter the extracted information to our need.<\/li>\n<\/ul>\n<p>Load: This is the final phase where we take the transformed information from external source and insert into our data warehouse. In simple word, in this phase we load the information to end target.<\/p>\n<div class=\"apply\">\n<h3><a href=\"http:\/\/www.vskills.in\/certification\/Certified-Business-Intelligence-Professional\" target=\"_blank\" rel=\"noopener\">Apply for Govt Certified Business Intelligence Certification Now!!<\/a><\/h3>\n<\/div>\n\n\n<p><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-business-intelligence-professional\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to Tutorial<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go back to Tutorial Free Business Intelligence Practice Tests &#8211; BI ETL ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it involves three processes to enter data into data warehouse. Let\u2019s discuss these steps now&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3354],"tags":[],"class_list":["post-23546","page","type-page","status-publish","hentry","category-business-intelligence"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Business Intelligence Tutorial | ETL (Extract, Transform, Load)<\/title>\n<meta name=\"description\" content=\"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Business Intelligence Tutorial | ETL (Extract, Transform, Load)\" \/>\n<meta property=\"og:description\" content=\"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:47:19+00:00\" \/>\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:\/\/www.vskills.in\/certification\/tutorial\/etl\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/\",\"name\":\"Business Intelligence Tutorial | ETL (Extract, Transform, Load)\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-05-14T05:19:37+00:00\",\"dateModified\":\"2024-04-12T08:47:19+00:00\",\"description\":\"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Business Intelligence Tutorial | ETL (Extract, Transform, Load)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Business Intelligence Tutorial | ETL (Extract, Transform, Load)","description":"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..","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:\/\/www.vskills.in\/certification\/tutorial\/etl\/","og_locale":"en_US","og_type":"article","og_title":"Business Intelligence Tutorial | ETL (Extract, Transform, Load)","og_description":"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:47:19+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/","name":"Business Intelligence Tutorial | ETL (Extract, Transform, Load)","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-05-14T05:19:37+00:00","dateModified":"2024-04-12T08:47:19+00:00","description":"ETL is the process of through which any data can be inserted into database or more specifically into data warehouse. As from the name, it is clear that it..","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/etl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/etl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Business Intelligence Tutorial | ETL (Extract, Transform, Load)"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=23546"}],"version-history":[{"count":9,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23546\/revisions"}],"predecessor-version":[{"id":134567,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23546\/revisions\/134567"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=23546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=23546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=23546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}