Qlik > Case Studies > Qlikview Helps Advantage Pharmacy Group Develop New Lines of Business

Qlikview Helps Advantage Pharmacy Group Develop New Lines of Business

Qlik Logo
Customer Company Size
Mid-size Company
Region
  • Pacific
Country
  • Australia
Product
  • QlikView
Tech Stack
  • Microsoft SQL Server
  • Excel
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Pharmaceuticals
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Predictive Quality Analytics
  • Supply Chain Visibility
Services
  • Data Science Services
About The Customer
Advantage Pharmacy Group was established 20 years ago by two business owners in Melbourne, Australia. Since then, it has expanded through 13 business partners and includes 23 wholly-owned pharmacies in Victoria state, and another 27 franchised stores across Australia. The group turnover is around USD $105 million annually and employs 540 staff. The group has always believed in the importance of centralized infrastructure and services. They manage systems like loyalty and marketing services, group ordering and warehousing, and an enterprise resource planning (ERP) system to manage financial services. They have always invested time and money into creating systems and services at the head office and making them available to the pharmacies.
The Challenge
Advantage Pharmacy Group, a successful business in the crowded and competitive market, has always believed in the importance of centralized infrastructure and services. The group manages systems like loyalty and marketing services, group ordering and warehousing, and an enterprise resource planning (ERP) system to manage financial services. However, they were missing a business discovery solution to ease the task of accessing, reporting, and analyzing data across all systems. They considered Microsoft SQL Reporting Services but found it limited and costly. They needed a solution that would unify the data for analysis, provide services to their franchisees, and bring together many disparate data sources in a single meaningful report.
The Solution
The group's IT partner, Professional Advantage, recommended QlikView, a business discovery solution used extensively in local and global environments. They built a proof of concept demonstrating exactly how to unify the data for analysis. Pleased with the results, Advantage Pharmacy gave the project the go ahead. QlikView was initially made available to a limited number of managers. This gave the organization time to test the new system and review the reports to ensure relevant, useful content. After three months, Advantage Pharmacy Group rolled out the system to a wider audience. In mid-2012, the group purchased a further set of licenses ensuring that QlikView was in all its stores. Today, QlikView is used widely for various purposes such as providing data about key performance indicators, providing customer relationship management functionality, and analyzing stock, sales, margins, and store performance.
Operational Impact
  • QlikView has reduced the time taken to prepare reports from two days to half a day every month.
  • The system has made it easier for stores to review historical information or make comparative analyses.
  • Managers can now identify slow moving lines far more quickly, ensuring that intervention strategies such as promotions get put in place.
  • The information provided by QlikView also helps to develop optimal purchasing plans and to allocate product according to likely demand.
Quantitative Benefit
  • Reduced reporting time from two days a month to half a day, saving a day and a half every month.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.