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 / Environment

  • Pharmaceutical industry
  • Business Intelligence Specialist
  • Introduction of a material price change report (MPV)
  • Creation of a data model in Microsoft Power BI
  • Transforming the raw data to derive key figures
  • Creation of various dashboards with drill-down options to provide an overview of material price trends
  • Evaluation of price/quantity effects
  • Variance analysis of order/invoice values
  • Identification of data quality problems including corresponding solution proposals
  • Creation of control lists for the evaluation of data quality
  • BI-based, real-time analysis tool introduced
  • Employees trained to use the tool
  • Basis for evaluation of purchase prices created
  • Possibility of evaluating data quality issues through control lists created
  • German pharmaceutical company
  • Approx. 1600 employees
Dipl.-/Bank-Kfm. Michael Weßling

Senior Partner

+49 40 8000 845 92 wessling@fup-ag.com