BI Goes Mainstream at Procter &Gamble - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Government // Enterprise Architecture
Commentary
2/29/2008
09:07 AM
Sandy Kemsley
Sandy Kemsley
Commentary
50%
50%

BI Goes Mainstream at Procter &Gamble

Philip Bierhoff, Systems Manager at Procter & Gamble, spoke at last week's FASTforward conference about strategies to increase user adoption as business intelligence goes mainstream. P&G's Symphony project creates "decision cockpits": dashboards based on specific roles and corporate divisions, and including information ranging from traditional BI reports to documents to news...

Philip Bierhoff, Systems Manager at Procter & Gamble, spoke at last week's FASTforward conference about strategies to increase user adoption as business intelligence goes mainstream [Editor's note: it's a topic very much at the center of Cindi Howson's recent feature on "Pervasive BI"]. P&G's Symphony project creates "decision cockpits": dashboards based on specific roles and corporate divisions, and including information ranging from traditional BI reports to documents to news.

The underlying data landscape has moved from their first iteration of a common data warehouse in the mid-'90s with regional servers plus ETL, storage and aggregation, where BI was driven by stored aggregations; to the current atomic data warehouse with a central server plus ETL and storage, where BI is driven by query rewrite - effectively, aggregation on the fly. They also have SAP generating data into SAP/BW; altogether, they have about 65 TB in the data warehouse and 50 TB in SAP/BW.Originally, P&G used a traditional monolithic BI approach using a BI tool that acted as a portal as well as providing dashboards, graphs and reports as well as its own security layer. They had some challenges with scalability, and the boundary behavior when they pushed the size of the envelope. They felt restricted by the functionality of the tool and by the lack of flexibility. Based on these restrictions, they developed a new vision of BI based on service-oriented architecture (SOA) and industry standards, working directly from the corporate data warehouse instead of reporting data marts. A thin layer of BI is one of multiple layers of technology that can be changed out as required. The resulting solution uses an SOA-based (I assume JSR168-compliant) portal with various portlets, fed by FAST Radar for BI repots and graphs, and SharePoint for document storage. Under all of this is a service bus connecting to a data services platform, which in turn connects directly to the data warehouses and legacy applications. A WS-Security stack sits alongside to provide standard security and authentication.

Bierhoff says P&G selected FAST Radar because it pairs simplicity with power for fast response times, fits into a portal architecture, downloads to common formats such as Excel and PDF, requires no data model maintenance and can use Web services as a data source in additional to traditional database access. The company has found that FAST Radar needs very little training for creating and using reports, says Bierhoff, although they're still using it only for predefined reports with drill-downs rather than allowing ad hoc report creation. The time to create complex reports has dropped from 30 to 60 seconds with the old BI tool to five to ten seconds using FAST Radar.

The resulting architecture looks like a textbook example of how to do SOA correctly. They're getting a good level of reuse of services, especially the data access services, and they're positioned for future extensions without completely overhauling the architecture. They're able to provide customized dashboards for their 40,000-person user base in a reasonable time frame, in a large part because they've designed the underlying services and components for reuse.Philip Bierhoff, Systems Manager at Procter & Gamble, spoke at last week's FASTforward conference about strategies to increase user adoption as business intelligence goes mainstream. P&G's Symphony project creates "decision cockpits": dashboards based on specific roles and corporate divisions, and including information ranging from traditional BI reports to documents to news...

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
News
8 AI Trends in Today's Big Enterprise
Jessica Davis, Senior Editor, Enterprise Apps,  9/11/2019
Slideshows
IT Careers: 10 Places to Look for Great Developers
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/4/2019
Commentary
Cloud 2.0: A New Era for Public Cloud
Crystal Bedell, Technology Writer,  9/1/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Data Science and AI in the Fast Lane
This IT Trend Report will help you gain insight into how quickly and dramatically data science is influencing how enterprises are managed and where they will derive business success. Read the report today!
Slideshows
Flash Poll