Reporting and analysis tool enhancing SAB's performance management culture

Spend_analysis.jpgAn integrated reporting and analysis tools is delivering exceptional ROI at South African Breweries (SAB), one of South Africa’s leading producer-distributors of alcoholic and non-alcoholic beverages and one of the nation’s largest manufacturing organisations.

The group runs an ERP system across its operations to manage its sales, finance, marketing and supply chain functions, producing high data volumes across systems in a complex IT structure.

The problem

In this milieu, SAB struggled to measure and manage output and perform data analysis. Business users employed various reporting tools to extract and analyse data, but these solutions proved complex and ineffective.

The organisation set out to find a solution that would allow it to combine and analyse multiple data sets across different systems. The solution had to be easy to use, fast and insightful in SAB’s ongoing quest to measure and improve operational efficiency. It also had to handle vast amounts of data (230 000) rows of data are added every day in the operational system alone).

The solution

BusinessIntelligent introduced QlikView to SAB’s Operations Department who requested a proof of concept. The results outperformed the corporate IT alternative in terms of fit for purpose, BusinessIntelligent’s Tony Bell told SmartProcurement.

Test users indicated their satisfaction with Qlikview on all aspects and 500 licences were purchased together with a connector to the ERP system.

User reaction

Users were impressed with the extraordinary speed of implementation recording that the application enabled them to start daily data analysis immediately, facilitated fast and accurate decisions and enabled them to gain insights and optimise results.

“We suddenly had reporting and analysis at the click of a button,” SAB business analyst Sonja Deysel reported. “I now use QlikView for all my reporting and analysis. It associates all the information and lets us get into all the key issues very quickly. Previous data queries took three hours for data extraction, more time to build a report, and more to do analysis. Today it takes 10 minutes to find the issue and resolve it.”


Within a year of implementing QlikView, SAB reported an exceptionally high return on investment. This was the result of users’ improved ability to control and manage information and provide their own reporting and analysis.

Operations Excellence Manager Sean Milne, “Our intention when purchasing QlikView was to provide superior customer service and productivity in the business. We have achieved that as well as an exceptional ROI through superior execution. QlikView allowed us to enhance our performance management culture with the power of our information.

Spend analysis: providing data visibility

The visibility that spend analysis enables provides the necessary foundation for procurement organizations to make better, more informed sourcing decisions.

“Reporting has to be agile and in real-time,” says Bell.

The development of key performance indicators with line-of-sight into purchasing activity (detailed drill-down capabilities for supplier analysis, item analysis and analysis of buyers) is a critical and a fundamental capability a procurement division must have.

With line-of-sight of your data in near real time you become immediately aware of your data quality and you are able to avoid data that is incorrectly classified or duplicated.

Savings are typically achieved by identifying opportunities to aggregate spend and negotiate superior contracts; identifying and reducing non-compliant or “maverick” spend; and improving procurement operations and supplier performance.

However, despite these clear benefits, more than 50% of organisations utilize manual tools and services today to collect and analyse spend data, limiting visibility into spend and leaving money on the table, says Tony Bell.

By deploying solutions to automate data collection, classification, analysis and reporting, enterprises will:
1. realize improved cost savings through improved strategic sourcing capabilities;
2. reduce financial savings leakage by driving compliance to negotiated contracts; and
3. increase visibility into enterprise-wide spend and dramatically improve reporting capabilities.

BusinessIntelligent’s recent work with government and academic institutions has improved insights into their spend analysis and decision making leading to significant operational effectiveness.

For more information on improving data analytics, contact Tony Bell on

The importance of spend analysis in the contemporary procurement department will be the focus of an upcoming SmartProcurement half-day Spend Analysis workshop in Centurion on Wednesday 30 May 2012.

For more information or to REGISTER e-mail Erieka Santos on or call 086 133 4326

Leave a comment

SmartProcurement Newsletter

Please enter your details below to receive the SmartProcurement Newsletter for FREE on a regular basis.

