Consolidating Data: New Reporting System for Healthcare Client

App Development & Integration

September 24, 2018

Consolidating Data: New Reporting System for Healthcare Client

The Challenge

A large consumer healthcare company needed help consolidating data. They were looking for a reporting system to consolidate all point of sale, shipment, and forecast data to provide users a single location to review all customer data. Our team worked with difficult data models where data formats changed month to month, there were huge volumes of data, and user supplied their POS data differently. Transfer methods and frequency of transfer also differed by user, and both fiscal weeks and UPCs required normalization.

The Solution

Aspirant was engaged to fill all the necessary roles for the delivery of the software product and our team leveraged an out-of-the-box solution for data transfer and workflow. We developed cross customer comparisons; a fruitful advertising and promotion strategy; a way to differentiate between forecast and actual data; and a way to define build and burn rates for products. We also updated existing brand level reporting to include customer segmentation.

The Results

  • Creation of a robust platform that leveraged already existing technologies with minimal training.
  • Graphical User Interface provided the user with the ability to map customer UPCs to internal products.
  • Integrations system searched for new files in the repository, then automatically downloaded them before importing into the warehouse.
  • SQL Server Analysis Service was used for reporting through an Excel interface, and SSAS provided data for a web-based portal for brand and customer P&L.
Phil is Aspirant's Managing Director of the App Development & Integration practice with a focus on providing enterprise-grade solutions. His 30 years of experience have given him the opportunity to work across many markets, industries, and applications. Phil is leading a team of skilled web and mobile developers building strategic solutions for our customers.

Related posts