{"id":10348,"date":"2020-02-13T07:32:16","date_gmt":"2020-02-13T07:32:16","guid":{"rendered":"http:\/\/amdhan.intelli-globe.com\/?page_id=10348"},"modified":"2020-02-13T09:36:46","modified_gmt":"2020-02-13T09:36:46","slug":"how-microsoft-business-intelligence-msbi-implementation-by-amdhan-transformed-procurement-function-of-uk-power-networks","status":"publish","type":"page","link":"https:\/\/amdhan.co.uk\/index.php\/how-microsoft-business-intelligence-msbi-implementation-by-amdhan-transformed-procurement-function-of-uk-power-networks\/","title":{"rendered":"How Microsoft Business Intelligence (MSBI) implementation by AmDhan transformed procurement function of UK Power Networks"},"content":{"rendered":"<p>[vc_section full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1519190934231{margin-bottom: 0px !important;padding-top: 65px !important;padding-bottom: 30px !important;}&#8221;][vc_row full_width=&#8221;stretch_row&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1519186321476{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_column css_animation=&#8221;none&#8221; width=&#8221;1\/4&#8243;][vc_row_inner css=&#8221;.vc_custom_1519129141917{margin-top: 30px !important;margin-right: 0px !important;margin-bottom: 30px !important;margin-left: 0px !important;border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;padding-top: 26px !important;padding-right: 18px !important;padding-bottom: 15px !important;padding-left: 15px !important;background-color: #ffffff !important;border-left-color: #e6e6e6 !important;border-left-style: solid !important;border-right-color: #e6e6e6 !important;border-right-style: solid !important;border-top-color: #e6e6e6 !important;border-top-style: solid !important;border-bottom-color: #e6e6e6 !important;border-bottom-style: solid !important;}&#8221;][vc_column_inner css=&#8221;.vc_custom_1509618345792{padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}&#8221;][vc_custom_heading text=&#8221;Quick Contact&#8221; font_container=&#8221;tag:h2|font_size:25|text_align:left|line_height:25px&#8221; use_theme_fonts=&#8221;yes&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1522748083307{margin-top: 0px !important;margin-bottom: 20px !important;padding-top: 0px !important;padding-bottom: 0px !important;padding-left: 14px !important;}&#8221;]\r<!-- rt-cf7 -->\r<div class=\"radiant-contact-form rt0fd13175f771a87 element-one service-form vc_custom_1524649072362\"  >\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f318-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"318\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/index.php\/wp-json\/wp\/v2\/pages\/10348#wpcf7-f318-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<div style=\"display: none;\">\n<input type=\"hidden\" name=\"_wpcf7\" value=\"318\" \/>\n<input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/>\n<input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f318-o1\" \/>\n<input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/>\n<input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/>\n<input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/div>\n<div class=\"row\">\n\t<div class=\"col-lg-12 col-md-12 col-sm-12 col-xs-12\">\n\t\t<div class=\"form-row\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"Name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name:\" value=\"\" type=\"text\" name=\"Name\" \/><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t<\/div>\n\t<div class=\"col-lg-12 col-md-12 col-sm-12 col-xs-12\">\n\t\t<div class=\"form-row\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-997\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-text wpcf7-validates-as-tel\" aria-invalid=\"false\" placeholder=\"Phone No:\" value=\"\" type=\"tel\" name=\"tel-997\" \/><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t<\/div>\n\t<div class=\"col-lg-12 col-md-12 col-sm-12 col-xs-12\">\n\t\t<div class=\"form-row\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"email\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email:\" value=\"\" type=\"email\" name=\"email\" \/><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t<\/div>\n\t<div class=\"col-lg-12 col-md-12 col-sm-12 col-xs-12\">\n\t\t<div class=\"form-row\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"message\"><textarea cols=\"40\" rows=\"10\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" placeholder=\"Message:\" name=\"message\"><\/textarea><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t<\/div>\n\t<div class=\"col-lg-12 col-md-12 col-sm-12 col-xs-12\">\n\t\t<div class=\"form-row last button\">\n\t\t\t<p><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send Message\" \/>\n\t\t\t<\/p>\n\t\t<\/div>\n\t<\/div>\n<\/div><input type='hidden' class='wpcf7-pum' value='{\"closepopup\":false,\"closedelay\":0,\"openpopup\":false,\"openpopup_id\":0}' \/><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div>\r<!-- rt-cf7 -->\r[\/vc_column_inner][\/vc_row_inner][vc_row_inner css=&#8221;.vc_custom_1519105729265{margin-right: 0px !important;margin-left: 0px !important;border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;padding-top: 28px !important;padding-right: 28px !important;padding-bottom: 28px !important;padding-left: 26px !important;background-color: #f9f9f9 !important;border-left-color: #e6e6e6 !important;border-left-style: solid !important;border-right-color: #e6e6e6 !important;border-right-style: solid !important;border-top-color: #e6e6e6 !important;border-top-style: solid !important;border-bottom-color: #e6e6e6 !important;border-bottom-style: solid !important;}&#8221;][vc_column_inner css=&#8221;.vc_custom_1508407872713{padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}&#8221;][vc_custom_heading text=&#8221;Need Help?&#8221; font_container=&#8221;tag:h2|font_size:25px|text_align:left|line_height:23px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1522748294013{padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_custom_heading text=&#8221;Please Feel Free To Contact Us. We Will Get Back To You With 1-2 Business Days.&#8221; font_container=&#8221;tag:p|font_size:12px|text_align:left|color:%23505050|line_height:20px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1519126176120{margin-top: 15px !important;margin-bottom: 15px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_custom_heading text=&#8221;info@amdhan.co.uk<br \/>\n+44 01245707490&#8243; font_container=&#8221;tag:p|font_size:14px|text_align:left|color:%23696969|line_height:25px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1519126107364{padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][\/vc_column_inner][\/vc_row_inner][vc_row_inner css=&#8221;.vc_custom_1519185169774{margin-top: 30px !important;margin-right: 0px !important;margin-bottom: 0px !important;margin-left: 0px !important;border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;padding-top: 28px !important;padding-right: 28px !important;padding-bottom: 8px !important;padding-left: 26px !important;background-color: #f9f9f9 !important;border-left-color: #e6e6e6 !important;border-left-style: solid !important;border-right-color: #e6e6e6 !important;border-right-style: solid !important;border-top-color: #e6e6e6 !important;border-top-style: solid !important;border-bottom-color: #e6e6e6 !important;border-bottom-style: solid !important;}&#8221;][vc_column_inner css=&#8221;.vc_custom_1508407872713{padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}&#8221;][vc_custom_heading text=&#8221;Download&#8221; font_container=&#8221;tag:h2|font_size:25px|text_align:left|line_height:23px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1522748329787{padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_custom_heading text=&#8221;Company White Paper<br \/>\n1.30 MB&#8221; font_container=&#8221;tag:p|font_size:13px|text_align:left|color:%23505050|line_height:18px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1524482112073{margin-top: 21px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;padding-left: 40px !important;background-image: url(http:\/\/localhost\/amdhan2\/wp-content\/uploads\/2018\/04\/pdf-1.jpg?id=9382) !important;background-position: 0 0 !important;background-repeat: no-repeat !important;}&#8221; el_class=&#8221;pdf-style&#8221;][vc_custom_heading text=&#8221;Company Media Kit<br \/>\n1.22 MB&#8221; font_container=&#8221;tag:p|font_size:13px|text_align:left|color:%23505050|line_height:18px&#8221; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1524482133832{margin-top: 10px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;padding-left: 40px !important;background-image: url(http:\/\/localhost\/amdhan2\/wp-content\/uploads\/2018\/04\/pdf-1.jpg?id=9382) !important;background-position: 0 0 !important;background-repeat: no-repeat !important;}&#8221; el_class=&#8221;pdf-style&#8221;][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column css_animation=&#8221;none&#8221; width=&#8221;3\/4&#8243; css=&#8221;.vc_custom_1519186346490{margin-left: 0px !important;padding-left: 42px !important;}&#8221;][vc_custom_heading text=&#8221;Customer Overview&#8221; font_container=&#8221;tag:h2|font_size:36px|text_align:left&#8221; use_theme_fonts=&#8221;yes&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584104849{padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_column_text css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584177172{margin-top: 15px !important;margin-bottom: 36px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;]UK Power Networks (UKPN) is a distribution network operator for electricity covering South East England, the East of England and London. It manages three licensed distribution networks (Eastern Power Networks PLC, South Eastern Power Networks PLC and London Power Networks PLC) which together cover an area of 30000 square kilometers and approximately eight million customers.[\/vc_column_text][vc_single_image image=&#8221;10172&#8243; img_size=&#8221;full&#8221; el_id=&#8221;set-img&#8221;][vc_column_text css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584364656{margin-top: 18px !important;margin-bottom: 0px !important;border-bottom-width: 1px !important;padding-top: 0px !important;padding-bottom: 44px !important;border-bottom-color: #eeeeee !important;border-bottom-style: solid !important;}&#8221;]<strong style=\"color:#1E1666;\">Business Situation<\/strong><\/p>\n<p>    Having SAP-Sourcing &#038; SAP-Material Management Systems in place, one of the challenges in procurement area was for stake-holders and managers to have analytical access to available data in the system and gain control over pre-procurement and historical \/ on-going procurement processes<\/p>\n<ul>\n<li>Monitor \/ Control pre-procurement Projects Phase wise insights according to Category Specialists, Directorates, Product Categories with respective procurement project types<\/li>\n<li>Having summarized view of all Procurement Projects for completion of Phases from initiation to contract allotments<\/li>\n<li>Contract Analysis by Category Specialists, Product Categories, Directorates, Vendors<\/li>\n<li>Spend Analysis by Category Specialists, Product Categories, Directorates, Vendors<\/li>\n<li>Spend vs Contract \/ Burn \/ Retrospective Analysis<\/li>\n<li> Vendor performance \/ KPI Analysis<\/li>\n<\/ul>\n<p>[\/vc_column_text][vc_row_inner css=&#8221;.vc_custom_1519189430184{margin-top: 50px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_column_inner width=&#8221;7\/12&#8243;][vc_custom_heading text=&#8221;Solution Offered by AmDhan&#8221; font_container=&#8221;tag:h3|font_size:17px|text_align:left&#8221; use_theme_fonts=&#8221;yes&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584438568{margin-top: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_column_text css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584635311{margin-top: 10px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 25px !important;}&#8221;]Amdhan analysed and proposed Microsoft Business Intelligence (MSBI) Solution which includes extract \/ Integrate data from both the system into data-warehouse and develop reports to enable the proposed targeted analytical reports.<br \/>\nAmdhan designed and implemented the solution by using Microsoft Business Intelligence i.e.[\/vc_column_text][vc_column_text]<\/p>\n<ul>\n<li>SQL Server<\/li>\n<li>Integration Service (SSIS)<\/li>\n<li>Reporting Service (SSRS)<\/li>\n<li>Power BI<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_column_inner][vc_column_inner width=&#8221;5\/12&#8243; css=&#8221;.vc_custom_1511780171025{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-right: 0px !important;padding-bottom: 0px !important;padding-left: 0px !important;}&#8221;][vc_single_image image=&#8221;10172&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581513401061{margin-top: 10px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][\/vc_column_inner][\/vc_row_inner][vc_row_inner css=&#8221;.vc_custom_1519210770444{margin-top: 30px !important;margin-bottom: 0px !important;}&#8221;][vc_column_inner css=&#8221;.vc_custom_1519188090985{margin-left: 0px !important;padding-left: 35px !important;}&#8221;][vc_custom_heading text=&#8221;Business Benefits&#8221; font_container=&#8221;tag:h3|font_size:17px|text_align:left&#8221; use_theme_fonts=&#8221;yes&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581584870810{margin-top: 0px !important;padding-top: 24px !important;padding-bottom: 0px !important;}&#8221;][vc_column_text css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1581585187531{margin-top: 10px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 25px !important;}&#8221;]<strong style=\"color:#1E1666;\">They key benefits of the implemented solution were \u2013<\/strong><br \/>\n<u;><\/p>\n<li><strong style=\"color:#1E1666;\"> Pipe-line Reports \u2013 <\/strong>Getting phase-wise visibility of projects, Check whether projects are on-time or breached the deadlines with various parameters such as Category Specialists, Directorates, Budget Holders, Product Categories etc.<\/li>\n<li><strong style=\"color:#1E1666;\">Board-Pack Reports \u2013 <\/strong>Getting summarised view of Procurement Projects for their Value, Savings and Number of Projects in process with their stages.<\/li>\n<li><strong style=\"color:#1E1666;\">Spend Dashboard \/ Reports \u2013<\/strong> Analytical Reports for getting in-sight over spending on procurement with multiple parameters like Monthly, Yearly, by Product Categories, Category Specialists, Vendor etc.<\/li>\n<li><strong style=\"color:#1E1666;\">Contract Dashboard \u2013<\/strong> Analytical Reports for getting 360o view of contracts and spending by Time, Product Categories, Vendors, Category Specialist etc.<\/li>\n<li><strong style=\"color:#1E1666;\">Vendor Performance KPI \u2013<\/strong> Analytical reports to evaluate vendors for their supplies, timely deliveries etc with help of coloured \/ symbolic performance indicators.<\/li>\n<li><strong style=\"color:#1E1666;\">Vendor Reports \u2013<\/strong> Customized Vendor Information Reports with multiple parameters like Contracts awarded, Product Categories etc..<\/li>\n<p>[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][\/vc_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_section full_width=&#8221;stretch_row&#8221; css=&#8221;.vc_custom_1519190934231{margin-bottom: 0px !important;padding-top: 65px !important;padding-bottom: 30px !important;}&#8221;][vc_row full_width=&#8221;stretch_row&#8221; css_animation=&#8221;none&#8221; css=&#8221;.vc_custom_1519186321476{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}&#8221;][vc_column css_animation=&#8221;none&#8221; width=&#8221;1\/4&#8243;][vc_row_inner css=&#8221;.vc_custom_1519129141917{margin-top: 30px !important;margin-right: 0px !important;margin-bottom: 30px !important;margin-left: 0px !important;border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;padding-top: 26px !important;padding-right: 18px !important;padding-bottom: 15px !important;padding-left: 15px !important;background-color: #ffffff !important;border-left-color: #e6e6e6 !important;border-left-style: solid !important;border-right-color: #e6e6e6 !important;border-right-style:&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10348","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/10348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=10348"}],"version-history":[{"count":3,"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/10348\/revisions"}],"predecessor-version":[{"id":10355,"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/pages\/10348\/revisions\/10355"}],"wp:attachment":[{"href":"https:\/\/amdhan.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=10348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}