QlikView for Life Science Industry Presentation 12/2010 - PowerPoint PPT Presentation


PPT – QlikView for Life Science Industry Presentation 12/2010 PowerPoint presentation | free to download - id: 3d34c5-ZDQ3M


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation

QlikView for Life Science Industry Presentation 12/2010


QlikView for Life Science Industry Presentation 12/2010 Visual Data Group True Business Intelligence TM NHHS Healthcare Consulting * * Thank You! Thank You! – PowerPoint PPT presentation

Number of Views:285
Avg rating:3.0/5.0
Slides: 27
Provided by: nhhshealt


Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: QlikView for Life Science Industry Presentation 12/2010

QlikView for Life Science Industry
Presentation 12/2010
Visual Data Group True Business Intelligence
TM NHHS Healthcare Consulting
  • What if you could answer any question
  • about your business?

  • QlikView Elite Reseller
  • QlikView Level One Support Certified
  • QlikView Developer Certified
  • QlikView Server Certified
  • QlikView Training Certified
  • Project Management
  • Business Process Improvement
  • All aspects of Supply Chain Management
  • Deep Experience in manufacturing, consumer goods,
    healthcare and retail analysis

  • QlikView Elite Reseller
  • QlikView Level One Support Certified
  • QlikView Developer Certified
  • QlikView Server Certified
  • QlikView Training Certified
  • Project Management
  • Business Process Improvement
  • All aspects of Supply Chain Management
  • Deep Experience in manufacturing, consumer goods,
    healthcare and retail analysis

What really affects profitability?
  • Diverse user communities
  • Wide variety of questions
  • Unpredictable situations
  • Cumulative value

Sales / Physicians / Patients / Payers
Putting meaningful answers at the fingertips of
operational decision makers is the key to driving
Common challenges we hear from our customers
Addressing these challenges requires the right
  • How would you write a report to answer the
    following questions?
  • Who are the best physicians for me to call on
  • Where are my concentrations of manufacturing risk
    and how do I best mitigate them?
  • How does our product portfolio and pipeline
    compare to the industry and how can we be more
  • Traditional BI tools that use pre-aggregated
    information or pre-defined views do not provide
    answers to ad-hoc questions

How does QlikView provide answers?
  • QlikView Associative Search
  • A new paradigm for interactive data analysis that
    works the way your mind works
  • Puts analytical power into the hands of ordinary
    business users
  • Enabled by QlikTechs patented in-memory
    associative database technology
  • Driven by huge advances in computing power

Where does the real value of an application lie?
Technology Costs
Business Benefits
  • Reduced license cost
  • Reduced consulting spend
  • Reduced systems maintenance
  • Reduced development costs and timelines
  • Reduced reporting FTEs and costs
  • More efficient training
  • Improved adoption
  • Reduced technology risk
  • Increased drug uptake through improved physician
    sales visibility
  • Improved conversion of marketing campaigns
  • Increased manufacturing site uptime and
    production capability
  • Simplified, faster, and immediate reporting
  • More profitable products
  • Reduced IT costs and rapid ROI

ROI is often measured in terms of technology cost
reduction. However, the real value exists in
improving business performance. This can only be
achieved by matching the right tools to the right
types of problems.
Common types of QlikView applications in
Pharmaceuticals Biotech
Customer (Patient Physician) Analysis
Operational BI
Sales Performance Management
Supply Chain Analysis for Inventory Optimization
Clinical Trial Analysis and Reporting
Manufacturing Release Process, Uptime Analysis
Legal Response Compliance Management
Financial Analysis for PL Management Reporting
Operations Analysis and IT Reporting
Executive Dashboards, Business Overview,
Order Fulfillment Analysis and Optimization
The QlikView experience
  • Delivers the big picture and deep drill-down
  • Consolidates information rapidly from any data
  • Searches data with Google-like ease
  • Visualizes data with state-of-the-art graphics
  • Forecasts, trends and creates what-if scenarios
  • Self-service custom apps and dashboards
  • Access anywhere desktop, mobile, cloud
  • Complementary to traditional BI and reporting

