P&G Gains POS Insights with New Data Warehouse
To foster innovation and effectively meet changing market demands, the P&G Global Business Services (GBS) (www.pg.com) organization relies on insight from terabytes of point-of-sale (POS) 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, which included multiple Oracle and non-Oracle database environments.
GBS wanted to find a way to improve the performance and cost-effectiveness of its infrastructure and expand its analytical and brand decision-making capabilities. Consolidating POS data into a single data warehouse platform was fundamental to these objectives.
GBS selected Oracle Exadata Database Machine (www.oracle.com) as the foundation for its new data warehouse infrastructure.
“With Oracle Exadata, we have a single machine combining hardware and software that forms the foundation for our business intelligence environment,” reports Jim Fortner, vice president of IT development and operations, P&G. “This simplifies our IT landscape significantly, helps us reduce costs, and gives us a single partner for managing our end-to-end environment.”
With the implementation, the company consolidated customer POS 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. For example, GBS can complete some POS queries up to 30 times faster. In addition, the company streamlined operations and improved stability by consolidating information.
“We can conduct analysis and respond to the data much quicker than ever before,” closes Fortner.
Fast Facts
The Chosen One
P&G’s new data warehouse solution provides a complete package of software, servers and storage that deploys rapidly and streamlines IT management.
Opportunity Area
P&G’s legacy data warehouse infrastructure, which included multiple database environments, was costly and inefficient, restricted business agility, and resulted in siloed customer data.
Rapid Results
Prior to implementation, one periodic end-user POS query required upward of 20 hours to complete, sometimes failing to complete entirely. With its new data warehouse, the same query takes three minutes to complete.
Words of Wisdom
“We had essentially two challenges in the data warehouse space. We wanted to cut costs and improve performance when analyzing massive amounts of data.”
— Corrado Azzarita, Director, IT Development and Operations, P&G
As data volume and business intelligence requirements grew, the company began to reassess its legacy data warehouse environment, which included multiple Oracle and non-Oracle database environments.
GBS wanted to find a way to improve the performance and cost-effectiveness of its infrastructure and expand its analytical and brand decision-making capabilities. Consolidating POS data into a single data warehouse platform was fundamental to these objectives.
GBS selected Oracle Exadata Database Machine (www.oracle.com) as the foundation for its new data warehouse infrastructure.
“With Oracle Exadata, we have a single machine combining hardware and software that forms the foundation for our business intelligence environment,” reports Jim Fortner, vice president of IT development and operations, P&G. “This simplifies our IT landscape significantly, helps us reduce costs, and gives us a single partner for managing our end-to-end environment.”
With the implementation, the company consolidated customer POS 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. For example, GBS can complete some POS queries up to 30 times faster. In addition, the company streamlined operations and improved stability by consolidating information.
“We can conduct analysis and respond to the data much quicker than ever before,” closes Fortner.
Fast Facts
The Chosen One
P&G’s new data warehouse solution provides a complete package of software, servers and storage that deploys rapidly and streamlines IT management.
Opportunity Area
P&G’s legacy data warehouse infrastructure, which included multiple database environments, was costly and inefficient, restricted business agility, and resulted in siloed customer data.
Rapid Results
Prior to implementation, one periodic end-user POS query required upward of 20 hours to complete, sometimes failing to complete entirely. With its new data warehouse, the same query takes three minutes to complete.
Words of Wisdom
“We had essentially two challenges in the data warehouse space. We wanted to cut costs and improve performance when analyzing massive amounts of data.”
— Corrado Azzarita, Director, IT Development and Operations, P&G