Download PDF
Qlik > Case Studies > Merck Sharp & Dohme consolidates according to business rules using QlikView
Qlik Logo

Merck Sharp & Dohme consolidates according to business rules using QlikView

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
The 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 The 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.
The 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.
Operational Impact
  • Complied with Merck & Co.’s consolidation rules
  • Simplified budget management
  • Required no specialist knowledge

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.