Delivering Predictive Analytics for a Pharmaceutical Company

About the Client

Based out of Maryland, our client is a pharmaceutical company focused on the research, development and distribution of novel medicines and therapies to help improve the lives of people around the world who are affected by rare & unusual diseases. They also provide support to patients and their families through education and resources.

Business Challenge

The client had several automated systems for most of its business and administrative areas of operation, not all of which communicated with each other. This is a common challenge faced by organizations world over, where they adopt software solutions that solve a pressing need but create another in the process. With data existing in multiple locations, the client had trouble getting a clear view about their business and was struggling with reporting and budgeting. The challenge was to connect all these
disparate systems and deliver a clear view of their business.

Business Benefit

  • Capturing and storing data from different sources and empowering users to deliver meaningful analytics throughout the enterprise.
  • An end-to-end, scalable and integrated solution.
  • The solution was capable of capturing and storing data from different entities across the company.
  • An efficient Data Analytics tool capable of delivering meaningful and customizable insights for a better understanding of organisational information

InApp is a software services company operating since 2000. As a world-class business solution provider, we are passionate about technology and building transformative business solutions that empower our clients worldwide, ranging from Fortune 500 companies to SMBs. We take pride in being a technology partner for the long haul, delivering exceptional value to customers through innovation and excellence. We offer an integrated portfolio of software services including Application Services, Software Product Engineering, Disruptive Technology Solutions, DevOps, Mobility Solutions, Independent Testing and more

InApp’s Solution

The project to connect all the disparate systems at the client office was done using GoodData, which is a cloud-based business intelligence and big data analytics platform. The data was available in application databases, spreadsheets and sometimes even hard copy. The platform brought together these data from multiple proprietary applications such as Microsoft Dynamics CRM, Salesforce, SharePoint, Google Analytics and presented in a meaningful manner for decision support systems. These would include Reports, Graphs, Trend Analysis, Forecasting, Predictive and Prescriptive Analysis for Business Performance Management.

Analytics Engine

The GoodData Extensible Analytics Engine lets users build metrics on the fly. With multilevel caching for exceptional performance, the modular analytics engine runs on no cube technology for flexible slice-and-dice functionality. We used the flexible tool in GoodDatacalled Multi-Dimension Analytical Query Language (MAQL) for describing metrics

Visualization

Using GoodData we built a rich user interface for reporting and data visualization that enable users to create expressive dashboards with a high degree of customization, including logos, photos, rich multimedia content and interactive widgets. Employing HTML5 and pureJavaScript ember.js, t he application offers full cross-platform compatibility. Users can access reports and dashboards on any mobile device and schedule regular delivery via e-mail.

Dashboards

One of the dashboards created was for the sales team, to help stay on top of the metrics that drive their business. Salesperson performance dashboards based out of data from SalesForce.com is another example. These dashboards developed using GoodData are completely compatible with Salesforce so that the users can see the dashboards directly in tabs using Single Sign-on

Logical Data Modelling and Data Loading

Data modelling and data loading were done using GoodData’s data loading service, CloudConnect Designer, a desktop application in which graphical representations of the logical data models (defines the relationships between facts and attributes) and ETL graphs (graphical representation of an ETL process) were built. This was then published to GoodData projects