Case Study

Case Study — Pharmaceutical Patient Integration & Reporting

Pharmaceutical Patient Integration and Reporting
Improving Outcomes for an At-Risk Population

Client: A consortium of three organizations — a pharmaceutical manufacturer, the distributor of their genetic treatment, and a patient service organization
Industry: Pharmaceuticals
Company Size: NA

NOTE: Several of our clients have strict corporate policies against associating their names with testimonials and case studies for any product or service. As a result, this case study describes a situation for which the related clients have requested anonymity.


The ultimate beneficiaries of this project are sufferers of a rare genetic condition. Without treatment, these individuals can experience difficulty performing everyday tasks, difficulty breathing, increased incidence of disease and, ultimately, decreased lifespans. While not curable, this condition is treatable.

To better serve this population, a group of three interested parties realized that sharing data could allow researchers to discover facts hidden in their separate data sets. The parties included a multinational pharmaceutical company that manufactures a treatment, the specialty pharmacy that distributes the treatment, and a patient service organization that works with sufferers to manage their conditions and improve their quality of life.

The group needed to integrate their data sets in a way that would support research yet strictly protect the privacy of the individuals whose data is included in the system.


This project entailed a variety of requirements and challenges including:

  • Gathering and integrating data from multiple organizations, each with unique systems and IT capabilities.
  • Providing an easy-to-use business intelligence front end to present summary data while hiding all details about individual patients.
  • Hosting the data on a neutral server controlled by a party completely separate from the three partners.
  • Ensuring that the system is absolutely compliant with all HIPAA privacy regulations.


The consortium decided to contract with a vendor to build and host a data warehouse, accessible by users via a business intelligence tool. A number of vendors and approaches were considered.

Dataspace reviewed the situation and realized that the data warehouse envisioned by the consortium was overkill given its stated needs. To minimize costs and delivery timeframes, the firm proposed an approach built on the QlikView in-memory business intelligence tool.


The consortium chose to work with Dataspace which built a solution, running in the cloud, that integrates the necessary data and makes it available to authorized parties through a point and click interface. Dataspace manages and periodically refreshes the system and handles all user requests for support.


The resulting system has been very successful in helping users identify previously hidden trends and correlations. Specific feedback back to Dataspace from one of the leading researchers in this field, after presenting the system to the board of the patient care organization, included the following:

“Basically, the board was so impressed by the data displays I showed them that the chair eventually had to intervene so we could get on with the meeting. Thanks for all your help with this”




Headquartered in Ann Arbor, Michigan, Dataspace is a consulting firm with a national client base. Since its founding in 1994, the firm has focused solely and passionately on providing unparalleled expertise in data management, business intelligence, and data warehousing strategy and implementation.

making data make sense