{"id":260,"date":"2020-02-28T11:49:30","date_gmt":"2020-02-28T11:49:30","guid":{"rendered":"https:\/\/sii.ua\/?case-study=data-analysis-and-cleaning"},"modified":"2020-02-28T11:49:30","modified_gmt":"2020-02-28T11:49:30","slug":"data-analysis-and-cleaning","status":"publish","type":"case-study","link":"https:\/\/sii.ua\/en\/case-study\/data-analysis-and-cleaning\/","title":{"rendered":"Data Analysis and Cleaning"},"content":{"rendered":"<h2>The challenge<\/h2>\n<div class=\"sii-rl-content-item-value sii-rl-businessNeed-value sii-rl-content-item-value-display\">\n<p>To keep Client&#8217;s database up to date &#8211; all records must be periodically verified in order to use Client&#8217;s data in sales process in the optimal way.<\/p>\n<\/div>\n<h2>What we did<\/h2>\n<p>We implemented 3 processes:<\/p>\n<ul>\n<li>Data Analysis &#8211;\u00a0Comparative analysis, data deduplication, reporting,<\/li>\n<li>Data Cleaning (Quality Assurance) &#8211; missing data completion, data validity verification, transformed data loading,<\/li>\n<li>Data Change Management &#8211;\u00a0DB records update, business requests, input from Sales Applications.<\/li>\n<\/ul>\n<h2>Effects<\/h2>\n<ul>\n<li>99,8% of Client&#8217;s records is of good quality.<\/li>\n<li>Sales processes run without bigger problems with lack of proper data.<\/li>\n<li>Database has no duplicates or empty records.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The challenge To keep Client&#8217;s database up to date &#8211; all records must be periodically verified in order to use &hellip; <a class=\"continued-btn\" href=\"https:\/\/sii.ua\/en\/case-study\/data-analysis-and-cleaning\/\">Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"template":"views\/single-old-case-study.blade.php","offering":[228,234,206],"industry":[1107],"client":[10],"technologies":[768,414],"country":[],"class_list":["post-260","case-study","type-case-study","status-publish","hentry","offering-bpo","offering-consulting","offering-it-infrastructure","industry-high-tech-semiconductors","client-abb-en","technologies-excel","technologies-power-bi"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study\/260"}],"collection":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"offering","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/offering?post=260"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/industry?post=260"},{"taxonomy":"client","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/client?post=260"},{"taxonomy":"technologies","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/technologies?post=260"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/sii.ua\/en\/wp-json\/wp\/v2\/country?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}