As part of the SmartProcurement Newsletter you will be receiving World Class Procurement News, Tools, Tips, Tactics, Procurement Training updates, Upcoming Events, and the latest Procurement Career Openings.

* Email Address:
* Title:
* First Name:
* Surname:
* Company:
* Country:
* Public / Private:


Career opportunites

Demand Planning Manager

  • <500 000 Gauteng Operations, Planning & Inventory Projects / Category Management
(Total Cost to Company R750k - R900K) excluding ...More

Global Category Manager: CONTRACTS

  • <500 000 Buyer Commodities Contract Gauteng
Total Cost to Company R1mil - R1.2mil excluding

Project Manager :12-18 MONTH CONTRACT

  • <500 000 Contract Procurement Officer / Specialist Projects / Category Management
Description:A well-known retail organization is looking for an ...More

Procurement Analyst

  • <500 000 Analyst Gauteng Permanent Procurement Management
Description:A leading infrastructure development group with strong presence ...More

Commodity Manager: Fuels and Lubes

  • <500 000 Commodities Gauteng Permanent Strategic Sourcing
Description:Ensuring continuity of supply in line with business ...More

Senior Facilities Manager

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management
(Total Cost to Company R800K - R900K) Description: ...More

Supply Chain Analyst

  • <500 000 Analyst Permanent Supply Chain Western Cape
(Total Cost to Company R350K - R550K) SOUTHERN ...More

Demand Planner

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Supply Chain
(Total Cost to Company R450k - R550k, dependent ...More

Procurement Specialis

  • <500 000 Gauteng Permanent Procurement Management Procurement Officer / Specialist
(Total Cost to Company R700k - R800k including ...More

Solutions Architect

  • <500 000 Analyst Gauteng Operations, Planning & Inventory Permanent
(Total Cost to Company R1.3Mil - R1.1Mil including ...More

Engineering Manager

  • Gauteng Industrial Engineer Permanent Procurement Management
Total Cost to Company R850k - R950K including ...More

Country Head of Procurement

  • Permanent Procurement Management Procurement Officer / Specialist CBS Procurement,Hub Head of Procurement To lead, ...More

Demand Planner

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management!Gauteng/Planning/Demand%20Planner/TP2005490/MSe Category: PlanningPosition Title: Demand PlannerSalary: R600 000 ...More

Head of Procurement

  • <500 000 Gauteng Permanent Procurement Management Procurement Officer / Specialist!Gauteng/Procurement/Head%20of%20Procurement/TP2005488/ZBuCategory: ProcurementPosition Title: Head of ProcurementSalary: R1.3 million ...More

Warehouse and Distribution Manager

  • <500 000 Gauteng Logistics & Warehousing Permanent Supply Chain!Gauteng/Logistics/Warehouse%20Distribution%20Manager/TP2005455/TMa Category: Supply ChainPosition Title: Warehouse and Distribution ...More

Supply Chain Manager

  • <500 000 Mpumalanga Permanent Procurement Officer / Specialist Supply Chain!Mpumalanga/Supply%20Chain/Supply%20Chain%20Manager/TP2005448/LMa Category: Supply ChainPosition Title: Supply Chain Manager ...More

Industrial Engineer

  • <500 000 Gauteng Industrial Engineer Operations, Planning & Inventory Permanent!Gauteng/Consulting/Continuous%20Improvement%20Manager/TP2005489/SNh Category: ConsultingPosition Title: Industrial EngineerSalary: R900 000 ...More

Operations Manager

  • >500 000 Gauteng Operations, Planning & Inventory Permanent Supply Chain
Our client within the FMCG industry with a ...More

Warehouse and Distribution Manager

  • >500 000 Gauteng Logistics & Warehousing Operations, Planning & Inventory Permanent
An exciting opportunity awaits for a Warehouse and ...More

Demand Planner

  • <500 000 Permanent
Get an opportunity to be part of one ...More