OBIEE Success Stories
Cox Communications - Custom OBIEE deployment replacing Business Objects
Since 1962, Cox has built high-quality communications networks and delivered quality cable television programs. They have over 6 million residential and commercial clients and over 22,000 employees. As a full-service provider of telecommunications products, Cox offers an array of advanced digital video,high-speed Internet and telephony services over its own nationwide IP network, as well as integrated wireless services.
Cox Communications made Oracle BI its enterprise standard, working with KPI Partners to convert its Business Objects applications to Oracle Business Intelligence. In total, over 1500 reports and 25 Business Objects universes were converted using KPI’s industry-leading BI conversion methodology and technical expertise with Business Objects to Oracle BI conversions. Cox Communications achieved significant cost savings and also established a BI Center of Excellence with this project. In conjunction with KPI Partners and Oracle Product Marketing, Cox Communications presented their experiences with OBIEE and BI Centers of Excellence at Oracle Open World 2009.
Royal Caribbean Cruise Line - OBIEE supports launch of the world's largest cruise ship
Royal Caribbean is one of the largest cruise ship companies in the world with 20 ships with a total capacity of over 50,000 passengers, including the world’s largest cruise ship, Oasis of the Sea. In 2009, Royal Caribbean will visit 251 ports, in 76 countries, on 6 continents. Royal Caribbean had 2008 revenue of $5.8 billion and over 49,000 employees.
Royal Caribbean needed to increase the sales of high margin products such as alcoholic beverages. To do this, Royal Caribbean needed to identify the affinities of different age groups from different countries for different beverages. In addition, customer spend at different venues such as pool bars, restaurants, etc. can be compared to historical trends to ensure that menu selections are meeting customer needs.
KPI’s team worked with Royal Caribbean to design the data warehouse data model, create OBIEE metadata, reports and dashboards. This work was done using KPI’s OBIEE Quick Start methodology in 6 weeks ! The result was an industry leading BI application that provided critical business insight into the operations of the world’s largest cruise ship.
Audatex - Custom OBIEE deployment with Oracle MapViewer
Audatex is one of the largest insurance claims processing companies in the world. It has 300 insurance company customers and delivers many of its applications based on the software as a service or hosted model.
KPI’s team worked with Audatex to design the data warehouse data model, create OBIEE metadata reports and dashboards and integrate the application with Oracle Mapviewer in a highly secure, extranet environment. The result was an industry leading BI application that leapfrogged Audatex’s competitors and was recognized by Audatex’s CEO as was one of the top applications of the year. In conjunction with KPI Partners and Oracle Product Marketing, Audatex presented their experiences with OBIEE at Oracle Open World 2009.
Sallie Mae - OBIEE on Essbase
Sallie Mae is the nation's leading provider of student loans. Sallie Mae is a client that likes to push the edge of technology, implement new features and versions at times before they are widely deployed. KPI has implemented much of their business intelligence and dashboards using OBIEE. In particular, KPI implemented the first production application of OBIEE on Essbase cubes. In conjunction with KPI Partners and Oracle Product Marketing, Sallie Mae presented their experiences with OBIEE, Essbase and Oracle BI Applications at Oracle Open World 2009.
Bank of Hawaii - Custom OBIEE deployment replacing Business Objects
Bank of Hawaii was using a hosted implementation of Business Objects. This was costing them more than an in-house implementation would have, and was not giving them the functionality and business agility that they needed. They needed to convert 80 Business Objects reports and 5 universes to OBIEE. The data warehouse was a star schema that was well suited to the strengths of the OBIEE product. This was done in 5 weeks with two on-site consultants from KPI Partners. The result was a lower cost of ownership (TCO) for the Bank of Hawaii and the agility they needed to support user needs more quickly than the previous solution.
Travis Credit Union - Custom Incentive Analytics Solution
Travis Credit Union (TCU) is a not-for-profit cooperative financial institution. TCU is one of the largest credit unions in California with more than 158,000 members and more than $1.6 billion in assets.
The Employee Incentive Analytics project that includes data warehouse, ETL and reports and dashboards streamlines the incentive calculation process, eliminates the need of manual intervention that drastically reduces resources audit department needs to spend on the process monthly. The new process eliminates issues that existed in the legacy system due to its limitations. It also provides much higher accuracy of payroll data free of human errors caused by manual spreadsheet maintenance. Finally, the new product provides visibility and transparency to the incentive process that emphasizes the positive effect of the incentive process on the financial results. Switching to the new technology allowed delivering visible results on daily basis with great accuracy as an opposite to monthly reports delivered by the legacy system.
Dealer Tire - Custom OBIEE Applications
Dealer Tire is a leading trading company that specializes in tires and auto accessories supply. Their profit margins are principally derived from their business model which relies mostly on the performance of their information systems, and more precisely reporting. KPI was able to deliver a complete reporting model that covers all of Dealer Tires functional areas in a record time. Indeed, complex business logic was migrated from a custom application (Blue Sky) and augmented to support futuristic vision of how the company wants to do business. Custom sales, CRM, Accounting, Finance, GL, AR, and AP analytics were all implemented using ETL tools and OBIEE in a very short development lifecycle with 100% user acceptance. KPI was able to instill the BI culture and vision with enthusiasm at Dealer Tire.
State of Louisiana - 6 week OBIEE Quick Start
The State of Louisiana’s Department of Environmental Quality (LADEQ) mission is to provide service to the people of Louisiana through comprehensive environmental protection in order to promote and protect health, safety and welfare while considering sound policies regarding employment and economic development.
At LADEQ, KPI Partners implemented a 6 week OBIEE Quick Start. The goal of the OBIEE Quick Start was two-fold. Firstly, to have KPI’s consultant mentor and provide knowledge transfer to the LADEQ team. Secondly, work with the LADEQ team to implement a set of OBIEE reports and dashboards on the LEAU Water Quality database. The project involved 5 days of OBIEE training followed by six weeks of implementation and knowledge transfer. In addition to OBIEE metadata and report/dashboard development, KPI helped design Oracle database materialized views to convert the LEAU database data structure from a normalized transaction structure to a star schema structure optimized for performance and easy for end users to answer their business questions.