OLAP Newsletter Customer Feature
Compass Group, Australia Pty implements Essatto BIPM
Ioppolo & Associates have recently launched their upgraded Essatto Business Intelligence and Performance Management (BIPM) Suite. The upgraded product is based on Oracle Database and Oracle OLAP option. Compass Group Australia are one of the first customers to go live with the solution on Oracle 10g.
Compass have implemented Essatto BIPM as a strategic move to consolidate and streamline disparate business systems and practices. The effective result of this allows the employees to make tactical decisions at the operational level and at a strategic level through informed budgeting and planning in annual budgets, quarterly rolling forecasts and extensive monthly management reporting.
Data comes to Essatto from spreadsheets, Oracle Financials and other sources, from various sites across Australia and New Zealand. This ease of integration with Oracle Financials and the cost effectiveness of the solution were the main drivers behind choosing this solution for Compass. The single source of data provides different types of dashboard information.
The application is currently available to a diverse group of 50 users throughout the company, at different sites in Australia and New Zealand, enabling better decision making at many levels, from site managers to the Managing Director for example. Thus, the biggest business impact, has been the cultural shift to dynamic decision making; employees have the ability to make better 'self informed' decisions, which has a bottom line impact on the success of the company. The number of users is planned to grow to around 200, with further data sources, such as Accounts Receivable being incorporated, and more dashboards being made available together with further rollout of Essatto’s rolling forecast, budget development and scenario development capabilities.
David Bonomini, Compass Group Pacific, Finance Director, states "The dashboards enhance the visibility of our business data to a broad range of users, giving our sites greater control over their destinies by having heightened visibility of their operations ."
Technical Solution:Essatto is powered by Oracle’s Enterprise Edition and harnesses the power of Oracle OLAP option. Essatto can report OLAP (and/or relational) data collected from multiple sources. Examples in this implementation include Compass’ General Ledger and Payroll systems. Essatto combines application level reporting with the integration of third party reporting tools such as OBIEE. Other reporting tools can be integrated as required. These include Business Objects, Microstrategy etc. The OLAP model for financial data in Essatto is ten dimensional, with multiple hierarchies for each dimension. Standard Essatto structures were harnessed to deliver Client contract, service type, project and site type dimensions which allow excellent cross comparison of customers. 5 million input rows load and aggregate in 15 minutes on the Windows server. Data is updated three times daily during month-end, thus data is near real-time to the users enabling effective and predictive decision making on operations.
Guy Ioppolo, Director, Ioppolo & Associates, states "Essatto is used by many customers in the Asia Pacific region. The upgrade from Oracle Express to a Oracle 10g base install took our company considerable effort and time, but the advantage to customers is worth it; performance of Essatto is up to 5-10 times faster on average compared to the native Oracle Express Server equivalent. Our customers want to analyse bigger data sets, and Essatto more than delivers on this requirement. Essatto offers all the advantages of the Oracle Database such as scalability, performance and security and combines these features with pre-built functionality. This provides customers with a cost effective solution that can be delivered in a timely fashion."
About Compass Group Australia:
Compass Group PLC is the world’s largest food services and hospitality groups with over 388,000 employees in 55 countries around the world and annual group revenues in 2008 of over £11b.
Essatto is a powerful business application which utilizes the Oracle Database , with Oracle OLAP acting as a central aggregator, organiser and modeller of multi-dimensional data from various information sources. Benefits include single source of data for multiple modular access, easy setup of pre-configured performance management dashboards with drill-through capabilities on key performance metrics, built-in integration with Microsoft Excel and single, integrated environment for budget development, rolling forecasts of medium-term financial and operational data.
For more information see the presentation from Oracle OpenWorld 2009.
About Ioppolo & Associates:
Ioppolo & Associates are an APAC based firm of consultants specializing in Business Intelligence & performance management consulting and solutions implementation.
View more Oracle OLAP Customer and Partner references here.
More Database Downloads