{"id":958,"date":"2022-04-28T21:19:42","date_gmt":"2022-04-28T21:19:42","guid":{"rendered":"https:\/\/bpluscom.net\/?p=958"},"modified":"2022-05-05T21:26:43","modified_gmt":"2022-05-05T21:26:43","slug":"etl-oss-extract-transform-load","status":"publish","type":"post","link":"https:\/\/bpluscom.net\/en\/technology\/etl-oss-extract-transform-load\/","title":{"rendered":"ETL OSS Extract Transform Load"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_69_1 counter-hierarchy ez-toc-counter ez-toc-white ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" >Spis tre\u015bci<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bpluscom.net\/en\/technology\/etl-oss-extract-transform-load\/#Check_out_the_possibilities_of_etl_oss_with_SunVizion\" title=\"Check out the possibilities of etl oss with SunVizion!\">Check out the possibilities of etl oss with SunVizion!<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bpluscom.net\/en\/technology\/etl-oss-extract-transform-load\/#Why_ETL_OSS\" title=\"Why ETL OSS?\">Why ETL OSS?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Check_out_the_possibilities_of_etl_oss_with_SunVizion\"><\/span>Check out the possibilities of etl oss with SunVizion!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-959 alignleft\" src=\"https:\/\/bpluscom.net\/wp-content\/uploads\/2022\/05\/z5-300x199.jpg\" alt=\"ETL OSS\" width=\"300\" height=\"199\" \/>If you would like to discuss the origin of your data, before and after preloading the <strong>etl oss database<\/strong>, schedule a consultation with us to find out how SunVizion&#8217;s offering of solutions and reporting tools can help. At a high level, this is created by associating <strong>BSS data<\/strong> (address points) with OSS data (service areas) and can be enhanced to provide a lot of other information. It can be enriched with data that indicates if address points represent existing customers, houses let in but not connected, not yet transferred with infrastructure, will be moved with planned infrastructure to be rolled out soon, includes recently departing customers, and many other considerations. This becomes powerful information for customer groups such as <strong>marketing and sales<\/strong>. It can be enhanced with live network events \/ health data, historical health trends, utilization levels, focus on network expansion, and many other data points. This is becoming powerful for operations-focused groups such as <strong>planning, engineering, and operations<\/strong>. It is also becoming an attractive source of data supporting algorithmic analysis, which allows to obtain further information about the entire company.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_ETL_OSS\"><\/span>Why ETL OSS?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-960 alignleft\" src=\"https:\/\/bpluscom.net\/wp-content\/uploads\/2022\/05\/z6-300x199.jpg\" alt=\"ETL OSS\" width=\"300\" height=\"199\" \/>Origin means being able to trace the history of the data, or in this case, their <a href=\"https:\/\/www.sunvizion.com\/about\/blog\/39-tricks-tips\/346-how-to-ensure-your-oss-is-more-than-an-asset-register\">Etl Oss<\/a>. The origin of the data becomes an interesting concept in this context. In a typical sense, data origin means being able to register a source system or address (e.g. from a specific <strong>Element Management System<\/strong> [EMS]) and reference it to a data point loaded into an OSS or BSS database. This means tracing his lineage before reaching the <strong>OSS \/ BSS database<\/strong>. The broad coverage provided by the SunVizion package means that there is a large variety of data available to enrich other data points. It is compiled in a common format, making it well suited for cross-linking.<\/p>","protected":false},"excerpt":{"rendered":"<p>Check out the possibilities of etl oss with SunVizion! If you would like to discuss the origin of your data, before and after preloading the etl oss database, schedule a consultation with us to find out how SunVizion&#8217;s offering of solutions and reporting tools can help. At a high level, this is created by associating [&hellip;]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,17],"tags":[302,301,303],"class_list":["post-958","post","type-post","status-publish","format-standard","hentry","category-software","category-technology","tag-etl","tag-etl-oss","tag-oss"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/posts\/958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/comments?post=958"}],"version-history":[{"count":1,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/posts\/958\/revisions"}],"predecessor-version":[{"id":962,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/posts\/958\/revisions\/962"}],"wp:attachment":[{"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/media?parent=958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/categories?post=958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bpluscom.net\/en\/wp-json\/wp\/v2\/tags?post=958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}