ݺߣ

ݺߣShare a Scribd company logo

Pfizer Mitigates Risk & Reduces Costs with Appfluent

•
•
Appfluent Technology
Appfluent Technology

Pfizer's HR division runs a massive data warehouse that averages over 1 million queries per day from over 3,000 users. They needed to cut data costs and mitigate regulatory and audit risks and decrease costs. See how they met their goals, and reduced extract, transform and load (ETL) times, using Appfluent!

1 of 2
Download to read offline
Customer Pfizer www.pfizer.com Industry: Life Sciences Pfizer Mitigates Risk & Reduces Costs with Appfluent Pfizer applies science and global resources to bring therapies to people that extend and significantly improve their lives. They strive to set the standard for quality, safety and value in the discovery, development and manufacture of health care products. Pfizer’s global portfolio includes medicines, vaccines and many of the world’s best-known consumer health care products. The Challenge The Human Resource division of Pfizer has a massive data warehouse that averages over one million queries per day from more than 3,000 users. The staff managing this vast and growing volume of information was experiencing critical issues with their data warehouse. Their most significant concerns included mitigation of regulatory and audit risks and decrease costs. They also needed to reduce extract, transform and load (ETL) times to meet service-level agreements. However, they did not have visibility into their environment and lacked the data needed to address these issues. The Solution Pfizer selected Appfluent Visibility to provide both BI and data warehouse business activity and data usage analytics to reduce costs, improve SLA’s and ensure trusted usage of information. Appfluent quickly delivered correlated, granular insight into user activity, application data and database information— all without any disruption of production warehouse systems. Case Study
Based on actual data usage activity within the data warehouse, and the reduction of ETL load times, Pfizer estimates a savings of nearly $400,000 per year. 6001 Montrose Road, Suite 1000 Rockville MD 20852 USA 301-770-2888 www.appfluent.com Now, Pfizer can capture and correlate usage-analysis over time. This data is easily shared between all Pfizer BI and data ware- house constituents. As a result, Pfizer was able to gather impor- tant knowledge about their environment and quickly realize returns on their Appfluent investment: • Insight on which data was most frequently used/not used led to a 50% reduction of HR data warehouse storage and annual savings of nearly $400K/year • User activity details led to a 10x decrease in User IDs from 3000 to 300 • Details on data usage activity made way for changes that reduced ETL load times by 75% and saved nearly $80K/year. The insights that Pfizer gained from Appfluent also led to improvements that better supported compliance with industry regulations and reduced their audit risks. About Appfluent Appfluent provides IT organizations with unprecedented visibility into usage and performance of data warehouse and business intelligence systems. IT decision makers can view exactly which enterprise data is being used or not used, determine how business intelligence is performing and identify causes of database perfor- mance issues. With Appfluent, customers can address exploding data growth and start the smart move to Hadoop and Big Data.

More Related Content

Pfizer Mitigates Risk & Reduces Costs with Appfluent

  • 1. Customer Pfizer www.pfizer.com Industry: Life Sciences Pfizer Mitigates Risk & Reduces Costs with Appfluent Pfizer applies science and global resources to bring therapies to people that extend and significantly improve their lives. They strive to set the standard for quality, safety and value in the discovery, development and manufacture of health care products. Pfizer’s global portfolio includes medicines, vaccines and many of the world’s best-known consumer health care products. The Challenge The Human Resource division of Pfizer has a massive data warehouse that averages over one million queries per day from more than 3,000 users. The staff managing this vast and growing volume of information was experiencing critical issues with their data warehouse. Their most significant concerns included mitigation of regulatory and audit risks and decrease costs. They also needed to reduce extract, transform and load (ETL) times to meet service-level agreements. However, they did not have visibility into their environment and lacked the data needed to address these issues. The Solution Pfizer selected Appfluent Visibility to provide both BI and data warehouse business activity and data usage analytics to reduce costs, improve SLA’s and ensure trusted usage of information. Appfluent quickly delivered correlated, granular insight into user activity, application data and database information— all without any disruption of production warehouse systems. Case Study
  • 2. Based on actual data usage activity within the data warehouse, and the reduction of ETL load times, Pfizer estimates a savings of nearly $400,000 per year. 6001 Montrose Road, Suite 1000 Rockville MD 20852 USA 301-770-2888 www.appfluent.com Now, Pfizer can capture and correlate usage-analysis over time. This data is easily shared between all Pfizer BI and data ware- house constituents. As a result, Pfizer was able to gather impor- tant knowledge about their environment and quickly realize returns on their Appfluent investment: • Insight on which data was most frequently used/not used led to a 50% reduction of HR data warehouse storage and annual savings of nearly $400K/year • User activity details led to a 10x decrease in User IDs from 3000 to 300 • Details on data usage activity made way for changes that reduced ETL load times by 75% and saved nearly $80K/year. The insights that Pfizer gained from Appfluent also led to improvements that better supported compliance with industry regulations and reduced their audit risks. About Appfluent Appfluent provides IT organizations with unprecedented visibility into usage and performance of data warehouse and business intelligence systems. IT decision makers can view exactly which enterprise data is being used or not used, determine how business intelligence is performing and identify causes of database perfor- mance issues. With Appfluent, customers can address exploding data growth and start the smart move to Hadoop and Big Data.