Subscribe
About

eBucks streamlines data with new data warehouse

By Anti-Clockwise
Johannesburg, 06 Aug 2009

With large amounts of data from disparate sources, South Africa's leading rewards programme, eBucks, turned to Qinfo to create a framework for its SAS data warehouse, which centrally stores and manage its business information.

The rewards programme has a proven track record in applying innovative technology solutions to drive partner profits through the intelligent analysis of member data.

eBucks has over 1.6 million members who are highly active, spending in excess of 80% of the eBucks they have earned in any given month. Over R1.3 billion worth of eBucks have been allocated by partners, most notably FNB, eBucks' biggest partner, since the programme's inception in October 2000.

“With the massive growth in data volumes and ever more sophisticated data requirements, we needed a central, efficient data store with a single view of the organisation that would allow swift access to data within a fully secure environment,” says Benjamin Marais, CIO at eBucks.

After a vigorous selection process, eBucks elected to deploy a data warehouse and selected business intelligence consultancy firm, Qinfo, as its preferred implementation partner, on the basis of its advanced technical skills and extensive knowledge of the SAS data warehouse technology.

The project kicked off in 2006, with a two-year delivery timeframe. The system is now fully operational, but the project was not without the challenge of frequent remapping of data sources to meet changing business needs.

“One of the biggest challenges facing us before we could populate the warehouse was data consistency,” says Sam Manyama, managing director at Qinfo. “It was with this that we set about creating a data framework that tied into the organisation's overall business policies, but at the same time was flexible enough for all users.

“There was a lot of pressure to deliver, and to deliver quickly, as every delay on the implementation meant lost marketing opportunities for eBucks. In the end, we are happy with what we produced and believe that eBucks are innovators in their use of the technology,” he adds.

The SAS technology, selected for its scalability, needed to provide a solid data foundation to support eBucks' enterprise information needs. It needed to provide enterprise data access and processing across systems and platforms, as well as integrated data quality. In short eBucks needed a warehouse framework that would provide it with accurate, consistent information, and an interactive, visual data integration development environment that enabled collaboration and easy reusability.

“In our business, we can't afford to not have access to our data, we use it everyday, in every campaign we develop and in every decision we make. With this framework, we now have the capability to create a robust warehouse and quickly make changes to an ever-expanding data environment,” concludes Marais.

Share

eBucks

eBucks, the Reward of Choice, is widely acknowledged as South Africa's leading rewards programme. Voted 'Most Valuable Multi-Partner' and 'Most Valuable Retail Rewards Programme' in the latest Razor's Edge Value in Rewards Programmes survey, eBucks is widely recognised as an innovation leader and has many local and global industry firsts to its name.

As a multi-partner programme, its business model is based on partner companies, such as FNB, allocating eBucks to their customers to reward them for their loyalty. Customers would be spending on their credit cards/cheque accounts or buying a particular product in the retail world anyway. eBucks helps shift that spend to partners rather than their competitors. The reward is funded from the increased profitability and both the partner and their customers benefit from eBucks.

The programme offers South Africa's widest choice of spend opportunities and an extensive range of spend channels. eBucks can be spent in the eBucks shop, which was named as the top online retailer in the country in October 2008; at eBucks auctions; through eBucks travel; with eBucks' Internet partners; or at eBucks' retail partners with the eBucks card.

Qinfo

Qinfo Solutions is an IT company that primarily focuses on business intelligence solutions. Qinfo Solutions aims to deliver competitive advantage from our clients' data through consulting, strong work ethics and consistent client liaison.

QInfo has four directors who share between them solid consultancy experience in SAS Consulting, IT Audit and Corporate Training and provides highly experienced SAS data warehouse, reporting and business intelligence resources ready to unlock value for our clients across the entire intelligence value chain.

SAS

SAS is the leader in business analytics software and services, and the largest independent vendor in the business intelligence market. Through innovative solutions delivered within an integrated framework, SAS helps customers at more than 45 000 sites improve performance and deliver value by making better decisions faster. Since 1976, SAS has been giving customers around the world 'the power to know'. http://www.sas.com and http://www.sas.com/sa

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. (R) indicates USA registration. Other brand and product names are trademarks of their respective companies. Copyright (c) 2009 SAS Institute Inc. All rights reserved.

Editorial contacts