A data discovery implementation with a world leader in material handling systems.
Introduction
A leading US-based logistical solutions provider whose state of the art systems help deliver over 40 percent of the world’s retail orders.
This firm sought a transparent visualisation process to highlight stock ordering anomalies, premeditate supply chain snags and greatly reduce the costs associated with delayed product delivery.
Challenges
- A lack of business trust in the data quality from Excel derived reporting hampering decision making.
- Over-allocation of resources to manual excel data transformation resulting in a lack of time for actual analysis.
- A reliable data platform with transparent business logic to Improve supply chain visibility and drive calls to action.
- A flexible, lean, and cost effective BI platform that allows cross module analysis of SAP data without extensive report building.
Solution
With an expert understanding of SAP, combined with a best in class data visualisation ability, Pomerol Partners was able to swiftly identify and address the key pain points within the client’s vast data environment. A production-ready QlikView Application was delivered within 20 days to respond to the urgent business requirement of visualising a fast moving purchase order landscape.
Open Purchase Order
- Full Purchase Order visibility exposing open and incomplete POs.
- Customised business logic allocating actions to incomplete purchasing processes.
- Highlight stock and pricing inconsistencies created between order and delivery.
Materials Management
- Bring purchasing into equilibrium by balancing known and forecast demand with pending supply and target safety stock levels.
- Ensures continuous supply capability, minimised capital held in idle stock and reduced storage costs for over-bought materials.
Procurement Navigator
- Evaluate vendor and buyer performance on a product by product basis.
- Visualise cross module procurement needs across multiple business functions and streamline purchasing.
Supply Chain Visibility
- Assess how vendor performance will impact specific projects downstream based on forecast stock requirements and anticipating supply chain snags.
- Reduce the penalties and costs associated with delayed product delivery.
Combining the latest in-memory BI technologies, and an intimate knowledge of SAP, Pomerol Partners deliver cross module analytical reporting at a fraction of the time and cost of traditional business warehouse solutions.
Benefits
- Cost vs. Traditional Business Warehouse Solutions – An agile and scalable BI toolkit at a fraction of the traditional software and infrastructure costs.
- Time and Efficiency Gains – Created through automated QlikView reporting and eliminating manual data extraction and report building.
- Business Savings – Improved forecasting ability reducing lost sales caused by supply chain shortfalls.
- Greater supply chain visibility creating opportunities for cost reduction and cost avoidance.