{"id":64558,"date":"2022-06-27T09:52:02","date_gmt":"2022-06-27T07:52:02","guid":{"rendered":"https:\/\/www.fup-ag.com\/?page_id=14558"},"modified":"2023-08-03T11:46:00","modified_gmt":"2023-08-03T09:46:00","slug":"implementation-business-intelligence","status":"publish","type":"case-study","link":"https:\/\/www.fup-ag.com\/en\/case-studies\/implementation-business-intelligence\/","title":{"rendered":"Implementation of a Business Intelligence Controlling Tool"},"content":{"rendered":"<h2>Task definition<\/h2>\n<div>\n<ul>\n<li>Preparation of large amounts of data for real-time analyses<\/li>\n<li>Creation of a basis for tracking the development of material prices<\/li>\n<li>Building up an overview of material prices and order quantities for supplier discussions in order to have a better negotiating position<\/li>\n<li>Establishment of control lists to improve data quality<\/li>\n<\/ul>\n<\/div>\n<h2>Industry \/ Function \/ Environment<\/h2>\n<div class=\"O0\">\n<div class=\"O0\">\n<ul>\n<li class=\"O0\">\n<div class=\"O0\">Pharmaceutical industry<\/div>\n<\/li>\n<li class=\"O0\">\n<div class=\"O0\">Business Intelligence Specialist<\/div>\n<\/li>\n<li class=\"O0\">\n<div class=\"O0\">Introduction of a material price change report (MPV)<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<ul>\n<li>Creation of a data model in Microsoft Power BI<\/li>\n<li>Transforming the raw data to derive key figures<\/li>\n<li>Creation of various dashboards with drill-down options to provide an overview of material price trends<\/li>\n<li>Evaluation of price\/quantity effects<\/li>\n<li>Variance analysis of order\/invoice values<\/li>\n<li>Identification of data quality problems including corresponding solution proposals<\/li>\n<li>Creation of control lists for the evaluation of data quality<\/li>\n<\/ul>\n<div class=\"O0\">\n<div class=\"O0\">\n<ul>\n<li class=\"O0\">BI-based, real-time analysis tool introduced<\/li>\n<li class=\"O0\">Employees trained to use the tool<\/li>\n<li class=\"O0\">Basis for evaluation of purchase prices created<\/li>\n<li class=\"O0\">Possibility of evaluating data quality issues through control lists created<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<ul>\n<li>German pharmaceutical company<\/li>\n<li>Approx. 1600 employees<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Task definition Preparation of large amounts of data for real-time analyses Creation of a basis for tracking the development of material prices Building up an overview of material prices and order quantities for supplier discussions in order to have a better negotiating position Establishment of control lists to improve data quality Industry \/ Function \/ [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":64561,"menu_order":0,"template":"","categories":[],"expertise":[53325,53286,53330,53319,53287,53288],"service":[],"industry":[53218,53269],"type-case-study":[],"class_list":["post-64558","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","expertise-agile-organisation-en","expertise-business-transformation-en","expertise-controlling-en","expertise-controlling","expertise-digital-transformation","expertise-finance-en","industry-healthcare-life-sciences","industry-healthcare-life-sciences-en"],"_links":{"self":[{"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/case-study\/64558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":0,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/case-study\/64558\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/media\/64561"}],"wp:attachment":[{"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/media?parent=64558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/categories?post=64558"},{"taxonomy":"expertise","embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/expertise?post=64558"},{"taxonomy":"service","embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/service?post=64558"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/industry?post=64558"},{"taxonomy":"type-case-study","embeddable":true,"href":"https:\/\/www.fup-ag.com\/en\/wp-json\/wp\/v2\/type-case-study?post=64558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}