{"id":4491,"date":"2025-12-08T10:59:25","date_gmt":"2025-12-08T10:59:25","guid":{"rendered":"https:\/\/dev.iwis.io\/?post_type=portfolio&p=4491"},"modified":"2025-12-10T11:25:02","modified_gmt":"2025-12-10T11:25:02","slug":"servier","status":"publish","type":"portfolio","link":"https:\/\/dev.iwis.io\/en\/results\/servier\/","title":{"rendered":"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"footnotes":""},"portfolio_category":[112],"portfolio_tag":[114],"class_list":["post-4491","portfolio","type-portfolio","status-publish","hentry","portfolio_category-business-intelligence-bi","portfolio_tag-business-intelligence-bi"],"acf":{"portfolio_project_image":4496,"portfolio_project_description":"When we start working with world-class companies, we always focus on the speed of decision-making and strategic depth. We were approached by Servier, a global leader with a presence in ","portfolio_project_tags":[114],"portfolio_project_url":"","portfolio_categories":[112],"portfolio_featured_project":false,"portfolio_about_label":"About the project","portfolio_about_title":"We transformed disparate Excel-based metrics into a unified ecosystem for well-considered decisions.","portfolio_about_description":"When partnering with global companies, we always focus on the speed of process adoption and the strategic depth of solutions. Servier \u2014 a global leader operating in 140 countries \u2014 approached us with a challenge. The company\u2019s core expertise spans oncology, cardio-metabolism, and neurosciences, and nearly 20% of revenue from original medicines is reinvested into research. \r\nCollaboration with Servier allowed us to immerse ourselves in both the scientific and business contexts in order to create tools that strengthen long-term strategy and align with the real needs of healthcare professionals and patients. ","portfolio_about_problem_title":"The client's problem","problem_item_text_default":"The client explained that their existing reporting system was highly fragmented and required significant resources to maintain. Operations were based in Excel, which led to duplicated reports and outdated metrics. The absence of a single source of truth and standardized practices introduced risks into analytics and overall management. <\/span>\r\n\r\nKey issues that required improvement:<\/span>","portfolio_about_problem_items":[{"portfolio_about_problem_item_text":"Information was scattered across multiple sources and difficult to verify."},{"portfolio_about_problem_item_text":"File duplication and manual updates resulted in frequent errors."},{"portfolio_about_problem_item_text":"Teams spent excessive time consolidating and formatting data."},{"portfolio_about_problem_item_text":"Business processes slowed down due to inconsistent or obsolete information."},{"portfolio_about_problem_item_text":"Most time was spent not on analysis but on manual report preparation."}],"problem_item_text_default_second":"These issues needed to be resolved quickly, as they limited process scalability and hindered the development of Servier\u2019s analytical ecosystem.","portfolio_about_problem_image":4496,"portfolio_details_label":"Project details:","portfolio_details_title":"Key facts about the project","portfolio_details_cards":[{"portfolio_details_card_type":"text","portfolio_details_card_title":"6 months","portfolio_details_card_image":null,"portfolio_details_card_text":"Project duration"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Large","portfolio_details_card_image":null,"portfolio_details_card_text":"Project size:"},{"portfolio_details_card_type":"image","portfolio_details_card_title":"","portfolio_details_card_image":279,"portfolio_details_card_text":"Project complexity"},{"portfolio_details_card_type":"text","portfolio_details_card_title":"Completed","portfolio_details_card_image":null,"portfolio_details_card_text":"Project status:"}],"portfolio_team_label":"Our Team:","portfolio_team_members":[{"portfolio_team_member_text":"Project Manager"},{"portfolio_team_member_text":"Business Analyst"},{"portfolio_team_member_text":"Data Engineer"},{"portfolio_team_member_text":"Data Analyst"}],"portfolio_solution_items":[{"media_type":"image","gif_image":null,"static_image":4497,"solution_label":" Case information","solution_title":"We built a data solution that strengthens the company\u2019s competitive edge and turns complexity into advantage.","solution_points":[{"point_text":"Servier \u2014 a global industry leader \u2014 gained a new superpower: the brand can now see the future through data.","point_has_bullet":false},{"point_text":"Our approach:<\/b>","point_has_bullet":false},{"point_text":"We began with a full Discovery phase, which gave us a clear understanding of the company\u2019s data landscape and reporting logic. It also helped us identify the processes that were holding back analytical development.\r\nWe thoroughly analyzed the needs of each department as well as the structure of all data sources. These insights allowed us to create an infological model \u2014 the foundation for the future architecture. <\/span>\r\n\r\nOur team focused not only on technical shortcomings but also on organizational barriers that prevented the creation of a unified information environment. We proposed two options for building a centralized data warehouse, fully aligned with the company\u2019s resources, constraints, and long-term priorities.\r\nAt this stage, we also developed a set of recommendations to help the company transition from fragmented reporting to transparent, governed analytics powered by modern tools. <\/span>","point_has_bullet":false}],"button_text":"","button_url":""},{"media_type":"image","gif_image":null,"static_image":4495,"solution_label":"","solution_title":"Work results:","solution_points":[{"point_text":"By the end of the project, we had a complete picture of the data landscape, real departmental needs, and the root causes that slowed down analytics. Our experts developed a clear transformation roadmap and defined the optimal direction for building a modern reporting architecture. <\/span>","point_has_bullet":false},{"point_text":"Key Achievements:<\/span>","point_has_bullet":false},{"point_text":"An infological model was built and proposed two options for a centralized DWH.<\/span>","point_has_bullet":true},{"point_text":"Identified technical and organizational barriers and provided recommendations for eliminating them.<\/span>","point_has_bullet":true},{"point_text":"Suggested standardized reporting templates, unified reference data, and the introduction of MDM solutions.<\/span>","point_has_bullet":true},{"point_text":"Defined the steps for adopting Microsoft Power BI as the core analytics platform.<\/span>","point_has_bullet":true},{"point_text":"As a result, the client received a unified information environment. Today, the brand has automated its reporting processes and transitioned from manual workflows to a scalable, modern analytical system. <\/span>","point_has_bullet":false}],"button_text":"","button_url":""}],"portfolio_results_slider_type":"desktop","portfolio_results_mobile_images":null,"portfolio_results_desktop_images":[{"portfolio_results_desktop_image":4492},{"portfolio_results_desktop_image":4493}],"portfolio_show_feedback_button":true,"portfolio_feedback_preview_image":"","portfolio_feedback_video_url":""},"yoast_head":"\nServier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis<\/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:\/\/dev.iwis.io\/en\/results\/servier\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.iwis.io\/en\/results\/servier\/\" \/>\n<meta property=\"og:site_name\" content=\"iwis\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/IWIS.UKRAINE\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-10T11:25:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/servier\/\",\"url\":\"https:\/\/dev.iwis.io\/en\/results\/servier\/\",\"name\":\"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis\",\"isPartOf\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#website\"},\"datePublished\":\"2025-12-08T10:59:25+00:00\",\"dateModified\":\"2025-12-10T11:25:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/servier\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.iwis.io\/en\/results\/servier\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.iwis.io\/en\/results\/servier\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.iwis.io\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#website\",\"url\":\"https:\/\/dev.iwis.io\/en\/\",\"name\":\"IWIS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.iwis.io\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#organization\",\"name\":\"IWIS\",\"url\":\"https:\/\/dev.iwis.io\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\",\"contentUrl\":\"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png\",\"width\":512,\"height\":512,\"caption\":\"IWIS\"},\"image\":{\"@id\":\"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/IWIS.UKRAINE\/\",\"https:\/\/www.linkedin.com\/company\/iwis-ukraine\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis","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:\/\/dev.iwis.io\/en\/results\/servier\/","og_locale":"en_US","og_type":"article","og_title":"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis","og_url":"https:\/\/dev.iwis.io\/en\/results\/servier\/","og_site_name":"iwis","article_publisher":"https:\/\/www.facebook.com\/IWIS.UKRAINE\/","article_modified_time":"2025-12-10T11:25:02+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.iwis.io\/en\/results\/servier\/","url":"https:\/\/dev.iwis.io\/en\/results\/servier\/","name":"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade - iwis","isPartOf":{"@id":"https:\/\/dev.iwis.io\/en\/#website"},"datePublished":"2025-12-08T10:59:25+00:00","dateModified":"2025-12-10T11:25:02+00:00","breadcrumb":{"@id":"https:\/\/dev.iwis.io\/en\/results\/servier\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.iwis.io\/en\/results\/servier\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.iwis.io\/en\/results\/servier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.iwis.io\/en\/"},{"@type":"ListItem","position":2,"name":"Servier Case: How Data Became a Strategic Asset Through a Complete Reporting System Upgrade"}]},{"@type":"WebSite","@id":"https:\/\/dev.iwis.io\/en\/#website","url":"https:\/\/dev.iwis.io\/en\/","name":"IWIS","description":"","publisher":{"@id":"https:\/\/dev.iwis.io\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.iwis.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dev.iwis.io\/en\/#organization","name":"IWIS","url":"https:\/\/dev.iwis.io\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/","url":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","contentUrl":"https:\/\/dev.iwis.io\/wp-content\/uploads\/2026\/01\/cropped-main-favicon.png","width":512,"height":512,"caption":"IWIS"},"image":{"@id":"https:\/\/dev.iwis.io\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/IWIS.UKRAINE\/","https:\/\/www.linkedin.com\/company\/iwis-ukraine\/"]}]}},"_links":{"self":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/4491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"version-history":[{"count":2,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/4491\/revisions"}],"predecessor-version":[{"id":4539,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio\/4491\/revisions\/4539"}],"acf:term":[{"embeddable":true,"taxonomy":"portfolio_category","href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category\/112"},{"embeddable":true,"taxonomy":"portfolio_tag","href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag\/114"}],"wp:attachment":[{"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/media?parent=4491"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_category?post=4491"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/dev.iwis.io\/en\/wp-json\/wp\/v2\/portfolio_tag?post=4491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}