Case Study: Blood Product Distribution
SummaryBy understanding and modeling the client's business domain, Nautilus Systems was able to identify critical data elements, data location, identification of metadata (data about data), data model architecture, and design the required data extraction programs. The data extraction programs were used to scrub the data and resolve discrepancies. The extraction programs fed the data extraction database which was used to consolidate the dissimilar and geographically dispersed databases. The extraction database in turn fed the knowledge discovery repository, which was loaded with donor scheduling, recipient blood product requirements, blood collection products delivered, warehousing and production scheduling of disposable components, delivery of disposable collection components, preventative maintenance schedule, and apheresis machine repair parts inventory. Pattern extraction discovery and SAS statistical time phase distribution analysis programs were then run against data in the knowledge discovery repository. The extraction results were analyzed. The premises formed were then used for further analysis and the formulation of predefined queries for future use. A new series of reports were introduced which provided insight to manufacturing and warehousing capacity schedules, client requirements and the potential for repeat sales.
BenefitsThe client continues to use the workflow model to evaluate how strategic plans may affect inventory, product production, costs, schedules, sales, and delivery. Data mining tools enable summarization, categorization, and analysis of data from almost any conceivable viewpoint. New reports provide ongoing insight into manufacturing, warehousing capacity and schedules, and potential for repeat sales.
|