Qlik Case Studies Merck Sharp & Dohme consolidates according to business rules using QlikView

Edit This Case Study Record

	Merck Sharp & Dohme consolidates according to business rules using QlikView Qlik

Merck Sharp & Dohme consolidates according to business rules using QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Pharmaceuticals
Applicable Functions	Sales & Marketing
Use Cases	Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	Merck Sharp & Dohme B.V. (MSD), the Dutch subsidiary of the US corporation Merck & Co., was using JD Edwards World, a worldwide financial system with limited scope for analysis and reporting. The parent company uses the data from this system to make consolidations and draw up the annual financial statements. It applies a complex set of rules which determine what costs are allocated to what items in the balance sheet and the profit and loss account. MSD Netherlands has to account for any differences in balance sheet items by conducting a detailed analysis. The challenge was to find a solution that would allow them to analyze the data from their financial system quickly and easily, and also take account of their specific set of rules. Read More
About Customer	Merck Sharp & Dohme B.V. (MSD) is the Dutch subsidiary of the US corporation Merck & Co., which ranks as one of the most important pharmaceutical enterprises in the world, with $ 22 billion in revenue and 60,000 employees. MSD employs around 1,000 people spread between the Human Health Europe (HHE) Division and the Merck Manufacturing Division (MMD). HHE concentrates on the marketing and sales of drugs in the Dutch market. MMD is responsible for the production of drugs for distribution in the EMEA region. Read More
Solution	Merck Sharp & Dohme deployed QlikView to more than 40 employees. With QlikView, Merck Sharp & Dohme has insight into all the relevant rules-based financial information, anytime. It can analyze product, inventory, pricing and sales data in no time - all focused on driving corporate profitability. With QlikView Server, MSD easily supports security and visibility while handling large data volumes. QlikView is very user-friendly. Even a non-professional learns to operate QlikView in no time. If you want to look at different screens or reports, then that’s no problem at all. You don’t have to be a computer whiz to find the information you need – or to ‘read’ the analyses, which are clear and understandable. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Pharmaceuticals

Applicable Functions

Sales & Marketing

Use Cases

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

Merck Sharp & Dohme B.V. (MSD), the Dutch subsidiary of the US corporation Merck & Co., was using JD Edwards World, a worldwide financial system with limited scope for analysis and reporting. The parent company uses the data from this system to make consolidations and draw up the annual financial statements. It applies a complex set of rules which determine what costs are allocated to what items in the balance sheet and the profit and loss account. MSD Netherlands has to account for any differences in balance sheet items by conducting a detailed analysis. The challenge was to find a solution that would allow them to analyze the data from their financial system quickly and easily, and also take account of their specific set of rules.

About Customer

Merck Sharp & Dohme B.V. (MSD) is the Dutch subsidiary of the US corporation Merck & Co., which ranks as one of the most important pharmaceutical enterprises in the world, with $ 22 billion in revenue and 60,000 employees. MSD employs around 1,000 people spread between the Human Health Europe (HHE) Division and the Merck Manufacturing Division (MMD). HHE concentrates on the marketing and sales of drugs in the Dutch market. MMD is responsible for the production of drugs for distribution in the EMEA region.

Solution

Merck Sharp & Dohme deployed QlikView to more than 40 employees. With QlikView, Merck Sharp & Dohme has insight into all the relevant rules-based financial information, anytime. It can analyze product, inventory, pricing and sales data in no time - all focused on driving corporate profitability. With QlikView Server, MSD easily supports security and visibility while handling large data volumes. QlikView is very user-friendly. Even a non-professional learns to operate QlikView in no time. If you want to look at different screens or reports, then that’s no problem at all. You don’t have to be a computer whiz to find the information you need – or to ‘read’ the analyses, which are clear and understandable.

Impact #1	Complied with Merck & Co.’s consolidation rules
Impact #2	Simplified budget management
Impact #3	Required no specialist knowledge

Impact #1

Complied with Merck & Co.’s consolidation rules

Impact #2

Simplified budget management

Impact #3

Required no specialist knowledge

Download PDF Version

Overview

Merck Sharp & Dohme consolidates according to business rules using QlikView

Operational Impact