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