The proof is in the voice of our customers
The proof is in the voice of our customers
QlikView customers in Pharmaceuticals Biotech
More than 100 Pharmaceutical Biotech Companies
are Leveraging QlikView, worldwide
Select customer deployments
Supply Chain
  • Sales Performance
  • Customer Analysis
  • Financial Analysis for PL
  • Supply Chain Analysis
  • Inventory Optimization
  • Clinical Trial Analysis Reporting
  • Manufacturing Release Process (MRP) Analysis
  • Sales Analysis
  • Financial Analysis Compliance
  • Budget Mgmt.
  • Supply Chain Analysis
  • Inventory Management
  • Clinical Trial Analysis Reporting
  • Operational Efficiency Planning
  • Operations and Reporting Improvement
  • Sales Analysis
  • Order Fulfillment
  • Executive Level Sales Analysis
  • Sales Performance
  • Marketing Analysis
  • Customer Analysis
  • Operational Analysis
  • Supply Chain Analysis
  • Demand Synchronization
  • Operational Analysis
  • Global IT Data Management
  • Executive Dashboards
  • Global Product Sales Performance
  • Global Marketing Dashboard
  • Global Financial Analysis Reporting

A Leading Pharma Co.
  • Sales Analysis
  • Field Sales Updates
  • E-Detailing Analysis
  • Messaging Updates
  • Legal Compliance Reporting - FDA
  • Legal Compliance Reporting - FDA
  • Financial Analysis Reporting

Pharmaceutical Biopharmaceutical Leader
Industry leading biomedical and pharmaceutical
company that the develops, markets and sells
products for many therapeutic classes.
  • Challenges
  • Provide field sales with actionable customer and
    market intelligence
  • Rapidly respond to requests from judges and
    regulatory agencies
  • Analyze millions of rows of data from multiple
    sources on-the-fly
  • Solution
  • Deployed QlikView to over 300 users (2000
    planned) in 8 weeks
  • Financial Analysis
  • Sales Analysis
  • Marketing
  • Legal / Compliance
  • Results
  • Reduced delivery time for monthly analysis
    updates to field sales by 30
  • Added capabilities for business users to conduct
    self-service ad hoc analysis
  • Reduced cycle time for e-detailing analysis and
    messaging updates by 75
  • ROI conservatively projected at 1.2 million per
    year in IT cost savings alone

1.2 million saved annually in IT costs alone 30
less time in monthly updates to field sales 75
decrease in cycle time for e-detailing updates
Merck Sharp Dohme Netherlands
A Dutch subsidiary of the US corporation Merck
Co., which ranks as one of the leading
pharmaceutical enterprises in the world with 22
billion in revenue and 60,000 employees.
  • Challenges
  • Analyze financial data from JD Edwards World
    quickly and easily
  • Comply with the internally used consolidation
  • Conduct detailed analyses
  • Solution
  • Deployed QlikView to over 40 users
  • Financial Analysis
  • Sales Analysis
  • Supply Chain Analysis for Inventory Management
  • Results
  • Complied with Merck Co.s consolidation rules
  • Simplified budget management
  • Required no specialist knowledge
  • Proven solution that can be linked to the future
    ERP system, SAP

Simple improved budget management Compatible
compliant with systems policies
Merck Ltd. Japan
A subsidiary of Merck KGaA, Germany, one of the
leading pharmaceutical and chemicals companies in
the world with 600 million in revenue and 475
  • Challenges
  • Maintain high-profile standing in an increasingly
    segmented market
  • Monitor operational performance against top and
    bottom line measures to ensure financial targets
    are met
  • Maximize sales performance against targets and
  • Solution
  • Deployed QlikView to 15 users across 4 functions
    in the Asia Pacific region
  • Executive Analysis and Health Check Across
  • Sales Performance Customer Analysis
  • Supply Chain Analysis for Inventory Optimization
  • Financial Analysis for PL of Over 100 Businesses
  • Results
  • Improved predictability of financial performance
  • Increased sales performance within customer
  • Gain overall view of the business and the ability
    to drill into the details to identify issues and
    solve problems quickly

