Bread-and-Butter: Classic OWB Implementations in the News
By antonio romero on Feb 02, 2010
I'm taking some time off at the moment (back next week, no worries) but things still land in my inbox, and I can't help but look at them and sometimes process them... So when a couple of classic OWB implementations showed up in press releases this week, I figured I had to share them with the blog readership.
Solid, successful implementations that tap into the strengths of Oracle databases and Warehouse Builder no doubt happen all the time, so in that sense it's not news, but each was important enough to the parties involved for a press release, and we were important enough to each one to be called out by name, so... here they are.
Oklahoma streamlines reporting of public funding data with Oracle
The Oklahoma Office of State Finance has gone to Oracle to streamline the reporting of public funding data and integrate it with other electronic records.
The Oklahoma Office of State Finance has implemented Oracle Database, Oracle Warehouse Builder and Oracle Business Intelligence Suite Enterprise Edition Plus, to more effectively manage and improve visibility into American Recovery and Reinvestment Act (ARRA) funding data.
The Oracle software enables the Office of State Finance to efficiently manage and collect data related to awards, sub-awards and vendor payments from more than 25 state agencies and higher education institutions, that have received federal funding under ARRA.
The system can then automatically submit the data in reports mandated by the Office of Management and Budget (OMB) to the FederalReporting.gov website. The Oracle software enables the department to better cleanse, combine and report the data, improving data accuracy.
Hitachi Helps Whitbread with Business Performance
Consolidated 1.5 TB Data Warehouse Delivers Six Figure ROI for UK's Largest Hotel and Restaurant Company - 600 Reports Delivered Weekly and Accessed by 400 Remote Users
Hitachi Consulting UK today announced the successful migration and consolidation of the corporate Management Information Systems (MIS) for Whitbread PLC. Hitachi Consulting created a 1.5 terabyte Data Warehouse using Oracle Warehouse Builder, transforming analysis and reporting capabilities across its hotel and restaurant businesses by providing better business insight, sales and margin analysis and strategic planning, which delivered a six-figure return on investment over 12 months.
Whitbread is the UK's largest hotel and restaurant company operating market-leading businesses in the budget hotels and restaurant sectors. Its brands include Premier Inn, Beefeater, Table Table, Brewers Fayre, Taybarns and Costa Coffee. The group employs more than 33,000 people and serves 9 million customers every month in its 1,800 outlets across the UK.
The Data Warehouse delivers a single customer view of business performance of key data across its hotel and restaurant businesses, which accounts for 90 percent of group revenue. As a result of the successful rollout, Hitachi Consulting is currently embarking on a similar project for Costa Coffee, the largest and fastest growing coffee shop chain in the UK.
Hitachi Consulting created a 1.5 terabyte Data Warehouse, comprising more than 1.5 billion rows of data across the company's hotel business, restaurant business, its Commercial Division, as well as its Labour and HR Division. The system was built using Oracle Warehouse Builder, Oracle 10g database, and Oracle Business Intelligence. The solution enables Whitbread to analyse data and KPIs in multiple ways by manipulating data more effectively and providing better reporting at the executive level across the group.