Procter & Gamble Completes Point-of-Sale Data Queries up to 30 Times Faster, Reduces IT Costs, and Improves Insight with Engineered Data Warehouse Solution
 
Oracle 1-800-633-0738
Find an Oracle Specialized Partner
Oracle Customer Programs
 
 

Procter & Gamble Completes Point-of-Sale Data Queries up to 30 Times Faster, Reduces IT Costs, and Improves Insight with Engineered Data Warehouse Solution

Procter and Gamble (P&G) touches the lives of approximately 4.4 billion people in 180 countries with its extensive consumer-brand portfolio, which encompasses personal care, household cleaning, laundry detergent, and prescription drug products. The company’s leading brands include Pampers, Tide, Ariel, Always, Whisper, Pantene, Mach3, Bounty, and Dawn.

 
Challenges and Solutions

A word from Procter and Gamble

  • “With Oracle Exadata, we have a single machine―combining hardware and software―that forms the foundation for our business intelligence environment. This simplifies our IT landscape significantly, helps us reduce costs, and gives us a single partner for managing our end-to-end environment.”– Jim Fortner, Vice President of IT Development and Operations, P&G

To foster innovation and effectively meet changing market demands, the P&G Global Business Services (GBS) organization relies on insight from terabytes of point-of-sale data collected from retailers around the globe. As data volume and business intelligence requirements grew, the company began to reassess its legacy data warehouse environment. The infrastructure, which included multiple Oracle and nonOracle database environments, was costly and inefficient, restricted business agility, and resulted in siloed customer data that prevented optimal visibility and analysis. Point-of-sale data queries could take hours and sometimes would fail to process.

GBS looked for a way to improve the performance and cost-effectiveness of its data warehouse environment and wanted to expand its analytical and brand decision-making capabilities. Consolidating point-of-sale data into a single data warehouse platform was fundamental to these objectives.

“We had essentially two challenges in the data warehouse space. We wanted to cut costs and improve performance when analyzing massive amounts of data,” said Corrado Azzarita, director, IT development and operations, P&G. 

After considering several options, GBS selected Oracle Exadata Database Machine as the foundation for its new data warehouse infrastructure, initially deploying V2 machines and later expanding with X2-2 and X2-8 machines to fully convert multiple data warehouse landscapes to Exadata hardware. The solution provides a complete, optimized package of software, servers, and storage that deploys rapidly and streamlines IT management.

With the implementation, the company consolidated customer point-of-sale data into one repository, enhancing control over information assets and extending visibility. Expanded analytical capabilities are enabling P&G to enhance its business agility and scalability to support continued innovation and growth. Today, the company can respond more quickly to emerging trends and needs.

Using Oracle Exadata, GBS can complete some queries up to 30 times faster. Prior to the implementation, one periodic end-user query required upwards of 20 hours to complete, sometimes failing to complete the cycle entirely. With Oracle Exadata, the same query takes three minutes to complete.

In addition, the company streamlined operations and improved stability by consolidating information into a single repository.

“With Oracle Exadata, we can conduct analysis and respond to the data much quicker than ever before. The end-to-end support model is a second benefit,” said Jim Fortner, vice president of IT development and operations, P&G. “You have hardware, software, and support all wrapped up from a single vendor. Cost is the third major benefit. It’s simply easier and more cost-effective to own and manage. From a performance, cost, and support perspective, Oracle Exadata Database Machine is creating big value for P&G.”

 
 

 
 

Oracle Product and Services

Why Oracle

“We chose Oracle Exadata because we wanted an out-of-the-box, end-to-end solution from one vendor that dramatically improved our data warehouse performance, while simplifying our support structure and reducing costs. Oracle provides a breakthrough business model for P&G. We're getting a total solution in a box,” Fortner said.

“From a performance standpoint, we can get, out of the box, with Oracle Exadata a much better performing application than we can by investing time, money, and resources in tuning the application on our legacy platform. From a price standpoint, getting a preconfigured, integrated, out-of-the-box solution from Oracle dramatically simplifies the amount of time and money we have to invest in building and maintaining our data warehousing platform,” said Brian Beckman, data warehouse platform manager, P&G.

“Oracle is one of P&G’s strategic partners,” he continued. “We’re counting on Oracle to drive innovations like Exadata into P&G to help us digitize our business and enable better analysis of consumer behavior so we can touch and improve more lives more completely.”