Nationwide’s legacy reporting system, which catered to the needs of property and casualty business units, took weeks to compileSample Page and deliver the needed reports to the agents. Nationwide determined that it needed better access to sales and policy information to reach its sales targets. It chose a single data warehouse approach and, after careful assessment of the needs of sales management and individual agents, selected a business intelligence platform that would integrate dynamic enterprise dashboards into its reporting systems, making it easy for the agents and associates to view policy information at a glance. The new reporting system, dubbed Revenue Connection, also enabled users to analyze the information with a lot of interactive and drill-down-to-details capabilities at various levels that eliminated the need to generate custom ad hoc reports. Revenue Connection virtually eliminated requests for manual policy audits, resulting in huge savings in time and money for the business and technology teams. The reports were produced in 4 to 45 seconds, rather than days or weeks, and productivity in some units improved by 20 to 30 percent.

1. Why did Nationwide need an enterprise-wide data warehouse?

2. How did integrated data drive the business value?

3. What forms of analytics are employed at Nationwide?

4. With integrated data available in an enterprise data warehouse, what other applications could Nationwide potentially develop?