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

Edit This Case Study Record

	Qlikview Helps Advantage Pharmacy Group Develop New Lines of Business Qlik

Qlikview Helps Advantage Pharmacy Group Develop New Lines of Business

Qlik

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	QlikView has reduced the time taken to prepare reports from two days to half a day every month.
Impact #2	The system has made it easier for stores to review historical information or make comparative analyses.
Impact #3	Managers can now identify slow moving lines far more quickly, ensuring that intervention strategies such as promotions get put in place.

Impact #1

QlikView has reduced the time taken to prepare reports from two days to half a day every month.

Impact #2

The system has made it easier for stores to review historical information or make comparative analyses.

Impact #3

Managers can now identify slow moving lines far more quickly, ensuring that intervention strategies such as promotions get put in place.

Benefit #1	Reduced reporting time from two days a month to half a day, saving a day and a half every month.

Benefit #1

Reduced reporting time from two days a month to half a day, saving a day and a half every month.

Download PDF Version

Overview

Qlikview Helps Advantage Pharmacy Group Develop New Lines of Business

Operational Impact

Quantitative Benefit