Bidvest Procurement consolidates disparate data and benefits from visibility with Qlik
Qlik has changed everything. Our entire focus has been changed by the way the Qlik product integrates our information and gives us a global and local view," says Werner Brink, Data and Information Science, Bidvest Procurement.
Bidvest Procurement value proposition:
* To deliver value, service and competitive deals using the group's buying power.
* To increase savings while minimising potential supplier risk, thereby allowing the customer to concentrate on core business while improving the bottom line.
* To provide statistical insights on core focuses, including Utilities, Motor Vehicles, IT Telecoms and BUY Bidvest. This is done by aggregating external and internal data extracts.
* By making use of business intelligence (BI) to identify group needs from general ledger extracts and negotiate special deals with prospective suppliers.
* Responding to trends with current service providers.
Prior to deploying Qlik Sense, Bidvest Procurement faced various pain points and challenges in terms of its data management and analytics. "The autonomous nature of the Bidvest business and the data Bidvest Procurement collects were the biggest issues. This was due to the sheer majority and variety of data sources and types," confirms Brink.
With data streaming in from both external suppliers and internal departments, all running on different enterprise resource planning (ERP) and sales systems, the business was under immense pressure to stay on top of its (manual) data management.
At the time, most information was created and captured manually, with very little information being system generated. "We had to manipulate all of this information into a single view. This task was almost impossible," adds Brink.
Originally, Bidvest Procurement's analytics were managed on Excel and Piviots. This method was extremely limiting.
In 2009, the company implemented a data management system, which it utilised until 2016.
"We realised that the programme did not have the capabilities required to fulfil Bidvest Procurement's needs or match the strategic direction that the company was moving in," confirms Brink. "A host of BI partners were evaluated, leading to Qlik Sense being implemented in 2017. At this point, and going forward, Qlik became our core reporting tool."
The Qlik platform was chosen to meet two distinct needs: the ability to gain project visibility; and the ability to gain group visibility. The implementation process was collaborative and entailed intensive planning sessions and the development of clear goals and objectives. These goals included specific time-frames, detailing milestones to be reached by particular dates.
In consultation with SA Qlik Master Reseller, Bidvest Procurement developed an Evaluation and Key Performance Indicator (KPI) Scorecard to ensure a smooth implementation process. "We also implemented a fixed cost project, which aided in the process."
Qlik Sense has delivered on its promise for greater visibility. "The product has provided the ability to see a consolidated view of group operations. This allows me to conduct analyses in real-time, from any location," states Brink. "The dynamic nature of the tool provides a variety of views and excellent visibility into the group trends."
In less than a year, Bidvest Procurement has developed five applications, which help the organisation to manage its Budget, General Ledger, Telecoms, Travel and Motor Vehicles more effectively. "With Qlik Sense, we have one, consolidated global view of this data," says Brink.
Qlik Sense has made a marked impact on Bidvest Procurement's decision-making, management and operations. According to Brink: "Everything we now do is focused around data-lytics, including the identification of trends and exceptions. All the strategies that we have set are now data-driven."
Brink further confirms that Bidvest Procurement has experienced many benefits from utilising the Qlik platform, largely due to the single, dynamic view it provides. "The tool has taken the disparate data that we used to have and consolidated it into one, reliable format. We are now able to focus on both the macro- and micro-level of the group, its divisions and its companies," believes Brink.
These benefits are most effectively illustrated with a visual comparison between the old, archaic data system, and the new, intuitive and aesthetically pleasing platform. In addition to looking better, being more productive, and allowing for proactivity, cost savings have also been experienced.
In the Telecoms department, for example, stats were leveraged to bring the cost per minute down by an average of 24%. "This was made possible through superior monitoring capabilities, and the visibility needed to align all costs for Bidvest companies within the group. For some customers, this meant up to 57% in savings."
Brink believes other businesses can benefit from implementing Qlik. "Follow our strategy for implementing Qlik. It is 90% planning and 10% action," he advises.
With a view to moving forward, expanding the predictive analysis, and applying machine learning, Bidvest Procurement is evaluating new Qlik Sense licensing fees and models. "The ultimate goal is to move from being reactive to being proactive," concludes Brink.
Customer Name: Bidvest Procurement
Industry: Procurement solutions for the Bidvest Group
Function: Mandated to save the group money on all non-cost of sales operational expenditure
Specific applications: Budget, General Ledger, Telecoms, Travel and Motor Vehicles and Utilities
Generally: Executive, finance, supply chain, logistics
Geography: Johannesburg, South Africa
Challenges: Bidvest Procurement's data management was constantly hampered by the sheer majority and variety of data sources and types at hand. Manually generated information required laborious collation and manipulation. This was time-consuming and ineffective.
Solution: Bidvest Procurement evaluated a host of business intelligence partners. On careful consideration, Qlik Sense was chosen to become its core reporting tool in 2017.
Benefits: Bidvest Procurement can now see a consolidated view of operations across the group. The business is empowered to identify trends and exceptions, as well as structure commercial agreements. More strategic decision-making fed by real-time, reliable data. Disparate data now effectively consolidated for a single view.
Data source: A variety of unstructured, Excel documents. Piviots.
Six months to develop five applications covering Bidvest Group's Budget, General Ledger, Telecoms, Travel and Motor Vehicles, consolidated for a global expenditure view.
Time to value for Telecoms: average 24% reduction in costs per minute. Some customers have experienced up to 57% in cost savings.