CIO Summit: Swisse Vitamins streamlines analytics with Qlikview
- 12 October, 2011 09:00
An old Access database lacking the key features required by a growing company led Swisse Vitamins ICT and BI manger, Andrew Millingen, to champion the need for a fresh start.
The company had spent many years and significant and money on systems that failed to meet the needs of the business.
SLIDESHOW: See all the action from CIO Summit in Melbourne.
On joining the company in 2005, Millingen said the company was “pretty light on the IT” side of things, with just a small Access database for field employees, a DOS-based accounting package and poor reporting functionality.
After going to market for both new enterprise resource planning (ERP) and customer relationship management (CRM) systems, the organisation brought in Sage products for both and was recommended Hyperia Interactive Reporting.
According to Millingen, both he and the CIO did not have a great deal of familiarity with Hyperia, which the company employed for four years.
“It’s basically like glorified tables in Excel, obviously with a bit more power, it may not have been the most appropriate thing for us at the time but we didn’t know any better.
“Hyperia could group data on the fly which was quite handy but also quite messy if you didn’t have a single version of the truth,” he said.
As the need to connect to multiple data sources occurred more frequently and business growth accelerated (Swisse experienced 60 per cent growth in 2010), Swisse invested in a couple of “pseudo” data warehouses, Millingen said.
“It was useful when we had two or three data sources but as the sources grew… Hyperia couldn’t really do what we needed it to do so we probably wasted a lot of time and money.”
Enough was enough, Millingen said, and the organisation ended its long-term relationship and moved away from Hyperia.
Millingen read reviews, blogs, Faecbook, LinkedIn, tweets, whitepapers, played with versions of BI software and tested trial versions all in the quest to find a BI platform that would work for Swisse. During this process he shortlisted three companies, all of which were pushing him in the direction of Qlikview software.
The non-negotiables for Swisse, Millingen said, were the provision of local support, future proofing in terms of scalability, a platform with a large user base and one that was agile and fast moving to enable the business to make quick decisions and maintain a competitive advantage.
Following a proof of concept, and extensive decision process, Millingen was finally satisfied with implementing Qlikview.
In the first week, an error amounting to $300,000 in pharmaceutical discounts claim came through from distributors, Milligen said, which he used Qlikview to analyse.
“It literally took about 10 minutes. We connected to the data and found 258,000 erroneous claims and were able to go back in confidence to the distributor and within a few weeks had recovered the money.”
The platform can easily combine Swisse’s data from different sources including warehouse data, stock-on-hand data that comes in from Woolworths, Coles and other pharmaceutical distributors, and scanned data purchased from agencies to measure what’s going on in the market.
“The management of users and security is really straightforward and the way document licensing is done,” he said. “We’ve got a Web portal so staff just go through the browser they don’t have to have the Qlikview software.”
Despite no formal rollout across the organisation, almost every team is using the software for analysis, Millingen said, and training took “about five minutes” even for the least savvy IT users.
The organisation is also progressively moving away from the use of data warehouses, which Millingen describes as a “dinosaur”.
“I’d rather pour money into advanced Qlikview training or more licences so more users can design dashboards. To pour money into the data warehouse every time you have a new data source just gets ridiculous after awhile; you have to wait a few days, you pay for it then the smallest thing changes and you’ve got to do it again.”
Millingen said despite the Swisse implementation of Qlikview being quite rapid, organisations should roll it out gradually and let staff get used to the platform.
“Start with the basics, ensure data integrity, reconcile new reports to old reports and you can build on the foundations as you get to know the product.”
“You still need great analysts; the investment in people is just important or even more important as the investment in technology.”
Join the CIO Australia group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.
- Industry Edge: Health & Life Sciences Edition
- Information Security, Virtualisation, and the Journey to the Cloud
- Case Study: Gadens Law Firm Reclaims 22 Hours of Lost Productivity Each Month
- Making Smarter Manufacturing Decisions With Business Intelligence
- Oracle Optimised Solution for Enterprise Cloud Infrastructure
Why change management doesn’t work
Larry Page wants to see your medical records
Dual-Persona Smartphones Not a BYOD Panacea
After two-year hiatus, EFF accepts bitcoin donations again
CIOs struggle to deliver timely mobile business apps: survey
Staying Ahead of the Data Explosion
The total volume of data being processed and stored by businesses is rising exponentially. IDC has estimated that the size of the "digital universe" will increase 29 fold between 2010 and 2020. Data storage technology has undergone a steady increase in capacity, along with a steady decline in the cost per unit to store information. Unfortunately, data storage capacity is not keeping pace with data growth and necessitating greater intelligence in the storage infrastructure. Read more.
Accelerate Cloud and Composite Application Delivery
Are your requirements the need for faster release cycles, you have reduced budgets required to run and manage a complex test environment, and you want to decrease your third party expenses? HP Service Virtualisation, designed to enable your teams to create, develop and test against virtual services that simulate real service behaviour with no constraints, available anytime.
Saving Time and Money with Savvy Use of Flash in Automated Storage Tiering
In a sluggish economy, getting the best ROI on every IT dollar spent is the top priority for almost every business. Storage budgets in most IT environments continue to remain flat or are capped as a percentage of the overall IT spend, while data storage requirements continue to grow at an unsustainable pace. Download now to learn about the benefits of using flash in automated storage tiering.