AstraZeneca assures product quality, maximizes production efficiency with SAS® Enterprise Business Intelligence
When AstraZeneca set out to make the manufacturing process for its Turbuhaler product more cost-effective and to minimize variations, the global pharmaceutical manufacturer faced a major challenge: building a solution with enough capacity to handle all of the production-related data that was stored in so many unique systems. The company sought a rational way to merge and process the data as well as to eliminate the time-consuming manual process of analyzing production for obstacles, errors and irregularities.
AstraZeneca asked SAS to produce a prototype of a business intelligence solution with the capacity to store, analyze and generate reports for a large number of different user groups. The goal was to increase yield, improve quality, minimize variations and save time.
A major part of AstraZeneca’s sales
Products based on Turbuhaler are among AstraZeneca's most important, and they account for a major part of the total sales within the respiratory and inflammation therapy area.
Turbuhaler's advanced manufacturing process is divided into a number of process steps, each with many factors that affect product quality. The quantity of data produced in the manufacturing process is both complex and extensive.
Millions of rows
AstraZeneca chose SAS after testing several suppliers. SAS produced a prototype, which structured the information, defined the user groups and determined the necessary security levels for different groups. The prototype covered all the steps in the production processes for both the drug and the Turbuhaler.
"SAS demonstrated enormous commitment during the pilot study, and we were able to identify a lot of additional benefits with SAS," says Henrik Åkerblom, a process engineer and one of those responsible for the implementation of the SAS solution. "They helped us understand the system's many possibilities."
"SAS works very well with the type of data we work with. Instead of using our time to collect the data, we can focus on analyzing it," stresses Nossborn.
High quality requirements, many users
Between 50 and 100 employees create or receive the reports from the system. The primary users are the process engineers, who are responsible for following up on daily production. They receive prepared reports and are also able to develop their own special reports. Other users include operators, statisticians, analysts and those responsible for quality assurance, as well as other managers within the company.
The primary advantage with SAS is the time saved. But saving time was only part of the original motive behind the system; streamlining production with one comprehensive plan was equally important.
"We work continuously to increase productivity," says Åkerblom. "This applies to increasing utilization level during production and increasing the yield and quality of the products. Using SAS, we have been able to minimize the variations in the production process and expand the contents of the analyses performed."
AstraZeneca plans to extend the SAS solution to other products and product groups.
"Originally, the system only managed Symbicort Turbuhaler, but now several other products in the same family which are produced in AstraZeneca's Swedish operations have been included under the system," says Åkerblom, "and we plan to use the same system for completely different product groups."
Copyright © SAS Institute Inc. All Rights Reserved.
Quickly, easily analyze large amounts of production, manufacturing data in order to find solutions for lowering production costs and reducing manufacturing variations for AstraZeneca's Turbuhaler inhaler
SAS Enterprise BI Server
Turbuhaler production staff now have automatic access to the same quality-assured data throughout the process for analysis, evaluation and decision making, which provides unlimited possibilities for sharing knowledge. Before implementing SAS, the Turbuhaler team manually transferred all of the data – from many systems – required for each production batch with SAS, data management is now automated for each production batch, allowing for quick analysis throughout the manufacturing process.
“Instead of using our time to collect the data, we can focus on analyzing it.”