Increased sales performance Improved financial
performance Command central for leadership
FFF Enterprises
Leading 700 M revenue multidimensional
healthcare company, delivering innovative
solutions in biopharmaceutical management and
distribution, health information management and
consumer healthcare services
  • Challenges
  • Accelerate the availability of lifesaving
    products and services
  • Respond at lightning speed to rapid market
  • Maintain reputation as a finger-on-the-pulse
    enterprise with information integrity
  • Solution
  • Deployed QlikView to 65 users across 7
    functions in US in 4 weeks
  • Executive Analysis
  • Sales Marketing Analysis
  • Supply Chain Analysis
  • Operational Analysis Finance IT
  • Results
  • Enabled timely market execution and customer
    responsiveness through instant information access
  • Provided up-to-date figures on demand chain
    synchronizing planning by business partners and
  • Adoption and success within a week, the
    President and CEO was pulling out key sales
    records before meetings
  • Raised efficiency levels, saving the company time
    and money

Immediate and accurate supply demand figures 1
week executive-level adoption Increased
efficiency reduced costs
ALK-Abelló is a global leader within the
development and production of drugs used for the
diagnosis of allergy and for vaccines against
allergy and with over 1.7B DKK in turnover.
  • Challenges
  • Need for quick and efficient overview of complex
    clinical database prior to MRP procedure
  • Few people with the qualifications to create the
    needed overview and to retrieve data from the
    database a bottleneck in a procedure with tight
  • Solution
  • Deployed QlikView to 20 users across all
  • MRP Procedure Analysis Reporting
  • Clinical Trial Analysis Reporting
  • Expansion into other functional areas for data
  • Results
  • Opportunity to make collection of data and
    information more efficient in a market
    characterized by though competition
  • Eliminates the competence bottleneck
  • ROI in 1-2 month

1-2 month ROI Competitive advantage in a highly
competitive market
Lundbeck A/S
Lundbeck A/S is an international pharmaceutical
whose business is research and development,
production, marketing and sales of medications
for the treatment of psychiatric and neurological
  • Challenges
  • Need to provide quickly and effectively an
    overview of complex clinical and operational data
  • Complex reporting practices and tools
    necessitated a complete overhaul and a new
    simplified method of reporting
  • Solution
  • Deployed QlikView to users in
  • Clinical Trial Analysis Reporting
  • Operations
  • Converted more than 150 reports to QlikView
    reports in a very short amount of time
  • Results
  • Better basis for planning
  • Better and more efficient knowledge-sharing
  • Reduced maintenance
  • Collected clinical data from Lundbecks numerous
    databases, in a compatible format, and stored
    them on an electronic platform, from which users
    easily obtain overviews

Reduced over 150 reports to 2 comprehensive
reports Easy comparison across clinical trials
Gen-Probe Incorporated is a global leader in the
development, manufacture and marketing of
molecular diagnostics products and services that
are used to diagnose human diseases, screen
donated human blood, ensure transplant
compatibility, and aid biomedical research.
  • Challenges
  • Data is sourced from multiple systems including
    SAP, Siebel and TrackWise
  • Needed a better understanding of supply and
    demand and way to manage inventory effectively
  • Solution
  • Deployed QlikView to 9 business functions, 84
    users in
  • Sales analysis
  • Operations (over 200 people receive QV reports)
  • Order fulfillment
  • Results
  • Reduced monthly back orders by 92
  • Expedited production orders by 55 and at risk
    orders by 86
  • Impoved sales order fulfillment (orders complete
    per missed order) to 751 (far above the industry
    standard of 251)
  • Instituted enterprise visibility,
    cross-functional collaboration, KPI tracking,
    demand analysis, and proactive identification of

Reduced by 92 all backorders 55 increase in
expedited production orders Improved sales order
fulfillment to 3x the industry standard
Quotes and Testimonials
Quotes and Testimonials
A new kind of software company
  • Worlds fastest-growing BI vendor
  • U.S. based company, founded in 1993 in Sweden
  • 15,000 customers in 100 countries
  • 1,100 global partners
  • More than 650 employees across 22 offices in 12
  • High customer success rate
  • Seeing is believing
  • In 2-3 days, we will build any company a working
    QlikView application using its own data

Worldwide BI Tools 2008 Vendor Shares, IDC
June 2009
Visual Data Group 7362 W Cross Creek
Trail Brecksville, OH 44141 440.736.7151
www.visualdatagroup.com sales_at_visualdatagroup.com
About PowerShow.com