A leading US-based
pharmaceutical company with operations in 15
countries throughout the Asia Pacific region
replaced its OLAP-based BI tool with QlikView to
integrate acquired companies faster. The
company has an aggressive global M&A strategy,
with a new acquisition every five or six
months. The ability to integrate information
from the newly acquired entities is crucial to
success. It’s an enormous challenge for IT to
synthesize data from a myriad of different
systems, as well as for management to get a true
and real-time picture of performance.
Using its OLAP-based
tool, it took months to integrate the new data
sources – bringing data into a data warehouse
and then building new cubes – and IT had to
train (and retrain) users each time the
resulting reports changed. An IT team searched
for a solution that would meet their
requirements:
- Easy to map
and integrate new data sources
- Fast
application rollout
- Short
learning curve
- Extremely
easy to use
- Easy
integration with corporate portal
- Integration
with Windows Active Directory (AD)
QlikView was the
only “prescription” that could solve their
information headaches. In just six months, the
company rolled out seven different QlikView
applications, including a regional dashboard
with access across 15 countries,
country-specific scorecards, weekly sales
analysis, KPI tracking, sales force automation
reporting, IT infrastructure availability and
usage reporting.
These QlikView
applications are housed within the corporate
portal and can be accessed directly through it
with a single sign on point. Security is
ensured through seamless integration with
Windows AD
Now,
applications with the latest consolidated data
are rollout within two weeks of acquisition of
the new company. And QlikView users are trained
– once – in less than 4 hours. The user
friendly click-and-view front end erased the
need for multiple training sessions.
QlikView has not only helped IT achieve the
speed of development the needed, but it also
provides information and analysis to users
throughout the company, giving management they
intelligence it needs to make better decisions
faster.
